On this instructor-led course you'll learn how to work effectively with spreadsheets and use tools to quickly organise, present and visualise data. You'll learn how to link cells and insert formula between sheets, and use absolute cell references. You'll also learn how to insert IF Functions, use the XLOOKUP Function and setup conditional formatting. We end the course showing you how to quickly create an Excel table, how to insert a Slicer, and how to insert a basic PivotTable.
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 basic Excel skills, eg be familiar with the topics covered on our Microsoft Excel Basic 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 Intermediate Skills.