Excel Forum
Similar Content
Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...
SUBTOTAL Function - Work on Filtered Data in Excel
Tutorial: Perform basic functions on a filtered dataset in excel, including SUM, AVERAGE, COUNT, COU...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Basics #21: Data Analysis Filter &Dynamic Ranges


The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#21 Video topics:
1)Filter Text
2)Filter Number
3)Filter Date
4)Filter by color
5)Sort by color
6)Excel Table or List Sort Filter Dynamic Ranges
7)Function with Dynamic Range (Range updates when records added)
8)Excel Table Ctrl + T
9)Excel List Ctrl + L





Got a Question? Ask it Here in the Forum.