Explanation Remove Duplicates is a popular Excel tool that lets the user remove duplicates from a column or a set of columns. Learn with this tutorial how to remove duplicates…

Introduction Ever heard of Excel Flash Fill? From my experience and conversations with hundreds of professionals - 95% of them are not aware of this tool! In my humble opinion,…

Excel Sort Explained Using Excel Sort, you can easily sort your data.  You can sort your data in Ascending/Descending order if the column contains numbers or dates, and also sort…

Why should you use the Filter Tool? The Filter tool lets you quickly filter on the relevant data in your table. It can help you filter by text values, numbers,…

This test is an assessment tool that would help you with checking your level in excel. Upon completing the questions, you'll get an assessment of your level in excel. Please…