Microsoft Copilot for Excel puts the power of AI right into your spreadsheets and this course shows you exactly how to use it. Learn how to clean and analyse data, generate formulas, build dashboards, and create visual reports using natural language commands.

In this hands-on training, you’ll explore practical ways to streamline your Excel tasks, uncover insights, and boost productivity using Microsoft 365 Copilot. No coding required! just smarter ways to work.

By the end of the course, you’ll be able to:

  • Navigate and use Copilot features in Excel
  • Query data using natural language
  • Clean and audit data using built-in AI tools
  • Generate and troubleshoot formulas
  • Build PivotTables and visualisations
  • Format spreadsheets for readability and impact
  • Perform advanced analytics with Python in Excel
  • Summarise and present data clearly and professionally

Prerequisite:

You should be familiar with Excel basics, but no Copilot or AI experience is required.

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Upcoming Courses

Remote East

Brisbane

Sydney

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East
Date
Course
City
Status
Wed 3 Sep 25
Wed
3
Sep
Copilot for Excel
Remote East
Status: Scheduled
Scheduled
Tue 28 Oct 25
Tue
28
Oct
Copilot for Excel
Remote East
Status: Scheduled
Scheduled
Thu 27 Nov 25
Thu
27
Nov
Copilot for Excel
Remote East
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Copilot for Excel
Remote East
Status: Scheduled
Scheduled
Brisbane

We currently have no public courses scheduled. Please contact us to register your interest.

Sydney

We currently have no public courses scheduled. Please contact us to register your interest.

Melbourne
Date
Course
City
Status
Wed 3 Sep 25
Wed
3
Sep
Copilot for Excel
Melbourne
Status: Scheduled
Scheduled
Tue 28 Oct 25
Tue
28
Oct
Copilot for Excel
Melbourne
Status: Scheduled
Scheduled
Thu 27 Nov 25
Thu
27
Nov
Copilot for Excel
Melbourne
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Copilot for Excel
Melbourne
Status: Scheduled
Scheduled
Canberra

We currently have no public courses scheduled. Please contact us to register your interest.

Adelaide

We currently have no public courses scheduled. Please contact us to register your interest.

Perth

We currently have no public courses scheduled. Please contact us to register your interest.

Remote West

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Copilot Training Courses

Course Icon Copilot for M365

Learn how to use Copilot across Word, Excel, Outlook and more. Get hands-on with AI-powered tools to boost productivity and streamline everyday tasks.

download course pdf
Price: $440 $490
Course Icon Copilot for Outlook and Teams
New

Work smarter in Outlook and Teams. Learn how Copilot helps you manage emails, plan meetings and collaborate more efficiently.

download course pdf
Price: $504 $560
Course Icon Copilot for PowerPoint
New

Turn ideas into polished presentations with AI. Learn how to draft slides, enhance visuals and create content using natural language.

download course pdf
Price: $504 $560
Course Icon Copilot for Word
New

Write, edit and summarise documents faster with Copilot. Save time and improve quality using AI in Microsoft Word.

download course pdf
Price: $504 $560

Copilot for Excel Course Content

Expand All | Collapse All

Introduction to Copilot for Excel

Understand the course scope and objectives

Familiarise with Excel Copilot interface and usage

Quick demo of Excel Copilot

Learner introductions and experience sharing

Exploring and Understanding Data

Query and summarise data with natural language

Identify key insights quickly

Guided practice querying Copilot

Explore provided dataset and identify insights

Group discussion on insights discovered

Data Cleaning & Quality Auditing

Use Excel’s AI-powered Clean Data tool

Understand data quality and consistency issues

Clean Data demonstration

Hands-on activity with intentionally messy data

Simple Formulas & Functions

Generate basic Excel formulas with Copilot assistance

Understand and verify created formulas

Creating calculated columns and simple summaries

Hands-on creating formulas and verifying results

Complex Formulas & Troubleshooting

Build complex formulas using Copilot

Troubleshoot formulas with Copilot assistance

IF, VLOOKUP and INDEX-MATCH formulas

Troubleshooting broken formulas

