Advanced course. Advanced workshop

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.

Illustration generated with AI.

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.

Find your town

Employed New Zealanders by occupation group, 2023

Employed people by occupation group, New Zealand, 2023 Census
Occupation groupChartShare
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

  1. 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.

  2. 2Practical

    Microsoft Copilot for a working day

    A full day that takes one real piece of work through Word, PowerPoint, Excel, Outlook and Teams.

  3. 3Organisation

    Copilot rollout and readiness

    Prepare the tenant, choose a pilot, and measure whether people use Copilot well.

  4. 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

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

  1. ScopeHeadcount, sites, Microsoft 365 plan and licences, and the teams you want to start with.
  2. PlanWe propose a course, a pilot group and a format, and agree the files and meetings to use.
  3. 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.

Not sure which licence? We check before training.

Include the apps, staff roles, number of people and location you have in mind.

Team workshops from $4,000 + GST for up to 10 people. +$200 + GST per extra person.

Public sessions from $399 + GST per person. Schedule coming soon.

No payment now. We reply by email with a suggested course and format.

We use these details only to reply to you, and store them securely with thecolab.ai. Privacy