Excel for executive assistants on Mac: trackers, lookups, pivots and voice help in 2026

Excel templates for executive assistants on Mac

Most executive assistants keep the same few sheets open all week. The usual set is an expense report, a travel log, a leave planner, a timesheet and a monthly report for the executive. Most of this work repeats. The same expense report comes in every month. The same leave tracker gets updated every week. That makes it the easiest kind of work to speed up, because you set each sheet up once and reuse it.

A 2022 survey of office workers found people keep about 2.6 spreadsheets open at any one time. The stats below come from the same kind of research. Read them as a rough guide to a typical week.

Those figures describe office workers in general. No survey of executive assistants on Excel use turned up in the research. Treat them as context, not as a benchmark for your role.

Start from a template instead of a blank sheet

Do not rebuild the expense report from scratch every month. Open File > New from Template in Excel for Mac. Personal templates you have saved appear under the Personal tab. Save your cleaned up version as a template once, then open a fresh copy each time.

To save a sheet as a template, use File > Save As and choose the Excel Template format in the file type list. Keep the blank master in one folder, and work only in copies.

Ready made templates help when you start from nothing. Smartsheet lists 22 free Excel templates for Mac, including an Expense Report, a Timesheet and a Monthly Calendar. ElyxAI offers five free templates for executive assistants. They cover team schedules, expense reports, executive leave planning, monthly reporting, and contract and deadline tracking. Both are vendor pages, so check each layout against how your office works.

XLOOKUP for contacts, names and dates

A lookup finds one value by matching a key. Executive assistants use lookups for contact details, room codes and cost centers. In Microsoft 365 for Mac, XLOOKUP is the simplest way to do this. You give it the value to find, the column to search and the column to return.

Here is a worked example. Your contacts sit on a sheet named Contacts. Names are in column A and phone numbers are in column C. In cell D2 of your tracker, with the name in B2, enter =XLOOKUP(B2,Contacts!$A:$A,Contacts!$C:$C,"Not in list").

If B2 matches a name in column A, Excel returns the phone number from column C. If nothing matches, the cell shows Not in list instead of #N/A. A plain message is easier to spot in a report than an error code.

Two edge cases catch people. First, a trailing space breaks a match. A name typed as Jo Smith with a space at the end will not find Jo Smith. Wrap the lookup value in TRIM, as in =XLOOKUP(TRIM(B2),Contacts!$A:$A,Contacts!$C:$C,"Not in list"). Second, whole column references such as $A:$A pick up new rows as you add contacts. Fixed ranges like $A$2:$A$40 miss them.

• Keep the lookup list on one sheet with a single header row.
• Use the fourth argument for a not found message, so gaps show clearly.
• Check one result by hand before you fill the whole column.
• Fill a working formula down with ⌘D instead of retyping it.

Date formulas for leave, deadlines and timesheets

Date math is where assistant sheets go quietly wrong. Excel stores each date as a number. That lets you subtract, add and count days. A date typed as text looks right but calculates as nothing.

To count working days between two dates, use NETWORKDAYS. Put the start date in B2, the end date in C2, and a list of public holidays in a range named Holidays. Then enter =NETWORKDAYS(B2,C2,Holidays). The count includes both end dates. Adjust the formula if your leave policy treats the first day differently.

To find the last day of a month, use EOMONTH. The formula =EOMONTH(B2,0) returns the month end for the date in B2. That helps with monthly reports and deadline tracking. EDATE moves a date forward or back by a set number of months.

To name the holiday range, select it, choose Formulas > Define Name and type Holidays. The name keeps your formula readable when you copy it to another tab.

Text dates are the usual problem. If a date sits aligned to the left of its cell, Excel reads it as text. Select the column and choose Data > Text to Columns. Pick the date format that matches your data, then finish. Check one cell before you trust the whole column.

Pivot tables for monthly executive reports on Mac

A pivot table turns a long list of expenses or meetings into a summary. You can total by person, by month or by category without writing formulas. Start with your data in one flat table. Use one header row and no blank rows inside the data.

Select any cell in the table and choose Insert > PivotTable. Microsoft's October 2026 What's New post says you can name a table at creation in Excel for Windows and Mac. Give it a clear name, such as ExpenseData, so the pivot source reads well.

Drag Person into Rows, Category into Columns and Amount into Values. Set Amount to Sum. A Count tells you how many lines there are, which answers a different question. When you add rows to the source, Control-click the pivot and choose Refresh. If new rows do not appear, check that the table covers them.

For a full walk through, see how to make a pivot table in Excel on Mac.

A worked example: the monthly executive report

Here is the sequence I would follow for a report built from an expense tracker. The first pass takes some care. After that, each month is a paste and a refresh.

