Microsoft Excel

Gaining Steam in Excel: An Intermediate Guide

1 hour
Live
All levels
Next: 2026-08-28

About this course

Gaining Steam in Excel: An Intermediate Guide

Build on your Excel foundations and start working confidently with structured data

Duration 60 minutes
Level Intermediate
Completion Certificate + Badge

Course Overview

This session is the second part of the Excel learning series and is designed for users who already understand the basics of spreadsheets and want to start working more confidently with data.

You will focus on preparing and controlling data using tools such as data cleansing techniques, data validation, conditional formatting, tables, and filtering. The session demonstrates how these features make spreadsheets easier to use, safer to share, and more insightful.

By the end of the session, you’ll be able to structure data properly, highlight key information, and reduce errors when working with shared Excel files.

Skills Gained

Data Cleansing Data Validation Conditional Formatting Tables & Filters Spreadsheet History

What You'll Learn

Preparing Data – Clean and restructure raw data to make it easier to work with.
Data Validation – Control what users can enter into cells using rules and drop‑downs.
Conditional Formatting – Automatically highlight trends, values, and exceptions in your data.
Filtering Data – Interrogate datasets to show exactly what matters.
Version History – Review spreadsheet and cell‑level history to track changes.

Who Is This For?

This course is perfect for:

Users who have completed a beginner Excel session
Anyone working with shared or structured datasets
Learners preparing for advanced Excel features

Prerequisites

Microsoft 365 account. Completion of our beginner Getting started with Microsoft Excel session is recommended.      

Upon Completion

Digital Badge

Shareable credential for LinkedIn and professional profiles

Certificate of Completion

Official certificate to showcase your achievement

Upcoming live sessions

Aug
28
10:30 GMT
Live Session Morgan d'Arcy
Sept
24
15:00 GMT
Live Session Morgan d'Arcy
Oct
16
10:30 GMT
Live Session Morgan d'Arcy

Frequently asked questions