Copilot Studio agents and advanced Excel
Copilot Studio agents and advanced Excel is part of thecolab.ai’s Microsoft Copilot training for NZ teams. The course covers the topics below through practical exercises, on-site or remotely. Choose it by comparing the audience, prerequisites and outcomes with your team’s work. Team workshops start from $4,000 + GST for up to 10 people.
See Copilot training NZ, Copilot courses NZ and Copilot workshops NZ.
Build and test a Copilot Studio agent for one internal process, and go further with Copilot in Excel.
How much does Microsoft Copilot training cost in NZ?
Team workshops start from $4,000 + GST for up to 10 people, with $200 + GST per extra person. Public sessions start from $399 + GST per person; the schedule is coming soon.
How do I choose Microsoft Copilot training for a NZ business?
Start with the work your staff do, their current experience and the accounts they can use. Compare course topics and outcomes, then choose on-site or remote delivery. Use cleared examples and decide who will check the work.
Last updated .
- Level
- AdvancedAdvanced workshop
- Delivery
- On-site or remoteanywhere in New Zealand
- Length
- One dayagreed with you first
- Topics
- 6adapted to your team
Who it is for
Power users, analysts, Power Platform makers and the IT people who will govern what gets published.
This day is for people who will build. We design one agent for a real internal process, connect only approved knowledge, test it, and stop before a wide publish until governance is agreed.
Copilot Studio is a low-code studio for agents and workflows. The Excel block is for makers who analyse data in the workbook: edit, plan and chat modes, formulas, charts and PivotTables. Finance staff who only need the workbook should take the Excel and finance course instead.
Agent material follows Microsoft's pages 'Overview of Microsoft Copilot Studio', 'Agents overview' and the Microsoft Copilot application card. Excel material follows 'Get started with Copilot in Excel' and 'Frequently asked questions about Copilot in Excel'.
Before you start: Access to Copilot Studio for the people who will build, and one process you are allowed to use in the room. A workbook is needed for the Excel block. No coding is required. IT should attend the governance module.
What we cover
- Agent Builder or Copilot StudioMicrosoft's application card points to Agent Builder for a quick declarative agent for yourself or a small team. Use Copilot Studio when the audience is wider or the agent needs workflows and integrations.
- Three harnessesThe standard harness follows topics you design. The Copilot chat harness extends Copilot Chat with your knowledge. The GitHub Copilot harness is for multistep work that chooses tools as it goes. That name is a Copilot Studio engine. This course does not teach the separate GitHub Copilot coding assistant. The harness changes billing, so confirm capacity with your admin before production use.
- Knowledge, instructions and a testDescribe the agent in plain language, attach only approved knowledge, and test it before anyone publishes it. Generative answers from knowledge are for questions outside the topics you scripted.
- ActionsAgent flows are automations with an authoring experience similar to Power Automate, native to Copilot Studio. Attach a flow as a tool so the agent can do a step and return a result. Use human review where a person must approve the action.
- GovernanceCover who may publish, which environment the agent lives in, and how you will read analytics after release. Do not publish to the whole organisation in the session.
- Copilot in Excel for makersUse chat mode to inspect a sheet, plan mode to agree steps, and edit mode only when you mean to change cells. Ask for formulas, charts, PivotTables and insights. Microsoft says to review every result. Editing needs calculation set to Automatic. Saved edits are visible to people who can open the file.
We adjust the content to your team, and use your own documents and tasks for the exercises.
Who does this kind of work
63.6% of employed New Zealanders, about 1,669,000 people, work in the desk-based occupation groups (in bold) where Microsoft Copilot helps most. Each town page shows the local share, so you can choose the size of a local rollout.
Employed New Zealanders by occupation group, 2023
| Occupation group | Chart | Share |
|---|---|---|
| Managers | 18.3% | |
| Professionals | 26.8% | |
| Technicians and trades workers | 12.5% | |
| Community and personal service workers | 9.0% | |
| Clerical and administrative workers | 10.8% | |
| Sales workers | 7.8% | |
| Machinery operators and drivers | 5.9% | |
| Labourers | 9.0% |
Desk-based = ANZSCO major groups 1, 2, 5 and 6 (managers, professionals, clerical and administrative, sales): roles where AI assistance is most applicable. Broad proxy informed by ILO 2025; not measured adoption or an employment forecast.
Source: Stats NZ, 2023 Census, usually resident employed people; ILO, Generative AI and jobs: a refined global index of occupational exposure (2025).
Other courses
1Introductory
Microsoft 365 Copilot foundations workshop
A half-day of Microsoft 365 Copilot training: check your access, draft an email, review a document and test a spreadsheet answer using cleared examples.
2Practical
Microsoft Copilot for a working day
A full day that takes one real piece of work through Word, PowerPoint, Excel, Outlook and Teams.
3Organisation
Copilot rollout and readiness
Prepare the tenant, choose a pilot, and measure whether people use Copilot well.
5Finance
Copilot for Excel and finance
Use Copilot in Excel to explore a workbook, draft commentary and check every figure.
Industries this course suits
Guides
- Checking Microsoft 365 Copilot output for errors
- Copilot agents and automation: what is realistic
- Copilot for accountants and bookkeepers
- Writing an AI usage policy for Microsoft 365 Copilot
Available in every region, for example Auckland, Canterbury and Wellington. See all locations.
Questions about this course
Do we need a developer?
No. Copilot Studio is low-code. Makers can build the prototype. Someone who can administer environments should join the governance module before publishing.
What formats can we book?
The course is one day, in your workplace or live by video. Makers need their own access to Copilot Studio during the exercises.
Can the agent answer clinical questions?
No. Build agents for admin tasks such as policy lookup. Microsoft's Copilot Studio overview says the product is not a medical device and is not for diagnosis or treatment.
Does the course quote Copilot Studio prices?
No. Usage is metered, and the harness changes how usage is billed. Ask your licensing contact to confirm capacity. We do not state prices.
A note from Adam
I've watched hundreds of people at our meetups go from "I'm not technical enough" to building something useful in an afternoon. Knowing where to start helps. So does having someone in the room who's done it.
That's what this course is. We work on your real tasks, with your own data, and we're straight with you about where Microsoft Copilot helps and where it doesn't.
Pick something small. Build it. Show someone.
Adam Holt, co-founder, thecolab.ai · New Zealand's first Claude Ambassador
Ask about Copilot Studio agents and advanced Excel
- ScopeHeadcount, sites, Microsoft 365 plan and licences, and the teams you want to start with.
- PlanWe propose a course, a pilot group and a format, and agree the files and meetings to use.
- TrainOn-site or over Teams, in Outlook, Word, Excel and Teams, with your own work.
- In person
- Remote
- Half-day workshop
- Full-day workshop
- Team rollout
Independent training by thecolab.ai. Not affiliated with Microsoft.
Enquire
Tell us about your team. We reply by email with a suggested course and format.