Automatic updating excel chart
If your table is larger than fits on a screen and you scroll down, Excel 2007 has a nice new feature: the column letters are temporarily replaced with the table’s column names (but only whilst you’re inside the table! Of course you can undo this expansion too, or switch off this behavior entirely.
When you insert or remove a row (or column) in your table, Excel will automatically adjust the formatting: alternate shading is kept nicely in place.
(see figure 13) Figure 13: Remove Duplicates dialog By pressing this button you demote the table back to a normal range. a pivot table on the range, the Pivot table’s source range will not be updated and the pivot table cannot be refreshed anymore.This button can be used to change the properties of the external data you have based your table on.If your table is a sharepoint list, this button enables you to open a browser window with that list.In fact, Tables in Excel 2007 are the successor of Excel 2003's "List" feature, with added functionality.This article introduces you into the concepts of working with Tables in Excel 2013, 20 and shows you how they may help you in your everyday Excel use. Of course you already have some data available somewhere on your sheet.