License Optimization: How to Save 30% on Microsoft 365

Here's the uncomfortable truth: 70% of the SMBs I audit are paying for Microsoft 365 licenses their staff doesn't actually use. A warehouse supervisor gets the cost of a back-office worker. A data analyst sits on the same E3 plan as someone who only needs email and Teams. The result? A 60-person company wastes roughly $19,000 a year.

The good news: A proper audit cuts that waste by 20–30%—without sacrificing capability.

The Problem: Everyone Gets the Same

Most companies follow a simple logic: Everyone needs Office and Teams, so buy Microsoft 365 for all. Often it defaults to Enterprise E3 or E5. Better safe than sorry.

It's wrong.

A frontline worker (warehouse staff, shift supervisor) needs mail, calendar, and Teams. An office administrator needs Office + Teams + maybe Power BI access. A finance director might need premium connectors, advanced automation, and sophisticated threat protection.

Instead, companies pay for features that:

• Nobody touches (Power BI embedded in E5 when the user never analyzes data)
• Cost way less through targeted add-ons
• Create security exposure by spreading privileged access too wide

The License Map: What You Actually Need

Microsoft offers the right license for every role. You just need to know the difference.

F1 & F3 – Frontline Workers

$4–6/month instead of $14–20 for E3. Teams, Shifts, Word/Excel online. Warehouse staff, production, customer service, operations: This is your standard.

When it fits: Your user isn't in Outlook all day, doesn't need desktop Office, and has no reason to touch Power BI or Power Apps.

E1 – Basic Productivity

$8–10/month. Teams, Exchange, SharePoint, web-based Office. For people who primarily communicate and handle light document work.

E3 – The Workhorse

$14–16/month. Desktop Office apps, Teams, advanced security, threat protection. This is right for standard office workers who depend on full Office and need reliable collaboration.

E5 – Power User License

$22–28/month. Everything in E3 plus Power BI, advanced analytics, voice capabilities, compliance features, premium connectors. For your controllers, data analysts, and product managers. Not for your receptionist.

The Audit: How to Find Your Waste

Skip generic advice. You need data.

Step 1: Export Your User List from Entra ID

Go to Azure AD (Entra ID) and pull a complete user export with current licenses. A spreadsheet with these columns:

• Name / Department / Current License / Last Sign-In
• Email Activity Level / Teams Activity Level

Step 2: Gather Actual Usage

This is the critical part. Pull:

• Who's actively using Exchange? (Office 365 Admin Center → Mailbox Usage Reports)
• Who uses Teams regularly? (Teams Admin Center → User Activity Reports)
• Who opens Word/Excel? (App Usage Reports, if available)
• Who never logs in? (Azure Sign-in Logs → Inactive for 60+ days)

Step 3: Map Roles to Licenses

For each person:

• Frontline Worker, Teams + mail only → F1/F3
• Standard office role with document work → E1 or E3
• Someone needing Power BI or advanced analytics → E5
• Inactive account → deactivate (instant 100% savings)

Step 4: The Power Platform Trap

This is where most organizations hemorrhage money.

One person on a Power Apps per-user license (€40–70/month) for a single app. But you could instead buy an app-based license (€11/app/month, shared across 100 users) or add premium connectors only to the 3 people who need them.

Real example: A company with 200 users had 15 people on per-user Power Apps plans at $8,400/year. App licenses plus targeted premium connectors would have cost $1,800.

That's 78% waste.

The Add-On Strategy: Why Upgrading Is Sometimes Expensive

Here's a trick many miss:

Intune Standalone costs $8/month. Intune bundled in E3 is included but only if you buy the whole E3 plan ($14+). If someone only needs Intune for device management, not Office—buy E1 + Intune add-on. That saves $6–8/month per person.

Similar math:

• Power BI Standalone ($12–20): Cheaper than upgrading one analyst to E5
• Teams Phone ($5–13): Only for users who need calling, don't upgrade everyone
• Teams Rooms ($16): Cheaper than putting a conference room on E5

Your Typical Savings

I audit 50–200 person companies constantly. Here's the pattern:

Before: 60 users, everyone on E3 = $840–960/month ($10,000–11,500/year)

After:

• 10 Frontline Workers on F1: $60/month
• 35 Standard Office roles on E1: $280–350/month
• 12 Power Users on E3: $168–192/month
• 3 Executives on E5: $66–84/month
• 2 Inactive accounts: $0

New total: $574–686/month ($6,900–8,200/year)

Savings: 28–32%.

Bonus: You've also reduced your security surface. Fewer E5 accounts means fewer high-value targets for attackers to compromise.

The CSP Advantage

Every license has different costs depending on your partner. As a Microsoft CSP partner, we pull real usage reports directly from your tenant and optimize month-over-month—no guessing.

If your current provider can't tell you exactly who's using Power BI or which inactive accounts should be deleted, that's a problem. Most can't.

How to Start

1. Request an audit – We pull your current licenses and actual usage data
2. Mapping session – Define the right license tier for each person
3. Test run – Roll out changes, gather feedback
4. Ongoing optimization – Monthly monitoring instead of yearly overpayment

Most companies recoup the audit cost ($500–1,500) in one month. Then it's pure savings.

Your time matters. We audit—you save 30%.

---

See also:

• Where M365 Budget Disappears
• Automated Intune Onboarding
• When Excel Becomes a Business Risk