Need to Know podcast–Episode 368

Latest news and updates from the Microsoft cloud from security, to copilot and beyond. I also  share my thoughts on recent changes at Microsoft, Cowork costs, security challenges with agents and my experiences configuring local AI. Always keen to hear your thoughts and feedback on the content in this episode.

Brought to you by www.ciaopspatron.com

you can listen directly to this episode at:

https://ciaops.podbean.com/e/episode-367-goldilocks-gone/

Subscribe via iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

or Spotify:

https://open.spotify.com/show/7ejj00cOuw8977GnnE2lPb

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show

Resources

CIAOPS Need to Know podcast – CIAOPS – Need to Know podcasts | CIAOPS

X – https://www.twitter.com/directorcia

director@ciaops.com

CIAOPS Blog

Join my Teams Shared Channel – CIAOPS

CIAOPS Merch store – CIAOPS

Become a CIAOPS Patron

CIAOPS AI Dojo

CIAOPS weekly news update – CIA Brief – CIAOPS

CIAOPS Labs – The Special Activities Division of the CIAOPS

Support CIAOPS

Get your M365 questions answered via email

Join my email list

A special thanks to the CIAOPS Patron community for making this podcast possible. You can find the benefits of a subscription to the community and become a member at https://www.ciaopspatron.com

Security & Threat Intelligence
Microsoft 365 Copilot & AI
SharePoint & Content Management
Microsoft Corporate News

The Real Power of Copilot in Excel Isn’t Formulas. It’s Repeatability.

image

The first thing most people do when they open Copilot in Excel is ask it for a formula.

That’s understandable. For decades, Excel expertise has often been measured by how quickly someone can build complex formulas, create PivotTables, or untangle messy spreadsheets. Copilot changes that. You can now describe what you want in plain English and let the AI do much of the heavy lifting.

But after looking at the latest capabilities around Copilot Skills in Excel, I think many people are missing the bigger opportunity.

The real value isn’t that Copilot can generate a formula.

It’s that it can help you repeat a proven process over and over again.

In most organisations, especially SMBs and MSPs, there are a handful of people who know how to make Excel sing. They’re the people who understand financial models, reporting structures, forecasting tools, and data analysis techniques. Everyone else tends to rely on them whenever something complicated appears in a workbook.

That creates a bottleneck.

I’ve seen it countless times. Month-end reporting arrives and everyone waits for the same person. Quarterly forecasting needs updating and the same expert gets involved again. A new staff member arrives and spends weeks learning spreadsheet processes that only exist in somebody’s head.

That’s not really an Excel problem.

It’s a knowledge-sharing problem.

Copilot Skills in Excel feel like Microsoft’s attempt to address exactly that issue. Rather than repeatedly explaining the same process, you can package those instructions into a reusable skill that Copilot can invoke when required. According to Microsoft’s documentation, skills allow Copilot in Excel to perform repeatable tasks using predefined instructions, and organisations can create custom skills stored in OneDrive for reuse. [support.mi…rosoft.com], [support.mi…rosoft.com]

That might sound like a small change, but I think it’s significant.

From Spreadsheet Expert to Process Expert

Imagine you’ve spent years refining a monthly reporting workbook.

You know exactly how the raw data is imported. You know which columns need cleaning. You know which calculations matter and which charts management expects to see.

Traditionally, every new employee needed training. Documentation had to be updated. Mistakes inevitably crept in.

Now imagine creating a skill that guides Copilot through that process.

Instead of asking a colleague to remember twenty separate steps, they simply invoke the skill and allow Copilot to perform the work in a consistent manner.

The expertise becomes transferable.

That’s a very different proposition from merely generating formulas.

Excel Is Becoming More Conversational

Something else strikes me here.

For years, becoming good at Excel meant learning Excel’s language. You memorised formulas, syntax, functions, and workarounds.

Copilot flips that model.

Now Excel is increasingly learning your language.

