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, using external data, data validation, pivot tables, scenarios, and what-if analysis.
Course Outline
- Cover worksheet revision
- Learn how to use advanced formatting to highlight data meeting various conditions
- See how data validation can control data input
- Learn to carry out text manipulation with functions
- Cover the rounding and count functions
- Understand what an array function is
- Learn how to use data from external databases and web sites
- Discover the difference between ranges and tables
- See how worksheet and workbook protection helps
- See how to consolidate data and audit formulas
- Learn about pivot tables and pivot charts
- Discover the scenario manager
- Cover using solver for 'what if' analysis
- Learn about using data tables 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.
