Microsoft Excel 16.93 — Mac version

You'll need a Mac running macOS 13 (Ventura) or newer. That's the hard line — anything older and the installer won't even open. It runs native on both Intel and Apple Silicon machines, so your M1 or old Retina iMac are both welcome.

Tools you'll actually use

The headline features are the new chart types and the Ideas pane. Ideas scans a highlighted range and suggests pivot tables, trend lines and patterns — handy when you've inherited a messy sheet and need to find the story in the numbers without building the model from scratch. Collaboration holds up well for audit and finance work, with shared workbooks that don't lose their thread when multiple people are in the same cell. Power Query is baked in, so pulling data from a folder of CSVs or a SQL database doesn't need extra plugins.

Build and update path

This is the Office LTSC Standard for Mac 2024 build, volume-licensed and activated with the VL Serializer. Once you've run the standard Office installer — grabbing the individual package for Excel if that's all you need — the Serializer sorts the licence side. After that, install Microsoft AutoUpdate and let it pull down patches the usual way. If activation goes sideways, a full removal and clean install almost always fixes it.

Finance teams lean on array formulas and Power Query daily

Finance and accounting folk are the obvious crowd. If you spend your day in general ledgers, depreciation schedules or cashflow models, you'll lean on array formulas, Power Query and the new chart engine daily. Auditors get a lot out of the Ideas pane too — highlight a workbook you've never seen before and it surfaces outliers you'd otherwise hunt for by eye.

There's a quieter group that benefits just as much: people running old Macs as secondary workhorses. If you keep a 2015 iMac on the desk purely for number-crunching while your main machine does other jobs, Excel 16.93 on Monterey-or-later is a solid reason to leave that machine in service. The native Intel build means it doesn't crawl on older silicon the way some Electron apps do.

Students and researchers working with survey data or lab results get a leg up from the Ideas tool without needing to learn pivot-table logic first. Mark a block of responses and Excel suggests summaries that would take half an hour to build manually. It's not a statistics package, but it closes the gap for quick exploratory work.

Pasted numbers land as text instead of values

The most common stumble is fighting the cell format instead of fixing the data. Someone pastes numbers from a web page, they land as text, and the user starts typing apostrophes and re-typing values. Select the range, click the warning triangle, choose Convert to Number — five seconds and you're back to work. Format-painting the whole sheet before checking what's actually text is a habit worth breaking early.

Another one: ignoring named ranges. New users often write formulas that point to B2:B247 and then break when a row gets inserted. Give that range a name — MonthlyTotals, say — and the formula survives edits that would otherwise send you hunting for #REF! errors. It also makes the formula bar readable when you open the file six months later.

Power Query trips people up when they treat it like a macro recorder. It's not recording keystrokes; it's building a transformation pipeline. If you delete a column in step four and then wonder why step seven can't find it, step through the Applied Steps pane before redoing work. The fix is usually removing one step, not rebuilding the whole query.

Start by cleaning 30,000 rows of inconsistent transaction data

You open a workbook the finance team dropped in a shared folder. Thirty thousand rows of transaction data, one sheet, no summaries. The column headers are inconsistent — some capitalised, some not, spaces where underscores should be.

First move: select the whole range and hit the Ideas button on the Home tab. A sidebar opens and within ten seconds it's flagged three unusual spikes in the "amount" column and suggested a trend line for weekly totals. You click the trend suggestion and Excel inserts a new sheet with the chart already built. That's the headline for Monday's meeting sorted before you've touched a formula.

Next, you fire up Power Query. Point it at the folder where the team drops daily CSV exports and set it to combine and load. You clean the column names in the query editor — lowercase, underscores — and filter out rows where the transaction code is blank. The query saves with the workbook, so tomorrow you just hit Refresh and the new day's files feed straight in.

You build three named ranges for the key columns: txn_date, txn_amount and txn_category. A quick SUMIFS against the category range gives you department totals, and you wrap that in an XLOOKUP to pull in budget figures from a separate sheet. The variance column gets a conditional formatting rule — red for overspend, green for under — and the sheet is ready to share.

Before you close up, you check the AutoSave toggle is on. The file lives on OneDrive, so your colleague in the audit team can open it on her MacBook while you're still tweaking. You see her cursor move into the variance column and add a comment flagging one figure for review. You reply in-thread, mark it resolved, and step away for a coffee.

Numbers opens .xlsx for viewing but skips macros and Power Query

Excel doesn't sit alone. The Numbers app that ships with every Mac can open .xlsx files for quick viewing, but it doesn't run VBA macros or Power Query — so for reading a sheet someone sent, it's fine; for doing the work, you want Excel itself. The two can coexist without fighting over file associations if you set the Finder defaults carefully.

Power Query connects directly to local SQLite databases and PostgreSQL servers, so researchers who collect data in a database can pull live queries into Excel without exporting CSVs first. The connection stays live — refresh the workbook and the query runs again against the current data. Pair that with Excel's Data Model and you can relate tables without writing VLOOKUP chains.

For sharing, Excel hooks into the macOS Share menu. Send a workbook via Mail and it attaches as-is; send it via Messages and the recipient gets an .xlsx they can open on their iPhone or iPad with the iOS Excel app. The file format hasn't changed, so Windows colleagues see exactly what you built — charts, conditional formatting, named ranges and all.

If you use Quick Look (tap the spacebar on a file in Finder), Excel previews render natively without opening the full app. Handy when you're hunting through a folder of old workbooks and just need a peek at the numbers.

• New chart types added to the chart gallery.
• Ideas pane: highlight data and get suggested visualisations and trend summaries.

• macOS 13 or later
• Intel or Apple Silicon Mac