On this course we'll start by showing you how to use grouping and auditing tools, and how to work with tables and setup advanced filters. The course will show you how to insert and understand nested functions. You'll also setup advanced conditional formatting and learn ways to identify blanks cells, find duplicate data and work with PivotTables. We end the course by showing you how to get started creating and using Macros!
1-to-1 training
Our 1-to-1 training sessions can be customised to cover core topics from the course – learn what you need to know!
Flexible training times
The full course is delivered over 2 days, or over a period of time (eg 1 hour a week). We also offer a shorter version of the course covering core topics – view course outline.
Learn online or face-to-face
Training can be delivered remotely using Microsoft Teams, or face-to-face at our Aberdeen Training Centre. We can also provide customised onsite training for 1 or more delegates – please contact us for a quote.
User-friendly notes
If you attend a face-to-face course you’ll receive a printed training manual. For remote courses we’ll send you a PDF manual.
Requirements
You’ll need to have existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course. To complete the course online you’ll need a Windows PC installed with Microsoft 365.
Jose Miguel Rodriguez Barrera
![](https://ec-pc.com/wp-content/themes/ec-pc/assets/img/constants/quote-left-blu.svg?v2")
Jack Patterson
![](https://ec-pc.com/wp-content/themes/ec-pc/assets/img/constants/quote-right-grn.svg?v2")
