Excel Forum
Similar Content
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...
Filter and Sort Data on Charts in Excel
Tutorial: Create a dynamic chart in Excel that displays only the data you want. You can filter it an...

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.