You can ask questions about data. Request analysis. Generate charts. Create reports. Import information. Explain formulas. Build dashboards. And increasingly, define repeatable business processes using natural language instructions. [support.mi…rosoft.com], [support.mi…rosoft.com]

That’s a major shift.

The barrier to entry drops dramatically.

People who previously avoided advanced spreadsheet work now have a capable assistant sitting beside them.

The Opportunity for MSPs

From an MSP perspective, I think this capability will become particularly interesting.

Most advice around AI focuses on content generation, meeting summaries, or email drafting. Those are valuable, but they’re often incremental productivity gains.

Skills have the potential to standardise operations.

Imagine creating repeatable Excel processes for:

  • Monthly financial reporting

  • Customer profitability analysis

  • Service desk trend reporting

  • Project forecasting

  • Licence consumption tracking

  • Security compliance reporting

Rather than documenting procedures in lengthy manuals, organisations can embed that knowledge directly into skills that guide Copilot.

That’s a much more scalable approach.

And importantly, it helps preserve organisational knowledge when staff move on.

The Human Still Matters

Of course, none of this removes the need for human oversight.

One lesson I’ve repeated many times with Microsoft 365 Copilot is that AI works best when it’s treated as a capable assistant, not an autonomous decision maker.

If Copilot analyses data, review the results.

If it creates a forecast, validate the assumptions.

If it generates a report, make sure the conclusions make sense.

The person remains accountable. Copilot simply removes much of the repetitive effort.

Final Thoughts

When people think about AI in Excel, they often focus on saving a few minutes creating formulas or formatting data.

That’s useful.

But I think the more interesting story is the ability to capture expertise and make it reusable.

The organisations that benefit most from AI won’t necessarily be those with the smartest prompts. They’ll be the ones that systematically turn repeatable knowledge into repeatable processes.

Excel Skills look like another step in that direction.

And for many businesses, that could end up being far more valuable than any individual formula.

You Didn’t Build a Business. You Built a To-Do List That Breathes.

MAI_dd7b3dc5448fe805

I had coffee with an MSP owner a few weeks back who couldn’t tell me what his business actually did anymore. Not because he didn’t know — but because there was too much to say. Three service lines. A new marketing funnel. A second office. A partner program he’d signed up for and half-forgotten. A stack of AI tools nobody had time to learn. He listed it all, then went quiet, and said the thing I keep hearing: “I’m busier than I’ve ever been and I can’t feel any of it.”

That’s the trap nobody warns you about. We’re told growth is addition. More clients, more staff, more channels, more tools. So we add. And every addition feels like progress on the day you make it. The problem is what addition does over time. It buries the thing that made the business worth building in the first place.

More Doesn’t Sound Like More

When you started, people could hear you. A client rang and got you. An email went out and it sounded like a person. The whole thing had a voice because there was one person behind it, and that person was unmistakable.

Then you scaled. You hired. You layered in process and policy and a second tier of support. All sensible. All necessary. But somewhere in there your voice got distributed across fifteen people and four systems, and the signal faded. The business got louder and you got quieter. That’s not a failure of growth — it’s the natural physics of it. The bigger the thing, the harder it is to hear the person who started it.

The Calendar Owns You Now

Here’s the part that stings. You built this to get freedom, and now it runs your week. Your inbox sets your priorities. Your calendar tells you where to be. Saturday morning you’re at the desk again, not because anyone made you, but because the machine you built only runs if you keep feeding it. You didn’t escape the job. You promoted yourself into a bigger one.

I don’t think the answer is to add a productivity app to manage the other productivity apps. That’s just one more thing on the pile. The answer is subtraction — and the uncomfortable truth is that subtraction takes more discipline than addition ever did. Anyone can say yes to a new channel. Saying no, or worse, dismantling something you already built, feels like going backwards.

Where Copilot Actually Earns Its Keep

This is the one place I’ll defend the AI tools, because most of them genuinely are just more noise. The useful ones give you back the thing you lost: your attention.

