|
Featured Tutorial
Featured Macro
Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Learn how to use the Excel Table Feature to create dynamic ranges for functions, charts and PivotTables.
2. Dynamic means that if you add new records to the bottom of the table (Tab in lower right corner) the ranges in formulas, charts and PT will update.
3. Ctrl + T to create Table
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Learn how to use the Excel Table Feature to create dynamic ranges for functions, charts and PivotTables.
2. Dynamic means that if you add new records to the bottom of the table (Tab in lower right corner) the ranges in formulas, charts and PT will update.
3. Ctrl + T to create Table