Microsoft Excel 2007 - Advanced User
This one-day course covers features for experienced users of Excel, and an ideal follow-on from the Beyond the Basics course. Covering worksheet revision, advanced formatting & data validation, pivot tables, scenarios, and what-if analysis.
Course Outline
- Worksheet revision
- Advanced formatting and data validation
- Text manipulation with functions
- Linking workbooks
- Workspaces and workbook protection
- Data consolidation and formula auditing
- Pivot tables and pivot charts
- Scenario manager
- Using solver for 'what if' analysis
Who would benefit from the course?
This course is designed for people who are looking to use more features of their spreadsheet to give their work that extra polished look and functionality.
Pre-requisites
A basic understanding of Excel is required, or attendance at our Excel Beyond the Basics course.