I use Copilot in Outlook to clear the overnight pile in minutes instead of an hour — not to write clever emails, but to tell me which three actually need me and draft the rest so I can move on. I’ll open a week’s worth of Teams meetings I half-listened to and ask Copilot to pull out what was decided and what’s mine to do, so I’m not carrying it all in my head. When a client account feels foggy, I ask Copilot to summarise everything across the emails, the files in SharePoint, and the chat history into one page. That’s not adding a tool. That’s using a tool to remove the overhead the other tools created.

The test is simple. Does it give you back time, or does it ask for more? If a new system needs three people and a fortnightly meeting to maintain, it isn’t growth. It’s weight. I’ve quietly killed more standing meetings and subscriptions this year than I started, and the business got clearer for it.

Audit What You’ve Added

Try this. Open your calendar in Outlook and look at last month honestly. Every recurring meeting, every program, every channel — ask what it actually returns. Not what it promised when you started it. What it returns now. Most owners I know find a third of it could go tomorrow and nobody would notice, except them, who’d suddenly have their head back.

The strongest businesses I work with aren’t the ones that added the most. They’re the ones that stayed recognisable — where you can still hear the person who built it, because they were ruthless about what they let in.

You can add forever. There’s always another channel, another tool, another hire. But at some point the thing you built starts to own you instead of the other way around. The way out isn’t more. It’s less, chosen on purpose.

GAIN: Knowing What to Hand to AI and What to Hold Onto

image

A while back I caught myself spending a Saturday morning copying figures into a spreadsheet by hand. Forty minutes in, it landed on me — Copilot could have done this while I made a coffee. I wasn’t being thorough. I was being slow. And when the person at the top moves slowly, everything behind them backs up too.

That morning is why I keep coming back to a simple way of sorting the work in front of me: what to pass over, what to speed up, what to build alongside the machine, and what I should never let go of. Four buckets. GAIN.

Pass over the work that doesn’t need you

Most of us hold on to tasks out of pure habit. The first draft. The long document that needs boiling down. The background reading before a client call. None of that needs your judgement — it just needs doing. So let it be done. I’ll ask Copilot in Word to condense a forty-page proposal, or have it pull the recurring themes out of a month of client emails in Outlook. I’m not after ideas. I’m after a finished job. Once you start looking, the size of this pile is genuinely surprising.

Speed up the things that already work

Every business runs on small, repeatable steps. An enquiry arrives, someone qualifies it, someone books the meeting, someone sends the follow-up. You’re not reinventing that — you’re stripping out the waiting in between. With Power Automate sitting under Copilot, a new lead can be sorted, routed, and have a meeting request out the door before anyone’s even read it. Two hours back a week, every week, for as long as the doors are open. That compounds in a way that’s easy to dismiss when you’re staring at the setup.

Build something you couldn’t make alone

This is the part people skip past. The real value isn’t AI standing in for you — it’s the two of you producing something neither would on its own. I’ll have Copilot take ideas I’ve already worked through, connect them in ways I hadn’t spotted, and hand them back in a different shape. Sometimes I’ll drop a Loop page of rough notes and let it pull the thread together while I’m out of the office. I come back and I’m editing, not starting from a blank page. Minutes of shaping instead of hours of grinding. You shift from making the thing to sharpening it — and that’s a far better use of your attention.

Keep what only you can do

Not everything belongs on these piles, and pretending otherwise is how people lose the plot. Taste can’t be handed over — it’s learned, never taught, and certainly never prompted. Vision stays yours, because the machine has no idea what your clients will want next year. And care — actually feeling something for the work and the people on the other end of it — that’s the whole point of doing any of this. Copilot can draft the message; it can’t mean it. Guard those three closely.

The aim was never to turn yourself into the software. It’s to clear away everything else so there’s more room for the part of the job that’s unmistakably yours. I’m curious how far that line shifts over the next year — but those last few things, I don’t think they move at all.

