Introduction to Excel
Introduction to Excel training helps your team use some of the basic and intermediate features in Microsoft Excel. Delivered on-site by our experienced trainers.
About the course
Use basic and intermediate features in Excel
By the end of the course, delegates will:
- Understand the basic features of Excel
- Know how to navigate through, add edit and delete Worksheets
- Know how to Filter data, Sort on multiple fields
- Understand how to use common Conditional Formatting tools
- Know how to add and edit rules relating to Conditional Formatting
- Know ways to remove duplicate data (de-duping)
- Understand how to use HLOOKUP, VLOOKUP and XLOOKUP Functions
- Be able to use SUMIF, AVERAGEIF, COUNTIF and related functions
- Know how to present data using Pivot Tables
- Be able to present data effectively using Charts and Graphs
- Be able to use functions to trim and combine data
- Be able to integrate Excel worksheets with other Office products
What you’ll cover
Full course content
Everything the course covers, exactly as our trainers deliver it:
Excel Basics
- What is Excel?
- Form and structure of worksheets
- Tools for autocompletion
Intermediate Features
- Filtering tools
- Sorting on multiple fields
- Conditional formatting
- Conditional Formatting rules
- Drop Down boxes
- CSV and other formats
- Delimiting characters for imported data
More Advanced Functions
- De-duping
- HLOOKUP, VLOOKUP and XLOOKUP
- SUMIF, AVERAGIF, COUNTIF and related functions
- Combining and Trimming data
Presenting Data
- Pivot tables
- Charts and graphs
- Integrating with other Office products
Keep exploring
Related leadership & management courses
These subjects sit naturally alongside this course — and we can combine courses into one visit.
Good to know
Frequently asked questions
Where is the training delivered?
All of our training is delivered on-site at your service, anywhere in the UK — we come to you, so there are no travel costs or venue hire for your team.
How long is the Introduction to Excel course?
It runs as a full day – 6 hours course, delivered in one visit unless stated otherwise.
How many delegates can attend?
Up to 15 delegates per session.
Do delegates receive a certificate?
Yes — every delegate receives a certificate on completion. Certificates are valid for 1 year, so plan refresher training before they expire.
How much does the course cost?
We price every course on application, based on your dates, location and delegate numbers. Use the contact buttons below — we reply quickly with a quote.
Can we combine courses into one visit?
Yes. Many clients build a full training day from shorter courses, and we can deliver several subjects in one visit — just tell us what your team needs.
Do you only train care providers?
No. This course suits care settings, schools & colleges, offices & workplaces, charities, public sector. If your sector isn’t listed, ask — we’ll tailor the course to your setting.
Book this course
We bring Introduction to Excel training to your service
Delivered on-site at your service, nationwide, with pricing on application. Tell us your dates and delegate numbers and we’ll reply quickly with a quote.
Part of our leadership & management training range. Also explore behaviour management training and mental health training.