Automate tasks and analyse data in Excel on our 1-day Copilot course.

This hands-on course includes plenty of time to try things out and ask questions.

A complete beginnersguide to using Copilot with Excel.
Plenty of one to one attention and guidance.
Friendly expert trainers, small groups and a comfortable place to learn.

Full Course Details

Download full course details Download full course details

Copilot can save you a lot of time in Excel if you know how to use it. This session will give you that confidence.

  • Setting up and navigating Copilot in Excel
  • Writing prompts that get accurate, useful results
  • Using Copilot to build formulas, including the COPILOT function
  • Generating charts and graphs from plain English instructions

Then we will dig into the nitty-gritty of using Copilot with Excel, helping you analyse data and create formulas.

  • Asking Copilot questions about your data to surface patterns and summaries
  • Generating PivotTables automatically and asking Copilot to explain what they show
  • Writing, fixing and building multistep formulas using plain English descriptions

Data cleaning is one of the most time-consuming problems in Excel – Copilot can take care of it for you.

  • Removing duplicates, standardising formats and splitting fields using prompts alone
  • Working through a hands-on exercise cleaning a realistic messy dataset
  • Applying Copilot to PivotTables, forecasting and large datasets
  • Sharing workbooks with Copilot features intact and collaborating with tracked changes

Am I Ready For This Course?

This course is designed for individuals who have not used Copilot or AI before.

You will need to have attended our Excel Intermediate course or have the equivalent knowledge.

The Training Day

Our courses include everything that you need for a really productive day of training.

Our courses run from 9.30am to roughly 4:30pm with refreshments and biscuits throughout the day and a break for lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet!