Excel for compliance officers on Mac: audit trails, checks and voice help in Microsoft 365

Most compliance officers do not live in Excel all day. The file opens when a policy check, an audit request or a vendor review lands on the desk. By then the workbook is often shared, often old, and often built by someone else. Excel for Mac handles this well once you know where the tools are. Start with three tabs: Review, Data and Formulas. Between them they hold most of what a compliance file needs.

What compliance work looks like in Excel on Mac

Compliance work in a spreadsheet is usually plain. You keep a control register with an owner, a due date and a status for each row. You log exceptions and the reason for each one. You track training completion and policy sign-offs. You compare a vendor list against an approved master list. Every one of these jobs depends on two things. The numbers must be right, and someone must be able to see who changed them. Excel does not give you the second point by default, so you need a few habits to fill the gap.

• Control registers with owners, due dates and status columns
• Exception logs that record who approved each exception and why
• Attestation trackers for policies that staff must sign each year
• Vendor or supplier lists checked against an approved master list
• Transaction samples pulled for review from a larger export
• Training completion sheets that feed a quarterly report

Check your Excel version before you promise a workflow

Start with Excel > About Excel. The version number tells you which features your copy can use. Microsoft's Office for Mac release notes list Excel 16.114 for October 2026, with quality and performance improvements only. Version 16.113, released September 16, 2026, added a change history skill that explains how a workbook has evolved. If a menu item in this guide is missing from your window, check the release notes first.

Power Query is the other version question. An unaccepted answer on Microsoft Q&A says Get Data reached Excel for Mac at version 16.69 and needs macOS 13 Ventura or later, including Apple silicon. Treat that as a lead, not a rule. Confirm it on Microsoft's own pages before you roll anything out to a team.

Show Changes in Excel for Mac: the audit trail most people miss

Show Changes is the audit trail most people miss. Open the workbook, then go to Review > Show Changes. Microsoft says the feature tracks changes made in Excel for Mac, Excel for the web, Windows, iPad, iPhone and Android. It shows changes from the past 365 days. For a compliance file, that cross-platform reach matters. A control owner may edit the register on an iPhone between meetings, and Microsoft says those edits show up too.

Be careful about what the history proves. Microsoft's page does not list exclusions, but that does not prove every edit appears. Test it on a copy. Change one cell, save, then look for that change in Show Changes. Keep dated copies of final versions in a separate archive folder as well. Show Changes is a helpful record, not a sealed log.

1. Open the workbook in Excel for Mac.
2. Go to Review > Show Changes.
3. Read the changes listed for the period you need, and note the date, the person and the cell.
4. Copy those entries into a review log sheet, with the date you reviewed them.
5. Save the log with the version you signed off.

Excel error checking on Mac: find formula problems before sign-off

Formula errors are the quiet risk. One secondary summary of Raymond Panko's audit work says about 94% of operational spreadsheets audited had at least one error. It also puts the average cell error rate near 5%. The original papers were not checked for this page, and other sources report different figures. Read these numbers as a warning, not a measure of your own file.

On Mac, start with Formulas > Error Checking. It walks you through cells Excel flags as suspicious. Then use Trace Precedents and Trace Dependents on the Formulas tab. They show where a value comes from and what relies on it. Error Checking catches many mechanical problems. It cannot tell you whether the logic matches your policy.

Hard-coded values are a classic audit finding. A rate or a threshold typed inside a formula is hard to see and hard to change. Press ⌘ F, then search for the number you expect to find. Check whether it sits inside a formula or in its own labeled input cell. Move each threshold to a labeled cell, then point the formulas at it.

Power Query in Excel for Mac: clean exports without retyping them

Exports from core systems rarely arrive in a shape you can audit. Power Query helps. On Mac, go to Data > Get Data (Power Query), then pick a source. Each cleaning step you apply is recorded in the query. When a new export lands, refresh the query instead of pasting and fixing again. The steps stay in one place, not in someone's memory.

Know the limits before you build anything. Microsoft lists 1,048,576 as the maximum number of rows that Power Query fills to a worksheet. When the engine cannot stream the data, for example when it sorts before loading, it is limited to available virtual memory on 64-bit Excel. On 32-bit Excel, the limit is about 1GB. A large export can fail halfway through. Filter the export at the source before you load it.

Community answers say Power Query on Mac has limits compared with Windows. They do not list the gaps. Check the Mac feature you need before you promise a team that a workflow will run on every Mac. A test with a real export from your own system tells you more than any list.

