New: Gemini July — Free Gemini training for your whole team in July →
Skip to content
Live LearningCo
For IT Teams
Drive adoption & reduce tickets
For Learning Teams
Scale training without headcount
Policy to Practice
Turn AI policies into capabilities
Technology Migration
Dedicated rollout support
Gemini July
Free Gemini training — July 2026
Microsoft Month
Free Microsoft training — May 2026
LMS Integration
Courses
Live Learning
ScheduleTrainers
Learning for Good
Free training for VCSE organisations
BlogCase Studies
PricingAbout
Free TrialBook a Demo
Live LearningCo

Live expert training for enterprise teams. Close the gap between software investment and real adoption.

Solutions
  • For IT Teams
  • For L&D Teams
  • Policy to Practice
  • Technology Migration
  • LMS Integrations
  • For Enterprise
  • Pricing
Courses
  • Microsoft 365
  • Google Workspace
  • AI & Copilot
  • View All
Company
  • About
  • Careers
  • Case Studies
  • Blog
  • Contact
  • Learning for Good
© 2026 Live LearningCo. All rights reserved.
Privacy PolicyTermsCookies
HomeCoursesMicrosoft ExcelGaining Steam in Excel: An Intermediate Guide
Microsoft Excel

Gaining Steam in Excel: An Intermediate Guide

1 hour
Live
All levels
Next: TBA
Book a SessionRequest Team Booking

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

You might also like

Browse all courses
Making the most of Functions and Formulas in Excel

Making the most of Functions and Formulas in Excel

1 hourLive
Using Pivot Tables in Excel

Using Pivot Tables in Excel

1 hourLive

Upcoming live sessions

No upcoming sessions scheduled yet. Get in touch to arrange a session for your team.

Request a Session

Frequently asked questions

Next Session
TBA
Book a SessionRequest team booking
Live interactive session
Expert certified trainer
Certificate of completion

Need help?

Not sure if this course is right for your team? Our learning specialists can help.

Chat with an expert
Getting Started with Excel

Getting Started with Excel

1 hourLive