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, data validation, pivot tables, scenarios, and what-if analysis.
Course Outline
- Cover worksheet revision
- See how to add advanced formatting and data validation
- learn to carry out text manipulation with functions
- Cover the rounding and count functions
- Understand what is an array function
- learn to linking workbooks together
- see how workspaces 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.
