This course is delivered live online, remotely across New Zealand.
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:
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Copilot for M365 Learn Microsoft 365 Copilot in Word, Excel, PowerPoint and Outlook. Hands-on training in New Zealand to improve productivity and streamline daily tasks.
Copilot for Outlook and TeamsDiscover how Microsoft Copilot in Outlook and Teams helps you manage emails, plan meetings and collaborate effectively. Courses delivered online or in Auckland, Wellington and Christchurch.
Copilot for PowerPointCreate engaging PowerPoint presentations faster with Microsoft Copilot. Learn to draft slides, refine layouts and enhance visuals with training in New Zealand.
Copilot for WordWrite, edit and summarise Word documents with Microsoft Copilot. Our New Zealand training helps you save time and improve accuracy with AI.
Microsoft Copilot Studio: Building AI AgentsBuild and customise Copilot agents for your organisation. Learn how to design, train and share Copilot agents using Microsoft 365 data and natural language prompts.
Copilot for Power BILearn Power BI Copilot training to prepare semantic models, generate insights, and apply governance for accurate, trusted AI-driven analytics.
Copilot for Customer ServiceRespond faster and smarter with Copilot. This scenario-based workshop builds prompting skills and service judgement for customer-facing roles.
Copilot for Executives and ManagersLead smarter with Copilot. This half-day course helps executives and managers use AI to summarise, communicate, and make decisions more effectively.
Copilot for HRResearch, advise, and communicate with more confidence using Copilot. This scenario-based workshop builds prompting, HR reasoning, and decision support skills for HR-focused roles.
Copilot for FinanceAnalyse data, validate outputs, and communicate with more confidence using Copilot. This scenario-based workshop builds prompting, financial judgement, and decision support skills for finance-focused roles.
Copilot for Legal ServicesDraft, review, and analyse legal material with more confidence using Copilot. This scenario-based workshop builds prompting, legal reasoning, and decision support skills for legal-focused roles.
Copilot for OperationsPlan, coordinate, and respond with more clarity using Copilot. This scenario-based workshop builds prompting, operational thinking, and decision support skills for operations-focused roles.
Copilot for SalesResearch smarter and sell with more confidence using Copilot. This scenario-based workshop builds prompting, discovery, and research skills for sales-focused roles.
Copilot for MarketingPlan, create, and refine marketing work with more confidence using Copilot. This scenario-based workshop builds prompting, research, and campaign decision support skills for marketing-focused roles.
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.
Copilot for M365 Learn Microsoft 365 Copilot in Word, Excel, PowerPoint and Outlook. Hands-on training in New Zealand to improve productivity and streamline daily tasks.
Copilot for Outlook and TeamsDiscover how Microsoft Copilot in Outlook and Teams helps you manage emails, plan meetings and collaborate effectively. Courses delivered online or in Auckland, Wellington and Christchurch.
Copilot for PowerPointCreate engaging PowerPoint presentations faster with Microsoft Copilot. Learn to draft slides, refine layouts and enhance visuals with training in New Zealand.
Copilot for WordWrite, edit and summarise Word documents with Microsoft Copilot. Our New Zealand training helps you save time and improve accuracy with AI.
Microsoft Copilot Studio: Building AI AgentsBuild and customise Copilot agents for your organisation. Learn how to design, train and share Copilot agents using Microsoft 365 data and natural language prompts.
Copilot for Power BILearn Power BI Copilot training to prepare semantic models, generate insights, and apply governance for accurate, trusted AI-driven analytics.
Copilot for Customer ServiceRespond faster and smarter with Copilot. This scenario-based workshop builds prompting skills and service judgement for customer-facing roles.
Copilot for Executives and ManagersLead smarter with Copilot. This half-day course helps executives and managers use AI to summarise, communicate, and make decisions more effectively.
Copilot for HRResearch, advise, and communicate with more confidence using Copilot. This scenario-based workshop builds prompting, HR reasoning, and decision support skills for HR-focused roles.
Copilot for FinanceAnalyse data, validate outputs, and communicate with more confidence using Copilot. This scenario-based workshop builds prompting, financial judgement, and decision support skills for finance-focused roles.
Copilot for Legal ServicesDraft, review, and analyse legal material with more confidence using Copilot. This scenario-based workshop builds prompting, legal reasoning, and decision support skills for legal-focused roles.
Copilot for OperationsPlan, coordinate, and respond with more clarity using Copilot. This scenario-based workshop builds prompting, operational thinking, and decision support skills for operations-focused roles.
Copilot for SalesResearch smarter and sell with more confidence using Copilot. This scenario-based workshop builds prompting, discovery, and research skills for sales-focused roles.
Copilot for MarketingPlan, create, and refine marketing work with more confidence using Copilot. This scenario-based workshop builds prompting, research, and campaign decision support skills for marketing-focused roles.
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
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
Australia
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
