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 CopilotMastering Your Data: Using Copilot in Excel
Microsoft Copilot

Mastering Your Data: Using Copilot in Excel

Live
All levels
Next: 2026-06-17
Book a SessionRequest Team Booking

About this course

Copilot in Excel: Master Your Data

Stop fighting with formulas and start asking questions. Use Copilot as your personal Data Analyst.

Duration 30 minutes
Level Beginner
Completion Certificate + Badge

Course Overview

This session explores how Copilot transforms Excel into an intuitive, question‑driven data analysis experience. Instead of wrestling with formulas or navigating complex spreadsheets, you’ll learn how to ask natural language questions and let Copilot explain, analyse, and visualise your data.

You will discover how Copilot can break down complicated formulas, surface hidden trends, clean up inconsistent datasets, and generate charts or tables to support better decision‑making. The session also highlights the importance of working with structured tables and cloud‑saved files to ensure Copilot performs reliably.

By the end of the session, you’ll be able to use Copilot as your personal data analyst—helping you understand, interrogate, and forecast your data with confidence.

Skills Gained

Data Explanation & Interpretation Formula Auditing with Copilot Data Visualisation Trend & Forecast Identification Effective Prompting in Excel Working with Cloud-Based Excel Files

What You'll Learn

• Getting Excel Ready – Setting up your workbook for Copilot success, including tables, cloud saving, and updates.
• Formula Explanations – Using Copilot to break down complex formulas and explain the logic behind calculated values.
• Data Insights – Asking Copilot to identify trends, patterns, and anomalies within large datasets.
• Visualisations – Generating charts, tables, and summaries through natural language prompts.
• Trend Forecasting – Identifying risks, bottlenecks, and inventory issues using Copilot’s analytical features.
• Web vs Desktop – Understanding the performance differences between Excel for the Web and Excel Desktop.

Who Is This For?

This course is perfect for:

✓ Anyone who works with data in Excel
✓ Users overwhelmed by formulas or large datasets
✓ Professionals seeking quicker insights and visualisations
✓ Anyone wanting to use natural language to analyse data

Prerequisites

A basic understanding of Microsoft Excel is required to get the most out of this training.

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
Copilot Essentials for Sales and Business Development

Copilot Essentials for Sales and Business Development

Live
Copilot Essentials for People Managers

Copilot Essentials for People Managers

Live

Upcoming live sessions

Jun
17
10:30 GMT
Live Session Jake Hall
Book Session

Frequently asked questions

Next Session
2026-06-17
Live
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
Copilot Essentials for Project Management

Copilot Essentials for Project Management

Live