Students will learn advanced skills for using Excel more effectively.
Excel XP (2002): Level 2 (or equivalent experience)
- Customize the work area by creating a custom toolbar, custom styles and a template file
- Use the Auditing features including tracing formulas, cell dependents and precedents
- Create and work with Pivot Tables
- Compare and contrast worksheet files and file links
- Outline and consolidate worksheets
- Use the Goal Seek, Solver and Scenario Manager to analyze worksheet data
- Document your worksheet using Comments; control the display of information in a cell
- Create and save different displays using the Custom Views command
- Manage Excel default settings and properties
- Introduction to Macros