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!
10 Hours of 1-to-1 training
You’ll receive 10 hours of 1-to-1 training from an EC-PC Tutor. During the training sessions we’ll cover core topics from the course, or we can customise the sessions to cover what you need to know!
Flexible training times
Training can be delivered over 2 days, or over a period of time (eg 1 hour a week for 10 weeks).
Learn online or face-to-face
Training can be delivered remotely using Microsoft Teams, or face-to-face at our Aberdeen Training Centre.
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.
Certification
Once you have completed the online course we’ll send you a practical assessment. Pass the assessment and you’ll receive the following e-Certificate: EC-PC Microsoft Excel Proficient User.
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.
Cost
£500
Jose Miguel Rodriguez Barrera
![](https://ec-pc.com/wp-content/themes/ec-pc/assets/img/constants/quote-left-blu.svg?v2")
