On this course we'll start by showing you how to import, select, navigate and enter data. The course will also show you how to use functions to work with numbers, dates, text and cell content. You'll learn how to join cells, and use linking to enter and 'clean' data. We'll end the course by showing you tools and functions to find blank cells and duplicate data.
Entry Requirements
Learners should have good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate 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 good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate 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 good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate 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.