Copilot in Excel

image

Most people who tell me Copilot in Excel is useless are half right.

It is useless — on their spreadsheet. Because their spreadsheet is a tangle of merged cells, blank rows, and a title floating in cell A1.

They open the Copilot pane, ask a question, get a shrug, and write the whole thing off as hype.

That’s not a Copilot problem. That’s a data problem.

Here’s the part nobody tells the client. Copilot in Excel only reads structured data. Fix the structure and the same “useless” tool answers everything you throw at it. The fix takes about ten seconds.

What is Copilot in Excel, really?

Forget the demos where someone conjures a dashboard out of thin air. Day to day, Copilot in Excel does four ordinary jobs, and does them well.

It summarises a table. It writes a formula column for you and explains how it works. It highlights, sorts and filters on request. And it flags trends or outliers you’d otherwise have to eyeball.

Notice what’s on that list? Nothing exotic. These are the things your clients already do by hand, slowly, every single week.

The catch is the layout. Copilot needs the data set out so it can read it. Microsoft is blunt about this — your data has to be an Excel table or a clean supported range, as spelled out in Format data for Copilot in Excel. One header row. Headers on columns only. No merged cells. No subtotals baked in. No blank rows cutting the data in half.

Give it a table and it flies. Give it a “report” with a logo in A1 and three blank rows for spacing, and it just stares back.

Step-by-Step: getting Copilot to actually answer
Save the file to the cloud

Copilot only works on files saved to OneDrive or SharePoint with AutoSave turned on. A workbook sitting on the desktop gets you a greyed-out button. File > Save a Copy > OneDrive, and AutoSave flips on by itself.

Turn your data into a table

Click any cell in your data. Press Ctrl+T. Confirm the “My table has headers” box. That’s it.

That one step fixes more “Copilot doesn’t work” complaints than everything else I show people combined.

Open the Copilot pane

The Copilot icon lives on the Home tab, far right of the ribbon. Click it and the pane slides in from the right with a few starter prompts. The official Get started with Copilot in Excel page is a tidy thing to hand a client here.

Ask once, specifically

This is where people fumble. They type “summarise this” and get mush. Be specific about the column and the goal:

Add a column that flags any order in the Total column over 5000 as "Review", and explain the formula.

Notice what’s in that prompt? A named column. A clear rule. A request to explain. That’s the whole difference between a useful answer and a coin toss. Ask once, but ask properly.

Why this actually changes behaviour

Here’s the real win, and it isn’t the formulas.

For years the gap between a spreadsheet and an answer was Excel knowledge. XLOOKUP, pivot tables, nested IFs — the stuff that lives in the head of one person in the office and nowhere else.

Copilot closes that gap. The person who knew the question but not the syntax can now just ask.

“But won’t it get things wrong?”

Yes. It will. Microsoft says so plainly in their Copilot in Excel FAQ — read what it writes, check it, then accept it. Treat it like a sharp junior who’s fast but needs reviewing. You wouldn’t ship a graduate’s first draft unread either.

And that review habit is the part worth teaching. Copilot doesn’t replace judgement. It removes the typing between you and the judgement.

If you look after SMB clients, this is a five-minute conversation that pays for itself. Most of them are already paying for the Copilot licence and getting nothing from it in Excel — because their data was never structured for it.

Show them Ctrl+T. Show them one good prompt. Watch the lights come on.

If you’re not showing your clients this, you’re leaving value on the table that they’re already paying for.

Copilot in Excel isn’t there to make people better at Excel. It’s there to make Excel skill stop being the thing that holds them back.

Has Microsoft Made Copilot Cowork Too Expensive and Too Hard to Use for SMB?

image

A lot of SMBs think their AI journey starts by buying more AI.

I think that’s the wrong place to start.

