Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables

Excel Start File: people.highlin...
Excel Finished File: people.highlin...
Free Excel 2010 book: people.highlin...
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

[@excelisfun]

I am glad that you liked the videos! See you in Spring!

[@excelisfun]

I am glad that you like it!

[@sov19871987]

Nice. Something new and always something refreshing. I will take your BUSN 135 class in Spring (super smart students).

[@matuscajkovic702]

Hi, first I want to thank you for these classes and I want to ask how did you add the next date with a shortcut? I tried to use ctrl+D but it only added a previous date can you help me?

[@louisdelapena8695]

I use the ribbon, primarily Can this trick be done from there?