Excel 2007 - Creating Tables

Dear Cristin

Thank you for attending Excel 2007 Intermediate Course. I hope you enjoyed the course.

Compared to earlier versions Excel 2007 Format as Table is one of the features that made significant changes to.

Once your list of data has been converted to Table you can perform the following features:

Auto filter is automatically applied. (Arrows next to all your column headings to filter your data.

If you add data to the right hand of the last column in your table it will automatically be formatted and taken as a part of that table. Similarly if you start adding data on the bottom of the last row in your table it will do the same.

When you perform calculation it you can simply use the name of the column headings instead of typing the cell name. e.g. instead of C4 you can Type [Commissions]. Please note that the name of the column heading is in Square brackets.

All the below options can be accessed from the Table tools > Design contextualized tab which appears on the title bar as a last tab:

Change different table style
Have a Different first and the Last column
Branded Rows and columns so that the data can be easily read
Total Row. This feature by default totals only the last column that has numeric data. But once you have the Total Rows you can click at the bottom of the individual column and choose the relevant function from the drop down list.
[b]Another interesting part of this Table facility is that if you have lots of rows and you start scrolling down you