In Excel 2003, they were referred to as 'Lists'. In Excel 2010 they are referred to as 'Tables'. In Episode #1312, Bill takes a look at Tables and how the use of this feature allows Charts, Pivot Tables and Formulas to grow as the Data Set grows!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Rev up to Excel 2010, chapter 13.
Tables.
Hey! Welcome back to the MrExcel netcast.
I'm bill Jelen.
The tables started back in Excel 2003, they weren't called tables, they were called lists.
It was [ ctrl L ] back then and I didn't respect the feature, I didn't understand the feature.
It would add the auto filter drop-down.
So, I knew how to do that.
It gave me the ability to toggle a total on the last column.
It really wasn't that useful but I completely missed the point of the list or now the table.
It's that the charts and pivot tables and formulas the point that table will automatically grow as the table grows.
A table is any range typically as headings in row 1 and then rows and rows of data.
Now, to define this range as a table.
I'll do [ ctrl T ] for table, identifies where the table is, so A1 to D5, my table has headers, click [ ok ] and they apply a table format.
I can change that it's there but here's the beautiful thing, we have a chart here that was based on that range is now based on that table.
Notice, I can retro actively define the table and if I add new data, so I'll come here and do week 4.
That new data automatically becomes part of the charts.
Gets one 15,000 here ,15,000 [ control enter ] and the new data is added to the chart.
If I would add a new row to the charts that we have the Northeast let's do the Midwest.
You see that now becomes part of the calculation.
So, we'll just put 5,000 there and we get a new Midwest item in chart.
So, very cool.
Charts that are based on tables, pivot tables are based on tables or formulas, that are based on tables will automatically grow as the table grows either with new rows or new columns.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Rev up to Excel 2010, chapter 13.
Tables.
Hey! Welcome back to the MrExcel netcast.
I'm bill Jelen.
The tables started back in Excel 2003, they weren't called tables, they were called lists.
It was [ ctrl L ] back then and I didn't respect the feature, I didn't understand the feature.
It would add the auto filter drop-down.
So, I knew how to do that.
It gave me the ability to toggle a total on the last column.
It really wasn't that useful but I completely missed the point of the list or now the table.
It's that the charts and pivot tables and formulas the point that table will automatically grow as the table grows.
A table is any range typically as headings in row 1 and then rows and rows of data.
Now, to define this range as a table.
I'll do [ ctrl T ] for table, identifies where the table is, so A1 to D5, my table has headers, click [ ok ] and they apply a table format.
I can change that it's there but here's the beautiful thing, we have a chart here that was based on that range is now based on that table.
Notice, I can retro actively define the table and if I add new data, so I'll come here and do week 4.
That new data automatically becomes part of the charts.
Gets one 15,000 here ,15,000 [ control enter ] and the new data is added to the chart.
If I would add a new row to the charts that we have the Northeast let's do the Midwest.
You see that now becomes part of the calculation.
So, we'll just put 5,000 there and we get a new Midwest item in chart.
So, very cool.
Charts that are based on tables, pivot tables are based on tables or formulas, that are based on tables will automatically grow as the table grows either with new rows or new columns.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
