Maximize the capabilities of Microsoft Excel 2007! This course is intended for Excel users who want to improve their efficiency. You will learn about advanced functions and list management; create PivotTables and PivotCharts; importing text files; using analysis tools; and running and recording macros. Also, conditional formatting and SmartArt Graphics will be covered.

Prerequisite: Working knowledge of topics covered in Excel: Intermediate.

Key Topics Covered

1) Create named ranges and advanced functions such as IF and SUMIF.
2) Use lookup functions and create data tables.
3) Create subtotals and explore database functions.
4) Crate data validation and pivot charts for analyzing large amounts of data.
5) Import and export text files.
6) Use analysis tools such as Goal Seek and Solver.
7) Run, record, and edit macros.
8) Use conditional formatting and SmartArt graphics.