Excel Forum
Similar Content
Highlight Every Other Row in a Selection in Excel - Table Formatting
Macro: This free Excel macro will highlight every other row in a selection of cells with a color ...
Update, Change, and Manage the Data Used in a Chart in Excel
Tutorial: In this tutorial I am going to show you how to update, change and manage the data used by ...
Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
Macro: This Excel macro filters data in Excel without the filter "arrow" appearing in the column ...
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



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





Got a Question? Ask it Here in the Forum.