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!
Learn online or face-to-face
Training can be delivered remotely using Microsoft Teams, or face-to-face at your business premises in Glasgow.
Customised training
Training sessions can be customised to cover specific topics – learn what you need to know!
Flexible training times
Training can be delivered all in 1 day, or remotely over a period of time (eg 1 hour a week).
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")