Over the last few months I’ve spoken to plenty of SMBs and MSPs who are excited about Microsoft Copilot, curious about Copilot Cowork, and interested in agents. Then they see the pricing model, hear the term pay-as-you-go, start looking at consumption costs, and immediately become nervous.

I don’t blame them.

The real question isn’t whether Copilot Cowork is good. The question is whether Microsoft has made it too expensive and too complicated for the average SMB to realise value from it.

And right now, I think there’s a genuine argument that they have.

Technology should remove friction, not introduce it.

What is Copilot Cowork, really?

Forget the product names for a moment.

Copilot Cowork is essentially Microsoft’s way of allowing AI experiences to go beyond the capabilities included in your existing Microsoft 365 subscription.

That can mean accessing additional AI services, consuming AI-powered workflows, running agents, or using capabilities that incur usage-based costs rather than being covered under a fixed licence.

The attraction is obvious.

You only pay for what you use.

The problem is that most SMBs have spent the last twenty years moving away from unpredictable IT costs. Fixed monthly subscriptions made budgeting easier. Consumption billing moves the conversation in the opposite direction.

That’s where things start getting uncomfortable.

“Isn’t this just cloud pricing all over again?”

In many ways, yes.

The difference is that AI usage can be harder for business owners to understand than storage, mailboxes or virtual machines.

Step-by-Step: Getting Value Before Paying More

Review the Copilot Features You Already Have

Open the Microsoft 365 apps your users work with every day.

Look at the built-in Copilot experiences already available in products such as Edge, Outlook, Teams and Microsoft 365.

Microsoft continues to expand these capabilities, often without organisations fully realising what’s already included.

You can learn more from https://learn.microsoft.com/microsoft-365/copilot/microsoft-365-copilot

Enable Microsoft 365 Copilot Chat

Navigate to:

Microsoft 365 App > Copilot

Many organisations still aren’t getting consistent value from Copilot Chat, despite it being available to users.

If your staff aren’t regularly using Copilot Chat, adding more AI services is unlikely to solve the problem.

Identify Repetitive Business Processes

Look for activities that happen repeatedly:

  • Status reporting

  • Meeting preparation

  • Policy summarisation

  • Document review

  • Knowledge retrieval

These are usually the areas where AI can provide immediate value.

Microsoft’s adoption guidance is available through https://learn.microsoft.com/microsoft-365/copilot/adoption/ adoption resources.

Measure Usage Before Expanding

Use the reporting and administrative tools available within Microsoft 365 to understand whether users are actually engaging with Copilot.

Many organisations skip this step entirely.

They purchase AI licences first and measure value later.

That’s backwards.

Introduce Consumption-Based Services Carefully

Only after people are regularly using the AI capabilities already available should you consider broader AI consumption models.

If you do move forward, make sure you understand how billing controls and cost management work.

Microsoft provides additional information through https://learn.microsoft.com/microsoft-365/copilot/microsoft-365-copilot-page.

Why this actually changes behaviour

The biggest issue isn’t price.

It’s uncertainty.

SMBs don’t generally object to paying for technology that creates value.

They object to paying for technology when they can’t predict what the bill will be or explain what they’re getting in return.

That’s an adoption problem, not a technical problem.

Copilot Cowork asks organisations to think differently about AI consumption. That’s understandable from Microsoft’s perspective, but it introduces complexity at a time when many SMBs are still trying to establish basic AI habits.

Notice what’s missing?

People.

If users aren’t actively incorporating AI into their daily workflows, no pricing model will save the deployment.

My recommendation?

Use every Copilot capability already included in Microsoft 365 first.

Build habits.

Measure outcomes.

Identify repeatable wins.

Only then move toward consumption-based AI services.

Copilot doesn’t get tired. Use that.

But don’t pay for more AI until you’ve proven the value of the AI you already have.

The real opportunity isn’t buying more AI.

It’s getting more value from the AI you’ve already paid for. If you’re not showing clients this, you’re leaving value on the table.

The Browser Is Becoming Part of the Conversation