Worked example: a quarterly policy attestation tracker

Here is a workflow that uses the tools above. Start with four columns: Policy, Owner, Due date and Status. Select the Status cells, go to Data > Data Validation, and set Allow to List. Type the approved values, such as Not started, In progress and Attested, separated by commas. Now nobody can invent a fifth status.

Next, add a formula that counts the rows not marked Attested. Use Formulas > Error Checking to confirm the formula covers the full range. When a manager asks who marked a policy Attested, open Review > Show Changes and read the entries for that cell. Save a dated copy before the review, so the record of the quarter survives any later edit.

Ask Lazur where a tool lives while you do this. Hold ⌥ ⌘ and ask where Data Validation is. Lazur circles the menu and labels it. Then ask it to guide you through the list setup one click at a time.

Use Data Validation and protection to stop typing errors

A register fails when one row says Pending and the next says pending with a trailing space. Data Validation stops that. Select the status column, then go to Data > Data Validation. Set Allow to List, then type the allowed values. The dropdown now shows only the approved choices.

Validation has a gap. Pasting over a cell can replace the rule. Lock the sheet with Review > Protect Sheet, then leave only the input cells open. Protection does not stop a determined editor. It does stop accidental overwrites in a shared file, and that covers most of the everyday risk.

Dates, text and other traps that break audit filters

Dates typed as text break sorting and filters. Text aligns left in a cell by default, while numbers and real dates align right. If a date sits on the left, check it before you filter. A date that looks right but is stored as text will sort in the wrong order. Fix these early, because a wrong sort can hide an overdue item from a reviewer.

Mistakes compliance officers make in Excel on Mac

• Keeping one master file on a desktop, with no copies and no dates
• Saving over the final version, so the earlier state is gone
• Treating Error Checking as proof that a formula matches policy
• Typing dates as text, which breaks sorting and filters
• Pasting exports in, then fixing numbers by hand without a log
• Hiding rows instead of filtering, so reviewers miss them

Each mistake starts as a shortcut that feels harmless. Fix the file once, then keep the fix. Give every register one owner, one archive folder and one review date in the top rows. That habit costs little and saves a long argument later.

How Lazur helps with Excel on Mac, without clicking for you

Lazur is a voice assistant for the Mac. It lives in the notch. Hold ⌥ ⌘, Option and Command together, and ask about anything on screen. Lazur sees the screen only while you hold the shortcut, and it answers out loud. Ask where something is and Lazur circles it with a label. Ask how to do something and Lazur guides you one click at a time, waiting for each click.

Dictation helps with the notes that come with every review. Hold fn to dictate clean, formatted text at the cursor in any app. Dictation is unlimited on both plans. Lazur keeps a memory of what you asked and did, on your Mac. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models.

Lazur does not click buttons, edit files or operate other apps for you. It is not an add-in for Excel or any other app. Lazur runs on macOS, on Apple silicon and Intel. Windows is planned, not available. For the Excel-specific page, see Excel help for Mac.

Start with the trial, then decide. The trial runs for three days with no credit card, and it starts the first time you open the app. Plan prices and AI action limits are on the pricing page. You can get the app from the download page.

Why compliance teams still run on spreadsheets

Spreadsheets stay because they are flexible and everyone already knows them. A ThoughtSpot survey of 1,001 office workers, run by Sapio Research in October 2022, found that 40% often struggle to make sense of their spreadsheet data. The same release says 92% of business people need to manipulate spreadsheet data before it is understandable.

A vendor poll points the same way. Cygnetise reports that nearly 80% of respondents in a LinkedIn Governance, Risk and Compliance group said Excel does not meet their security expectations. Cygnetise sells signatory software, and the sample size is not stated. Use the poll as a prompt to review your own controls, not as proof of anything.

A simple plan for the next week

You do not need to fix everything at once. Work through this list in order, and stop when the file is safe to share.

1. Open Excel > About Excel and note your version.
2. Turn on Review > Show Changes on your main register, then test one edit.
3. Run Formulas > Error Checking on the file you send most often.
4. Add a Data > Data Validation list to every status column.
5. Save a dated copy in your archive folder before the next review.

If your team also runs bookkeeping, the Excel for bookkeepers on Mac page covers reconciliations and month close. Keep your plan short. Review it after each audit cycle, and cut anything nobody uses.