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:
You should be familiar with Excel basics, but no Copilot or AI experience is required.
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.
Copilot for Outlook and TeamsWork smarter in Outlook and Teams. Learn how Copilot helps you manage emails, plan meetings and collaborate more efficiently.
Copilot for PowerPointTurn ideas into polished presentations with AI. Learn how to draft slides, enhance visuals and create content using natural language.
Copilot for WordWrite, edit and summarise documents faster with Copilot. Save time and improve quality using AI in Microsoft Word.
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
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.
Microsoft Copilot Training in Remote Online
View Dates 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.
Copilot for Outlook and TeamsWork smarter in Outlook and Teams. Learn how Copilot helps you manage emails, plan meetings and collaborate more efficiently.
Copilot for PowerPointTurn ideas into polished presentations with AI. Learn how to draft slides, enhance visuals and create content using natural language.
Copilot for WordWrite, edit and summarise documents faster with Copilot. Save time and improve quality using AI in Microsoft Word.
Microsoft Copilot Training in Remote Online
View Datesat 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
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Resit your course for free within 6 Months
Valued by Individuals