image

The more I use Copilot Cowork, the more I realise that the interesting part isn’t the AI itself. It’s what happens when the AI can finally interact with the same systems I use every day.

For years we’ve talked about AI helping us write documents, summarise meetings and draft emails. Useful? Absolutely. But most work doesn’t stop there. Sooner or later you need to log into a website, update a portal, retrieve information from a dashboard, or complete a process that lives inside a browser window.

That’s why the addition of local browser use in Copilot Cowork has caught my attention.

The Gap Between Advice and Action

One of the frustrations I see with AI tools is that they often stop at recommendations. They’ll tell you what to do, but they won’t actually do it.

Think about a typical day. You receive an email asking for an update. You find the relevant Teams conversation. You look through a SharePoint document. You then log into a service portal to check the current status before replying.

The work isn’t creating the email. The work is gathering the information across multiple locations and then taking action.

What browser use starts to do is close some of that gap.

Instead of simply suggesting a next step, Cowork can potentially navigate the website on your behalf while remaining inside the flow of the conversation. That changes the relationship between the user and the tool. You’re no longer just asking questions. You’re delegating pieces of work.

The Real Opportunity for SMBs

When I talk with SMBs and MSPs, one common theme emerges. Many important business systems don’t have polished integrations or APIs.

There are customer portals, supplier websites, expense systems, training platforms and countless line-of-business applications that still require someone to open a browser and manually complete a task.

That’s the reality of most small businesses.

Imagine asking Cowork to collect information from a supplier portal, compare it against a spreadsheet in Excel, create a summary in Word and then draft an Outlook email ready for review.

The value isn’t that any individual step is difficult. The value comes from reducing all the switching between systems that quietly consumes large portions of the day.

Every context switch has a cost. Most people simply don’t notice it because they’re so used to doing it.

Human Control Still Matters

Of course, this isn’t a licence to let AI loose across every system without oversight.

One thing I appreciate about Microsoft’s approach is that the browser session remains connected to the user’s identity and permissions. The AI is working with the same access the user already has rather than operating as some separate privileged account.

That’s important.

The future of workplace AI isn’t about removing people from the process. It’s about putting people higher in the process.

I see the role shifting from operator to supervisor. Instead of spending ten minutes navigating through screens and forms, you’re reviewing work, making decisions and approving outcomes.

The keyboard becomes a little less important. Judgement becomes more important.

What I’m Watching Next

I suspect many people will initially view browser use as a novelty. They’ll try a few demonstrations and move on.

I think that misses the bigger story.

The real significance is that Copilot is gradually moving beyond content creation and into work execution. The ability to interact with websites, applications and business processes starts to make the assistant feel less like a chatbot and more like a digital team member.

We’re still in the early stages, and I’d encourage organisations to test it carefully and deliberately.

But every major technology shift starts with a small behavioural change.

For me, that change is simple.

When I open a browser now, I’m increasingly asking not “What can I do here?”

I’m asking, “What can I hand off instead?”

Screenshot 2026-07-08 055301

How to Enable Browser Use in Copilot Cowork

Before users can take advantage of Browser Use, there are several prerequisites that must be met. According to Microsoft’s documentation, Browser Use is disabled by default and requires administrator configuration before users can access it. [learn.microsoft.com], [learn.microsoft.com]

Step 1: Enable Copilot Cowork

Browser Use relies on Copilot Cowork being available to users. As an administrator:

  1. Sign in to the Microsoft 365 Admin Center.

  2. Navigate to Copilot.

  3. Open Cost Management.

  4. Configure usage-based billing.

  5. Assign access to the users who will use Copilot Cowork.

If usage-based billing hasn’t been configured, users won’t be able to access Cowork features. [learn.microsoft.com]

Step 2: Enable Browser Access

Once Cowork is available:

  1. In the Microsoft 365 Admin Center, go to Copilot.

  2. Select Settings.

  3. Choose View all.

  4. Locate the Cowork settings.

  5. Turn on Allow browser access.

  6. Save the changes.

