Excel for architects on Mac: a voice helper for schedules, formulas and pivot tables

If you keep schedules, finish lists or cost estimates in Excel, most of the work is ordinary. Sorting, filtering, lookups and totals all run on a Mac. The trouble starts when a sheet gets large, when you want a pivot table that reads from a data model, or when a macro from a Windows colleague stops working. This page covers each case in order.

What works in Excel for Mac and what does not

Excel for Mac covers the core of the program. You get worksheets, tables, formulas, filters and charts. Those tools carry most schedules. The gaps are narrower, but they show up fast when you open a file that someone built on Windows.

Power Query on Mac: test it before you trust it

Sources disagree about Power Query on Mac. An MVP wrote in January 2025 that the full editor comes with Mac Excel. A Microsoft Community Support answer in the same thread says editing needs Windows, Beta Channel access or specific subscriptions. Excel Campus reported in May 2022 that the editor was limited to the Insider Beta Channel at that time. A reader there said the editor worked on version 16.92 in December 2024. That comment is a user report, not a Microsoft statement.

Run the check on your own Mac. Open a blank workbook and choose Data > Get Data. Look for Power Query Editor in the menu. If you can start a query and edit its steps, you can use the editor for shaping lists. If you cannot, plan the query work on Windows, or ask a colleague who has it to build the query for you.

Row and column limits in a big schedule

One worksheet holds 1,048,576 rows and 16,384 columns, according to an MVP in a Microsoft Q&A answer from April 2025. A door schedule with one row per door rarely reaches the row limit. A cost list exported from a project database can. When an export runs past that line, the rows beyond it do not fit on the sheet at all.

Split the list before it gets close. Divide it by level, phase or discipline, and put each part on its own sheet. Then build a summary sheet with totals that point at each part. Keep the summary formulas short, so you can check them by hand before you send the file out.

Set up a schedule as a named table

Turn your list into a table before you write formulas. Select the range and press ⌘ T. A table keeps headers in place, adds filter arrows and lets formulas refer to columns by name. Microsoft's October 2026 release notes say you can name a table when you create it, on Mac as well as Windows.

Name the table tblDoors or doors_L2, not Table1. A formula then reads =COUNTIFS(tblDoors[Level],"L2") instead of =COUNTIFS(D2:D400,"L2"). The named version keeps working when you add rows. The fixed range does not, because it stops at the last row you typed.

A common mistake is typing a total directly under the table. Excel can then treat the total as more data, and a filter can hide it. Put totals in a separate block above the table, or switch on the Total Row option in the Table Design tab.

Reading formulas you inherit from someone else

Many files arrive with formulas nobody explains. Read them from the outside in. Start with the cell that shows the result. Then follow each argument back to its source. Formulas > Trace Precedents draws arrows to the cells a formula uses, which shows where the numbers come from.

Use Formulas > Evaluate Formula to step through a nested IF one piece at a time. Watch for ranges that stop one row short. That mistake returns a total that looks right, but it misses the last item on the list. Check the total against a second method before you trust it.

Pivot tables on Mac without Power Pivot

A pivot table works on Mac when it reads from a plain range or a named table. Select a cell inside tblDoors. Choose Insert > PivotTable. Drag Level to Rows, Finish to Columns and Door ID to Values, then set the Values field to Count. You get a count of each finish by level, with no Data Model involved.

Skip Power Pivot and the Data Model on a Mac. Microsoft's moderators say Excel for Mac does not support them. If a Windows colleague built a pivot on a Data Model, you may see a Data Model error when you filter it. The fix is a rebuilt pivot on flat data, or a Windows machine for that one file.

For the full click path, read how to make a pivot table in Excel on Mac. It covers the Microsoft 365 steps from start to finish.

The 2026 functions and Center across selection

Microsoft's September 2026 Insider release adds lists, arrays in cells and nested arrays on Windows and Mac. It also adds four functions: FLATTEN, HAS, HASANY and HASALL. Insider features only appear on builds enrolled in the Insider program. If you do not see them, your build does not have them yet.

The same release adds a Center across selection button to the Merge and Center menu. It centers a title across columns without merging the cells. Merged cells cause trouble for sorting and copying, so use this button when you can. It is an Insider feature as well, so check your build first.

Macros and VBA on a Mac

Mac Excel runs VBA, but the experience differs from Windows. Noble Desktop reports that UserForm development is slower, the Properties window is missing, and code collections cannot be imported or exported. Noble also says there were no VBA options for Excel on a Mac before the 2016 release of Excel for Mac.

Keep macros small and documented. Copy each module's code into a text file in your project folder, so you still have it when a file moves between machines. If a macro needs a UserForm, build that form on Windows. Or ask whether the job can run as a formula or a query instead, which usually travels better.

Mistakes people make in Excel on a Mac

• Assuming a Windows add-in works. Noble Desktop says a few add-ins lag behind Windows, without naming them. Test the add-in before a deadline.
• Building a pivot on a Data Model, then opening it on a Mac where the Data Model does not work.
• Trusting Power Query without opening the editor first. Check Data > Get Data on your own machine.
• Using a 2026 Insider function in a file that a colleague on a stable build has to open.
• Forgetting the build number. Check it under Excel > About Excel. The newest Mac build I could verify is 16.95.4, from April 2025.

Ask Lazur for help while you stay in Excel

Lazur is a voice assistant for the Mac. It lives in the notch. Hold ⌥ ⌘ to ask about anything on screen, and Lazur answers out loud. Ask where a button is, and Lazur draws a circle and a label around it. Ask how to do something, and Lazur guides you one click at a time, waiting for each click. Lazur does not click for you.

Hold fn to dictate. Clean, formatted text lands at the cursor in any app. That helps when you write a note in a cell, a comment or an email draft. Dictation is unlimited on both plans, so long notes do not use up your AI actions.

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. If your client files are sensitive, check your firm's rules before you ask about them.

A worked check on a finish schedule

Here is a short routine for a finish schedule. Turn the list into a table with ⌘ T, then name it. Add a Checked column. Use Data > Data Validation > List to give it two choices, Yes and No. Filter for No before each meeting. If a count comes back as zero when you expected a number, ask Lazur to explain the formula in that cell.

The routine is simple on purpose. Each step can fail in a small way. A header with a stray space, a filter left on, or a validation list that does not match the spelling in the cells will cost more time than the routine saves. Check the filter arrows at the top of the table before you trust any count.

Check your Mac version before you share a file

Before you send a workbook to a Windows colleague, check which Mac build you used. Open Excel > About Excel. Then compare the features in the file with Microsoft's What's New posts. Insider-only features may not behave the same on a stable build, so remove them or warn the recipient.

Where to go next

1. AI assistant for Excel on Mac: help with formulas, buttons and pivot tables.
2. How to make a pivot table in Excel on Mac: the full click path for Microsoft 365.
3. How to open an Excel file in Numbers on Mac: three methods if Numbers is your main app.
4. Excel help for accountants on Mac: a parallel guide for finance sheets.
5. Lazur pricing: the plans and the trial.