Blank Excel Online Worksheet

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…

0 Comments

Power Query – Column from Examples

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…

0 Comments

Advanced Filter

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…

0 Comments

Text to Columns

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…

0 Comments

Pivot Table

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…

0 Comments

Conditional Formatting

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…

0 Comments

Remove Duplicates

Explanation Remove Duplicates is a popular Excel tool that lets the user remove duplicates from a column or a set of columns.  When applied on a range with more than…

0 Comments

End of content

No more pages to load