Formatting & Conditional Formatting

Improve spreadsheet readability with formatting

Dynamically highlight data using conditional formatting

Copilot formatting commands (bold, currency formatting)

Conditional formatting examples (top values, thresholds)

Hands-on formatting practice

Advanced Analysis using Python in Excel

Understand Excel's integration with Python for advanced analytics

Perform complex analysis without coding

Sales forecasting and statistical analysis with Python through Copilot

Learners observe and discuss real examples (forecast, correlation analysis, advanced visualisation)

Visualising Data – Charts, Pivot Tables and Displays

Summarise data using PivotTables with Copilot

Understand pivot layouts and interpret data summaries

Visualise data insights with Excel charts using Copilot

Present data clearly and professionally

Pivot creation for sales by region/product

Creating and customising a chart with Copilot

Frequently Asked Questions

What is Microsoft Copilot and how does it use AI?

Microsoft Copilot is an AI-powered tool built into Microsoft 365 apps like Word, Excel, Outlook, PowerPoint, and Teams. It helps you complete tasks faster and more efficiently by generating content, summarising data, drafting emails, and assisting with workflows — all using natural language commands and the latest in AI technology.

What skills will I gain from attending these courses?

You’ll learn how to use Microsoft Copilot to write and edit documents, analyse data, manage emails and meetings, build presentations, and collaborate more effectively. You’ll also develop practical skills in crafting effective prompts, improving Copilot output, and using AI responsibly in a work environment.

Who can benefit from these courses?

These courses are ideal for Microsoft 365 users across any industry — whether you're an executive, admin assistant, analyst, marketer, or team leader. If you're looking to save time, automate tasks, and enhance the way you work with familiar Microsoft apps, these courses are for you.

Do I need any prior AI knowledge before taking this course?

No prior knowledge of AI is required. These courses are designed for everyday users of Microsoft 365. We’ll guide you through Copilot features step by step, and you’ll gain hands-on experience throughout the course.

Can I take these courses online?

Yes. Our Microsoft Copilot courses are available via live online sessions, in-person classes across major cities, and hybrid formats. You’ll receive the same expert-led training experience regardless of how you choose to attend.

Will there be practical exercises during the course?

Absolutely. All Copilot courses include interactive, hands-on exercises. You’ll use Microsoft 365 Copilot within real apps like Word, Excel, Outlook, or Teams to practise prompts, automate tasks, and apply what you’ve learned in a practical setting.

What is remote training?

Remote training is delivered live by our expert instructors via video conferencing. You’ll be able to ask questions, participate in discussions, share your screen for help, and complete activities in real time — just like in a traditional classroom.

What Microsoft Copilot courses are available from Nexacu?

We currently offer five Copilot-focused courses:

- Copilot for Microsoft 365
- Copilot for Word
- Copilot for Excel
- Copilot for PowerPoint
- Copilot for Outlook and Teams

Is there a certification upon completion of these courses?

Yes. You’ll receive a Nexacu Certificate of Completion to verify your skills with Microsoft Copilot. It’s perfect for sharing on LinkedIn or adding to your CV.

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$504 $560
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Copilot for M365

Learn how to use Copilot across Word, Excel, Outlook and more. Get hands-on with AI-powered tools to boost productivity and streamline everyday tasks.

download course pdf
Price: $440 $490
Course Icon Copilot for Outlook and Teams
New

Work smarter in Outlook and Teams. Learn how Copilot helps you manage emails, plan meetings and collaborate more efficiently.

download course pdf
Price: $504 $560
Course Icon Copilot for PowerPoint
New

Turn ideas into polished presentations with AI. Learn how to draft slides, enhance visuals and create content using natural language.

download course pdf
Price: $504 $560
Course Icon Copilot for Word
New

Write, edit and summarise documents faster with Copilot. Save time and improve quality using AI in Microsoft Word.

download course pdf
Price: $504 $560

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Nationwide by Leading Organisations

at Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday

  • 400+ companies rely on Nexacu for team training
  • Trusted by federal, state, and local government agencies
  • Delivering training across 9 countries

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals