How to Create Outlining Data In Excel
Oct 27, 2020
Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns.
How to Delete Duplicates in Excel
Oct 27, 2020
This example teaches you how to remove duplicates in Excel. Go here to only find duplicates.
How To Use Number and Text Filters In Excel
Oct 27, 2020
This example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria.
How To Use Subtotal function in Excel
Oct 27, 2020
Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or to ignore manually hidden rows.
How To Use Date Filters In Excel
Oct 25, 2020
This example teaches you how to apply a date filter to only display records that meet certain criteria.
How To use the Advanced Filter to create more powerful filters In Excel
Oct 24, 2020
This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria.
How to Create Data Form In Excel
Oct 24, 2020
The data form in Excel allows you to add, edit and delete records (rows) and display only those records that meet certain criteria.