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.

You will learn how to

• Work with worksheets
• Use advanced formatting to highlight data meeting various conditions
• Control data input with data validation
• Carry out text manipulation with functions
• Use the rounding and count functions
• Work with an array function is
• Protect worksheets and workbooks
• Use data from external databases and web sites
• Work with ranges and tables
• Consolidate data and audit formulas
• Work with pivot tables and pivot charts
• Set up slicers for filtering
• Use the scenario manager
• Carry out ‘what if’ analysis with the solver
• Use 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.