Looking for a dry run to test your skills in Excel? We created just for you financial data that you can practice! Use all the formulas you learned in Excel-Practice-Online…

Want to practice free-style?   The following worksheet enables you to practice your Excel-Online Skills without downloading Excel to your Computer! The data will be removed if you close/refresh this…

This is certainly one of my favorite tricks in Excel -  We all know how to pivot our data using Pivot Table, but what can we do when we want…

Introduction The Power Query Editor is a very powerful tool with dozens of different features and functionalities.   With so many features and tools, it's very easy to get lost when…

How many times you wanted to find a quick way to combine multiple Excel files into one workbook without Copy-Pasting? What if there was a way to combine data from…

Explanation Advanced Filter allows us to quickly filter based on several criteria that are predefined in a separate table. Advantages of Advanced Filter over “normal” filter: No need to choose…

Explanation Text to Columns is a useful tool that allows the user to split a certain column into multiple columns using a delimiter. Text to Columns can also be used…

Pivot Table is a great tool for summarizing and analyzing data in Excel. We can use a Pivot Table to perform calculations on our data based on certain criteria. For…

Explanation Conditional Formatting lets the user apply formatting to a cell or a range of cells based on specific criteria. There are various conditions that can be tested in order…