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 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 basic Excel skills, eg be familiar with the topics covered on our Microsoft Excel Basic 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 Intermediate Skills.
The next course is scheduled to run on the following days/times:
Session 1: Wednesday 29th November (GMT 8pm-9pm)
Session 2: Wednesday 6th December (GMT 8pm-9pm)
Session 3: Wednesday 13th December (GMT 8pm-9pm)
Session 4: Wednesday 20th December (GMT 8pm-9pm)
£59 * per person.
* special introductory offer for bookings made by 30th November 2023.