Sorting data is an integral part of data analysis. You might want to arrange a … Read More
This chapter teaches you an easy way to reverse a list in Excel. For example, … Read More
How to randomize / shuffle a list in Excel.
For example, we want to randomize … Read More
How to apply a number filter and a text filter to only display records that … Read More
This example teaches you how to apply a date filter to only display records that… Read More
The data form in Excel allows you to add, edit and delete records (rows) and… Read More
Outlining data makes your data easier to view. In this example we will total rows … Read More
The SUBTOTAL function ignores any rows that are not included in the result of a … Read More
Filter setting using — And Criteria, Or Criteria or Formula as Criteria
This example teaches … Read More
When duplicates are removed in Excel, the first occurrence of the value in the list … Read More
Filter your Excel data if you only want to display records that meet certain criteria.… Read More
You can sort your Excel data on one column or multiple columns. You can sort … Read More
Remove Duplicate Rows Using the Excel Remove Duplicates Command.
In Excel, the Remove Duplicates command … Read More