Excel Desktop vs Excel for the Web

Excel online vs desktop is mostly a question of what you need beyond formulas. Excel for the web (still often called Excel Online) runs free in a browser and handles everyday spreadsheet work: formulas, tables, charts, pivot tables and sharing. The desktop app on Windows or Mac adds macros, advanced data tools and the full set of options, and works offline. This guide is for anyone deciding which one to learn on, or wondering whether a browser-based job test will feel different.

Excel desktop vs Excel for the web at a glance#

The two share the same file format and formula engine; the differences are in tools, options and where they run.

What both versions do the same#

For the skills most jobs ask for, the two behave the same. The same .xlsx file opens in either, and a formula gives the same answer in both. That covers:

• Formulas and functions: arithmetic, SUM, IF, VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, FILTER, SORT, UNIQUE and so on.
• Cell references, including $ locking and references to other sheets.
• Formatting: number formats, fonts, borders, conditional formatting.
• Data tools: tables, sorting, filtering and data validation drop-downs.
• Pivot tables and charts for typical summaries.

If you're just starting, our guide on how to write your first Excel formula works the same in both.

What only the desktop app does#

The desktop app is the full product, and several tools exist only there or are much more complete there:

• VBA macros. The browser can open a macro-enabled file, but it can't run or edit its macros. Some business and school Microsoft 365 plans offer Office Scripts on an Automate tab instead, which is a different scripting tool.
• Power Pivot and the data model for very large, related tables. Power Pivot is in Excel for Windows only.
• Power Query is fuller on desktop, especially on Windows, for importing and reshaping data from many sources.
• Advanced options in charts, pivot tables, page setup and the Options dialog.
• COM add-ins and some third-party tools that install on your computer.
• Working offline, on a plane or anywhere without a connection.

Finance and analyst roles often rely on these tools. Our guide to Excel skills for finance and accounting jobs explains which ones come up most.

What Excel for the web does well#

The browser version has real advantages, not just a smaller feature list:

• No installation: open any workbook from OneDrive, SharePoint or a shared link on any computer with a modern browser.
• Automatic saving: every change is saved as you go.
• Co-authoring: several people can edit at once and see each other's changes.
• Free access: anyone with a Microsoft account can practise, which helps if you don't have a licence yet.

The same task in both#

Here is one small timesheet. The tasks: work out each person's pay, total the week and summarise by person.

Formulas: identical#

In both versions, type =B2*C2 in D2 and fill down with Ctrl+D (⌘D on a Mac). For the total, either =SUM(D2:D5) or one formula without the helper column:

=SUMPRODUCT(B2:B5,C2:C5)

Both versions return 5,466. Our comparison of SUMPRODUCT vs SUMIFS explains when SUMPRODUCT is the better choice.

Pivot table: the same idea, slightly different screens#

Click inside the data and choose Insert > PivotTable in either version. Desktop opens a dialog where you confirm the range and choose a new or existing worksheet; the web version shows a similar panel. In both, you then tick fields in the PivotTable Fields pane and drag them between Rows, Columns, Values and Filters. The basic steps carry over; the desktop app simply has more settings once the pivot exists.

Saving: different habits#

On desktop, a file saved on your computer needs Ctrl+S (⌘S). In the browser, there is no Save step; changes are saved automatically, and File > Save As has options to save or download a separate copy.

When to use Excel desktop#

Choose the desktop app when the work needs more than the essentials:

• The workbook uses macros or you need to write them.
• You work with large data, Power Query or Power Pivot.
• You need offline access or advanced chart, pivot and print options.
• You're practising for a job that uses desktop Excel every day, so the screens and shortcuts match.

When to use Excel for the web#

Choose the browser version when convenience and sharing matter most:

• You're learning the basics and don't have a licence yet. Our guide on how long it takes to learn Excel for a job suggests where to start.
• Several people edit the same file, such as a team tracker.
• You're on a computer where you can't install software.
• A quick edit is all you need, from any device.

Will a browser-based Excel test feel different?#

Some online Excel assessments run in a browser, either in Excel for the web or in a practice spreadsheet built into the test platform. The formulas you type are the same, but a few habits are worth checking in advance. Practise selecting ranges and filling down with the keyboard in a browser, since a shortcut the browser intercepts can cost you time. Learn where the ribbon commands sit, because the browser ribbon is arranged a little differently. And read the task carefully for the version it expects: a test that asks for XLOOKUP or FILTER assumes a modern version, while one that names VLOOKUP works anywhere.

Common mistakes when switching between them#

These are the surprises people meet most often:

1. Expecting macros to run in the browser. They won't; open the file in the desktop app.
2. Pressing browser shortcuts by habit. In Excel for the web, keys such as Ctrl+N or Ctrl+W may act on the browser instead of the workbook.
3. Looking for a Save button in the browser. It saves automatically; use File > Save As for a separate copy.
4. Assuming an option is missing everywhere. If the browser doesn't show a setting, check the desktop app before giving up.
5. Forgetting the file lives online. Changes to a shared web file are visible to everyone with access.

Clear formulas help in both versions; our comparison of named ranges vs cell references covers one way to make shared workbooks easier to read.

Our recommendation#

Learn on whichever version you have: formulas, references, tables and pivot basics transfer directly between them. If you can, use the desktop app for regular practice, because it has every tool a job might ask for and its screens match most offices. Keep Excel for the web for quick edits, sharing and co-authoring, and for practice on any computer.

In short: the web for everyday work and sharing, the desktop app for the full toolkit.

Practise it#

Try the SUMPRODUCT exercise on this page, then open the first formulas lesson to build pay formulas and see the order of operations in a live sheet. When you're ready for summaries, the pivot tables lesson walks through creating a pivot, moving fields between areas and switching from sums to counts and averages.