Get in-depth understanding of this powerful program. This course is for Microsoft Excel 2007 users who want to take advantage of some of the more powerful features of Excel. Learn about outlining, subtotaling, and advanced charting methods for high impact, clear presentation of your data. You’ll learn how to link and consolidate data between multiple worksheets, use advanced formatting features and use sorting and filtering list management tools. Document auditing and templates are covered too.  The hands-on exercises are based on "real world" situations using large spreadsheets.

Prerequisite: Excel: Introduction or equivalent experience.

You'll learn to:

1) Create outlines, subtotals, and name cells.
2) Use multiple worksheets for linking and consolidating data.
3) Save workbooks as web pages and use hyperlinks.
4) Use advanced formatting techniques such as borders, shading, and styles.
5) Sort lists by columns and filter lists based on criteria.
6) Format charts and add graphic elements.
7) Use auditing features, add comments, and protect worksheets
8) Work with templates.