Microsoft notes that Browser Use is turned off by default and must be explicitly enabled by an administrator.

Step 3: Verify User Requirements

Each user must meet the following requirements before Browser Use will work:

  • Have a Microsoft 365 Copilot licence assigned.

  • Have access to Copilot Cowork.

  • Have Microsoft Edge installed.

  • Be running a current version of Edge.

  • Be signed into Edge using the same work or school account used for Copilot.

  • Use Cowork in a supported browser experience rather than an unsupported client. [learn.microsoft.com]
Step 4: Launch Copilot Cowork

The user can then:

  1. Open Microsoft 365 Copilot.

  2. Launch Copilot Cowork.

  3. Enter a request that requires interaction with a website.

For supported tasks, Cowork can use a hidden Microsoft Edge session running on the user’s device to interact with websites and web applications whilst keeping the user within the Copilot conversation experience. [learn.microsoft.com]

Screenshot 2026-07-08 060426

Step 5: Accept First-Run Consent

The first time Browser Use is invoked, users are presented with a consent prompt explaining:

  • Browser Use is currently in preview.

  • The feature can perform actions on the user’s behalf.

  • AI-generated actions may not always be perfect.

  • Sensitive actions may still require user confirmation.

Users must accept this prompt before Browser Use becomes available.

Step 6: Start with Low-Risk Scenarios

My recommendation is to begin with simple information-gathering tasks rather than business-critical transactions. Good examples include:

  • Looking up information in customer portals.

  • Checking ticket or order status.

  • Gathering information from vendor websites.

  • Researching data across multiple web-based systems.

As confidence grows, organisations can gradually expand usage to more complex workflows. This allows users to understand where the technology adds value while maintaining appropriate oversight.

If the process needs assistance while browsing it will pause and you will see something like:

Screenshot 2026-07-08 060945


Practical Tip: If Browser Use isn’t working, check the basics first. In my experience the most common causes are that Cowork billing hasn’t been enabled, Browser Access hasn’t been switched on by an administrator, or the user isn’t signed into Microsoft Edge with the same account they use for Copilot. [learn.microsoft.com]

Stop Azure Billing Surprises: How to Set Up Budget and Cost Alerts for Copilot Chat, Copilot Cowork and Azure AI

image

One of the biggest concerns I hear from people experimenting with Microsoft Copilot, Copilot Cowork, Azure AI Foundry, Azure OpenAI and other Azure services is:

“How do I stop unexpected Azure charges?”

This concern is becoming even more important as more Microsoft AI services move to a consumption-based pricing model. Features such as Copilot Cowork can consume Azure resources behind the scenes, and without monitoring in place, costs can creep up before you realise it.

The good news is that Azure provides built-in tools to help you stay in control. With about 10 minutes of configuration, you can create budget alerts and anomaly detection that will notify you before costs become a problem.

Here’s how I recommend every Azure user configure cost controls.

Why This Matters

Many Azure services charge based on usage. Examples include:

  • Microsoft 365 Copilot PAYG features

  • Copilot Cowork

  • Azure AI Foundry

  • Azure OpenAI

  • Azure AI Search

  • Virtual Machines

  • Storage services

  • Networking services

The danger isn’t usually the individual cost. The danger is forgetting something is running or not noticing a new workload starts consuming more resources than expected.

A few simple alerts can provide an early warning long before a large bill arrives.

Step 1: Create a Monthly Budget

Start by opening the Azure portal and navigating to:

Cost Management + Billing
→ Cost Management
→ Budgets

Select:

+ Add
Configure the Budget

Enter a meaningful name such as:

Monthly Azure Budget

Choose:

Reset Period = Monthly

Set the start date to today or the first day of the current month.

Now decide on a budget amount.

For most users I suggest:

  • AU$50 for light experimentation

  • AU$100 for regular testing

  • AU$200 for heavier AI workloads

