On this instructor-led course we'll start by showing you how to use grouping and auditing tools. We'll show you how to use the XLOOKUP Function, insert the IFS Function and use nested functions. We'll also setup protection, validation and use advanced conditional formatting. We end the course by showing you the power of PivotTables!
The course is delivered to small groups remotely using Microsoft Teams.
There are 4 instructor-led training sessions delivered over 4 weeks (each session lasts 1 hour).
Each week you’ll be given a ‘homework’ tutorial to complete to practice course topics and reinforce your learning. Email support will be available from the instructor to answer any queries.
Before attending the course you’ll need to have intermediate Excel skills, eg be familiar with the topics covered on our Microsoft Excel Intermediate Skills Course.
You’ll need to have a PC installed with Microsoft 365 and Microsoft Teams. You’ll need to have 2 monitors ( 1 monitor to view the instructor’s screen and 1 monitor to display Microsoft Excel for you to work with). Alternatively, if you have a large enough monitor then Microsoft Teams and Microsoft Excel could be arranged on your desktop.
You’ll receive a PDF training manual.
If you complete the course you’ll receive the following PDF Certificate: EC-PC Microsoft Excel Advanced Skills.
The next course is scheduled to run on the following days/times:
Session 1: Thursday 30th November (GMT 8pm-9pm)
Session 2: Thursday 7th December (GMT 8pm-9pm)
Session 3: Thursday 14th December (GMT 8pm-9pm)
Session 4: Thursday 23rd November (GMT 8pm-9pm)
£59 * per person.
* special introductory offer for bookings made by 30th November 2023.