Excel Filter Basics (for quick data analysis)

 Excel Filter Basics (for quick data analysis)

 

 

 

Find out how to filter your data in Excel. In this filter basics tutorial you'll learn the following:

1. The shortcut key to turn filter on and off in Excel 
2. How to do approximate matches (filter for words that contain a specific word) 
3. How to filter multiple columns 
4. How to filter for "or" conditions 
5. How to copy a filtered range to another sheet 
6. How to use formulas (such as subtotal) to sum a filtered range 
7. How to filter for values between 2 dates 
8. How to filter based on color
9. How to turn your data set into an Excel table (shortcut key) How to add totals to your Excel table

Related Topics:

• Why you SHOULD be USING Custom Number Formatting in Excel 
• Convert NUMBERS to WORDS (NO VBA) in Excel 
• Better Excel Presentations: Increase Font Size of Formula Bar 
• VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)