1. Click one cell inside the expense data and press ⌘T to make it a table.
2. Add a Month column with =EOMONTH(A2,0) so every row carries its month end.
3. Choose Insert > PivotTable, pick the table and place the pivot on a new sheet.
4. Set Category as Rows, Month as Columns and the sum of Amount as Values.
5. Add a check cell with =SUM(ExpenseData[Amount]) and compare it with the pivot grand total.

Save the sheet as a template when the layout is right. Next month, paste the new export directly under the table, then refresh the pivot. The structure stays the same, so the report stays stable.

Clean messy data before it reaches your executive

Data from a vendor, a travel portal or a colleague often arrives messy. Names come in all capitals. Dates arrive as text. Duplicate rows appear after a second export. Clean a copy, never the original file.

• Trim spaces with =TRIM(A2), which removes extra spaces around and between words.
• Fix capitals with =PROPER(A2), which turns ALL CAPS names into Title Case.
• Remove duplicates from the table with Data > Remove Duplicates, choosing the columns that define a unique row.
• Split a combined column with Data > Text to Columns and the Delimited option, then pick the separator.

For bigger cleanups, Microsoft says the Copilot in Excel clean data skill is rolling out to general availability on all platforms. Call it with @clean-data or from the Skills menu. The skill recorder is still Insider only on Mac, so you cannot record your own skill yet. Keep a copy of the raw export either way.

Ask Lazur while you work 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. Because it sees the sheet, you do not need to describe every cell. See Lazur for Excel on Mac for more.

Three kinds of question come up most in Excel. Ask where a button is, and Lazur draws a circle and a label around it on your screen. Ask how to do a task, and Lazur guides you one click at a time, waiting for each click before the next step. Ask why something broke, and Lazur explains the likely cause in plain words.

Hold fn to dictate. Dictation writes clean, formatted text at the cursor in any app. Use it for the cover note that goes with a report, or for a comment on a cell. Snippets and a personal dictionary help with names you type every day.

Lazur does not click for you, edit your file or run Excel. You stay in control of every change. Lazur can also handle timers, Apple Reminders and Calendar events while the sheet stays open.

Check formulas before a sheet goes to your executive

A sheet that looks right can still be wrong. A few checks take about a minute and catch most problems.

• Formulas > Error Checking scans the sheet for error values such as #N/A, #REF and #DIV/0, which show up when a formula breaks.
• Formulas > Show Formulas displays every formula at once, so you can scan each column.
• Test one row by hand with a calculator, then compare the result with the formula.

Name your key totals. A name such as MonthlyTotal reads better in a formula than a bare cell reference. When a number looks odd, click the cell and read the formula bar before you change anything.

Mistakes that waste an assistant's afternoon

• Merged cells inside a table. Merged cells break sorting, filtering and pivots. Use alignment settings instead.
• Numbers stored as text. Totals can come out wrong or sum to nothing. Re-enter the values or convert the column.
• Typing over formulas. A total typed over a formula hides the error. Keep the formula and check it.
• Editing the master template. Open a copy each month and keep the blank master in a folder you do not edit.
• Deleting rows a formula depends on. This causes a #REF error. Press ⌘Z right away to undo.
• Blank rows in pivot sources. They create empty items in the pivot. Clear them from the data first.

Most of these show up in the monthly report, not while you build the sheet. Check the report total against the source once a month. That single check catches most problems.

Mac limits to know before you build

Excel for Mac is not identical to Excel for Windows. Some features arrive later, and some are missing. Check the features you need before you build a workflow around them.

Power Query on Mac had limited sources in a May 2022 Excel Campus review. That review lists only two sources at the time, no connection only option and no From Folder option. It is an old review, so check what your current version offers before you rely on it.

Excel > About Excel shows your exact version. Compare it with Microsoft's release notes before you plan a change for the whole office.

Privacy when a sheet holds confidential schedules

An executive's calendar, travel and leave details are sensitive. Check your company's rules before you ask any AI tool about them. Some offices do not allow screen content to leave the building at all.

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers so they can answer. They are not stored. Content is never used to train AI models. Lazur keeps a memory of what you asked and did, and that memory stays on your Mac.

If your office rules forbid sending screen content to outside services, keep Lazur idle while that sheet is on screen. Use it for the sheets that are fine to share.

Pricing and the trial

Lazur has a trial that needs no credit card. The Pro and Power plans are listed on the pricing page. Dictation is unlimited on both plans.

Next steps for this week

1. Open File > New from Template and save your current expense sheet as a template.
2. Clean one month of data in a copy before you build the pivot.
3. Swap fragile lookups for XLOOKUP with a not found message.
4. Build one pivot for the monthly report and check it against the source total.
5. Hold ⌥⌘ the next time a formula breaks and ask Lazur what the error means.