If you’re just getting started with Copilot Cowork or Azure AI services, AU$100 per month is a sensible starting point.

Click Next to configure alerts.

Step 2: Create Budget Alerts

Budget alerts notify you when your spending reaches specific percentages of your budget.

Rather than waiting until you hit the limit, configure several warning levels.

Alert 1

Create:

Type: Actual Cost
Threshold: 50%

If your budget is AU$100 you’ll receive an alert at AU$50.

Alert 2

Create:

Type: Actual Cost
Threshold: 75%

You’ll receive an alert at AU$75.

Alert 3

Create:

Type: Actual Cost
Threshold: 90%

This provides a final warning before reaching your budget.

Alert 4

This is the most important alert.

Create:

Type: Forecast Cost
Threshold: 100%

Forecast alerts use Azure’s spending predictions.

This means Azure can tell you:

“At your current spend rate, you’re likely to exceed your budget before the end of the month.”

This often gives you warning before you actually spend the money.

Configure Email Notifications

For each alert enter your email address:

admin@yourdomain.com

You can add multiple recipients if needed.

Unless you’re planning advanced automation, leave:

Action Group = None

Email notifications are sufficient for most users.

Once all four alerts have been configured, create the budget.

Step 3: Configure Cost Anomaly Alerts

Budget alerts are excellent for gradual overspending.

However, they won’t necessarily detect sudden spending spikes.

That’s where anomaly alerts come in.

Navigate to:

Cost Management + Billing
→ Cost Management
→ Cost Alerts

Select:

+ Add
Configure the Alert

Choose:

Alert Type = Anomaly

For the view select:

Daily anomaly by resource group

This tells Azure to look for unusual spending patterns across your subscription.

Configure the Notification

Use a descriptive subject such as:

Cost anomaly detected in Azure subscription

Add your notification email address:

admin@yourdomain.com

Optionally enter a custom message such as:

Review Azure spending immediately and investigate the source of the anomaly.

Create the alert.

How Anomaly Detection Helps

Imagine your Azure environment normally costs:

AU$2 per day

Then one day:

  • A GPU virtual machine is left running

  • An Azure AI deployment starts processing large workloads

  • Azure AI Search is accidentally overprovisioned

  • Copilot-related services begin consuming significantly more resources

Azure notices the unusual increase and generates an alert.

Instead of discovering the issue weeks later, you’ll know almost immediately.

Step 4: Identify What Is Actually Spending Money

Once alerts are configured, the next step is understanding where your money is going.

Open:

Cost Management
→ Cost Analysis

Change:

Group By = Resource Group

to:

Group By = Resource

This simple change provides much more useful information.

Instead of seeing:

copilot-rg

you’ll see the actual resources generating costs such as:

  • Azure AI Search

  • Storage Accounts

  • AI Deployments

  • Virtual Machines

  • Managed Disks

  • Public IP Addresses

This makes troubleshooting much easier.

Step 5: Don’t Forget Compute Services

The most common cause of unexpected charges is running compute resources.

Pay particular attention to:

  • Virtual Machines

  • Azure AI Foundry deployments

  • Azure AI Search services

  • GPU resources

  • Azure OpenAI deployments

Where possible, enable automatic shutdown on virtual machines and remove unused resources.

Final Thoughts

The rise of AI services such as Copilot Cowork means more organisations will encounter consumption-based Azure costs. That’s not a reason to avoid these tools. It simply means spending should be monitored in the same way we monitor security, backups and availability.

The combination of:

  • Monthly budget alerts

  • Forecast alerts

  • Cost anomaly detection

  • Regular cost analysis reviews

provides an effective safety net for most users.

If you’re experimenting with Copilot Cowork, Azure AI Foundry or any other Azure AI services, I strongly recommend configuring these controls before you start serious testing. A few minutes of setup today can save a lot of surprises at the end of the month.