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 can be delivered at our Aberdeen Training Centre to small groups of up to 3 learners, or on a 1-to-1 basis. The following delivery options are available:
The course can be delivered onsite at your business premises to small groups, or on a 1-to-1 basis. The course is delivered over a half-day session lasting between 3 and 3.5 hours.
The course can be delivered remotely to small groups, or on a 1-to-1 basis. The following delivery options are available:
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.
If you attend a face-to-face course you’ll receive a printed training manual. For online remote courses we’ll send you a PDF manual.
If you complete the course you’ll receive the following PDF Certificate: EC-PC Microsoft Excel Advanced Skills.