Microsoft Excel - 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
- See how to use advanced formatting
- 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
- See how worksheet and workbook protection helps
- Learn how to use data from external databases and web sites
- 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.
