Excel guides
Microsoft's spreadsheet application — the deepest tool in the Office suite. See the glossary entry →
22 guides touch on excel.
- Copilot in Excel: Advanced Analysis with Python
What Advanced Analysis in Copilot in Excel does, how it relates to Python in Excel, where the code runs, the compute cost, and the honest limits.
- Copilot in Excel: formula columns, tables, and charts
The formula, table, chart, and PivotTable prompts that reliably work in Copilot in Excel, why tables still matter, and the COPILOT() function.
- Copilot Prompt Gallery and prompt governance
What the Copilot Prompt Gallery (formerly Copilot Lab) is, how saved and shared prompts work, the tenant controls, and a lightweight governance model.
- Microsoft 365 Apps for Mac
Deploying and managing Office apps on macOS — installation, updates, Intune management, and Mac-specific features.
- Microsoft 365 Copilot in Excel
How Copilot in Excel helps with formulas, analysis, and chart generation — and what it can't yet do.
- Microsoft 365 Copilot licensing
Microsoft 365 Copilot licensing without the marketing: eligible SKUs, how the add-on works, the free and paid Copilot Chat tiers, and the trade-offs.
- Microsoft 365 vs Google Workspace
Microsoft 365 vs Google Workspace compared without marketing: feature by feature, where each wins, where it doesn't matter, and how the decision gets made.
- Microsoft Forms — surveys, quizzes, and polls
How to design good surveys and quizzes with Microsoft Forms, and how it integrates with the rest of Microsoft 365.
- Microsoft Forms: branching logic and quiz mode
Advanced Microsoft Forms: branching that behaves, quiz mode with auto-grading, practice mode, Excel sync, Copilot in Forms, and when to move to Power Apps.
- Microsoft Graph API basics
An introduction to the Microsoft Graph API — what it is, how to authenticate, the day-to-day query patterns, and the gotchas that bite every new integration.
- Microsoft Lists templates and patterns
Practical patterns for using Microsoft Lists — templates, column formatting, integrations, and where Lists fits best.
- Microsoft Viva Goals and OKRs after retirement
Viva Goals is retired: what it did, what happened to the data, and how to run OKRs in Microsoft 365 now with Planner, Loop, Viva Engage, and Power Platform.
- Migrating from Google Workspace to Microsoft 365
A practical migration playbook for moving from Google Workspace to Microsoft 365 — workloads, tools, and pitfalls.
- Office add-ins development overview
The modern Office add-in model — web-based extensions for Word, Excel, PowerPoint, Outlook running across platforms.
- Office Scripts in Excel
Office Scripts is Microsoft's modern automation language for Excel — what it does, where it runs, and how it compares to VBA.
- Power Apps — canvas vs model-driven
The two main Power Apps types — what each is good at, and how to pick.
- Power Automate desktop flows and RPA
Desktop flows automate UI on Windows machines — Microsoft's robotic process automation capability inside Power Automate.
- Power Fx primer
A practical introduction to Power Fx, the formula language used across Power Apps and the Power Platform.
- Power Query primer
Power Query is the data import and transformation engine inside Excel and Power BI. Here's the model.
- SharePoint Lists vs Microsoft Lists
SharePoint lists, Microsoft Lists, Dataverse, Excel — picking the right place for structured data.
- What is Microsoft 365 Copilot?
What Microsoft 365 Copilot is: what it does in Word, Excel, Outlook, and Teams, how grounding works, what it costs, and what to fix before rollout.
- What is Power Apps?
What Power Apps is: each app type and what it's for, where Dataverse fits, what's really included with Microsoft 365, and when not to use it.