Excel desktop vs Excel Online: key differences that matter in practice
Watch alongside this article
Public YouTube resources matched to this article's topic, functions, and practice goal.
Relative vs Absolute Cell Reference in Microsoft Excel - What's the difference?
Teacher's Tech
Open on YouTube (opens in a new tab)
The Beginner's Guide to Excel - Excel Basics Tutorial
Technology for Teachers and Students
Open on YouTube (opens in a new tab)
Excel Basics - The Anatomy of a Spreadsheet
Technology for Teachers and Students
Open on YouTube (opens in a new tab)Excel Online (the browser version at office.com) and the desktop Excel app look similar but have real differences. Most are invisible for everyday tasks; a few matter a lot.
What Excel Online handles well
For reading, editing cells, entering formulas, and collaborating on a shared workbook in real time, Excel Online is genuinely capable. Most common functions work, filters and sorting work, and you can share a link for someone to edit without needing a Microsoft 365 licence. It saves to OneDrive automatically and keeps version history.
What only the desktop app can do
Some things simply are not in Excel Online yet:
- Macros and VBA — you can view a workbook that has macros but cannot run or edit them.
- Power Query — the Get & Transform data tab is not available in the browser.
- Some advanced charting — chart types like waterfall, treemap, and sunburst are missing or limited.
- Complex conditional formatting — rules work but cannot be created from scratch.
- Some newer dynamic array functions — availability lags behind the desktop.
- Add-ins — most third-party add-ins require the desktop app.
- File size — very large workbooks become slow or fail to load entirely.
The version that matters for sharing
If you are sending a workbook to someone who uses Excel Online, test it there first. A workbook that looks fine on the desktop can behave differently in a browser if it relies on macros, complex formatting, or add-ins.
Quick rule
For solo, complex, or automated work: desktop. For collaboration, review, or lightweight editing: Online. For most people on most days: both, depending on what they’re doing.
Go deeper with this skill
Build a confident foundation by practicing navigation, data entry, formatting, references, and simple calculations together. For this article, the goal is to practice: What Excel Online can and cannot do compared with the desktop app — the gaps that matter for everyday work and the ones that don't.
Practice workbook setup
Create a starter workbook with one sheet for raw practice data, one sheet for formatted output, and one sheet for notes.
Practice workflow
- Enter a small table manually so you practice rows, columns, headers, and basic formatting.
- Use simple formulas such as totals, averages, and percentages before moving to advanced functions.
- Practice copying formulas while watching how relative and absolute references change.
- Format the result for readability, then remove any formatting that does not help the reader.
Quality checks
- Numbers are stored as numbers, dates as dates, and labels as text.
- Formulas copy correctly down the table without broken references.
- The final sheet can be understood without needing the practice notes.
Common mistakes
- Typing numbers with currency symbols or spaces that turn them into text.
- Copying a formula before checking whether references should stay fixed.
- Using formatting to cover unclear labels or inconsistent structure.
Next actions
- Rebuild the same workbook without looking at the tutorial.
- Turn the range into a table and repeat the formulas using table headers.
Formula focus: even if this workflow is not formula-heavy, add one check cell that confirms the final output still matches the source data.
