- my courses
-
Toggle navigation
On this course you'll learn how to be more productive using Microsoft Excel. The course will increase your knowledge of using formulas and inserting functions - eg TODAY, SUM, SUMIF, VLOOKUP, IF etc. We'll also show you how to create drop-down lists, sort data, filter data and setup conditional formatting. We end the course showing you the power of PivotTables to quickly summarise your data.
Entry Requirements
Learners should have some experience using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course.
Hardware/Software Requirements
Learners will need a Windows 10 PC and a reliable broadband connection. The PC will preferably have Microsoft 365 installed. Training can be delivered using other versions of Microsoft Office - please contact us for more details.
Course Duration
Up to 5 hours approximately - learn all in 1 day, or over 2 half-days, or over hourly lessons.
Training Times
Flexible training sessions can be booked during the day and/or evenings.
Course Notes
Learners will receive an electronic manual (a printed manual can be posted for an additional fee).
Certification
Learners who complete the course will receive an e-Certificate.
Customised Content
Training sessions can be customised to cover specific topics from the course.
Entry Requirements
Learners should have some experience using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course.
Course Notes
Learners will receive an electronic manual.
Certification
Learners who complete the workshop will receive an e-Certificate.
Virtual Training
Workshops can be delivered by a virtual EC-PC Tutor using Zoom or Microsoft Teams. Delegates will require 2 screens - one screen to view tutor demonstrations and one screen to practice with.
Onsite Training
Workshops can be delivered in person by an EC-PC Tutor, subject to Covid-19 guidelines.
Course Duration
Up to 5 hours approximately - learn all in 1 day, or over 2 half-days, or over hourly lessons.
Entry Requirements
Learners should have some experience using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course.
Training Times
Flexible training sessions can be booked during the day and/or evenings.
Course Notes
Learners will receive a printed manual.
Certification
Learners who complete the course will receive an e-Certificate.
Lunch
Learners who want to complete the course in 1-day will receive a complimentary voucher for lunch at So Aberdeen.
Customised Content
Training sessions can be customised to cover specific topics from the course.
We are currently developing online learning - please register your interest and we will send you more details.
