Excel for paralegals on Mac: trackers, deadlines, and Lazur questions in Microsoft 365

Excel for paralegals on Mac: what the work looks like

Most paralegals do not live in Excel. They reach for it when a case needs a list, a date, or a total. Sources that describe paralegal practice put Excel next to OneNote, Airtable, Outlook, and dedicated litigation software, not in place of them. Excel wins when you sort, filter, and count the same rows again and again.

A practice guide on Substack lists the tabs many paralegals build first. It includes a client information table, a master case dashboard, and a case progress tracker that follows discovery, settlement talks, and trial prep. It also includes a deadlines and milestones sheet, where conditional formatting highlights dates that are close.

Billing is the other big use. A billing tracker can carry discount or markup adjustments and expense columns. A start and stop time tracker can total hours with formulas. A settlement calculator can work out fees, court costs, and medical liens. Pivot tables show workload and billable hours by person or matter.

Set up a case tracker that stays clean

A clean tracker starts with one rule. One matter per row, one fact per column. Client name, matter number, responsible paralegal, practice area, opened date, and status cover most trackers. Keep each column to one kind of data. Mixed columns break sorting and filtering.

1. Type every date as a real date. A real date sits on the right side of its cell. A text date sits on the left.
2. Leave no merged cells in the data area. Merged cells block sorting and filtering.
3. Select the range and press ⌘ T to turn it into a table.
4. Name the table when you create it. Microsoft's October 2026 notes say that now works on Mac too.
5. Turn on the filter arrows with ⌘ ⇧ F if they are off.

The table tool matters more than it looks. A table keeps formulas pointed at the right rows as you add matters. It also puts a filter arrow on every column, so you can pull up one practice area in a second.

Names matter for formulas too. A formula that reads Matters[Status] is easier to check than one that reads Sheet1!F2:F400. When you come back to the file months later, the name tells you what the formula does.

Chronologies from discovery documents in Excel

A chronology turns a pile of discovery into a timeline you can sort. Parseur's guide to case chronologies suggests a set of columns for a chronology built from discovery documents. The core columns are below.

The full list also has recipient and a one-line summary. Keep the summary short. One sentence is enough for a timeline row. Long summaries are hard to scan when you filter.

Parseur describes the common failure. Manual chronology work means going back to fix dates, remove duplicate entries, and add missing Bates numbers. Descriptions drift from row to row. One paralegal in its example worked through a 14,000-page set by hand.

Excel helps with the sorting and the filtering. It does not decide what belongs in the chronology. Parseur says the same thing. Macros can cut repeated table work, but a macro cannot judge relevance.

Scans need a closer look. Poor-quality scans can still need human review. Handwritten exhibits belong in a review pile, not a quick entry. On Mac, ⌘ F finds text, but it only works on searchable documents.

Deadline formulas that count court days

Deadlines are where a small error costs the most. Do not type a due date by hand when a formula can work it out. NALA's tips for legal work point to electronic date calculators that count or exclude weekends and court holidays. Excel can do the same job with a few date functions and a holiday list.

In these examples, B2 holds the start date and N2 holds the number of days or months. Holidays is a named range. Build it on its own sheet with one date per row. Select the list, click the Name Box at the top left, type Holidays, and press Return.

Here is a worked example. Say service happens on a Friday, and the rule gives you a set number of business days to respond. Put the Friday in B2 and the count in N2. WORKDAY returns the due date, skipping weekends and anything on the Holidays list. Wrap it in IF so a blank row stays blank: =IF(B2="","",WORKDAY(B2,N2,Holidays)).

Write the rule in a notes column next to each deadline. The next person can then check the math without guessing what you meant. Excel does not know whether your court counts calendar days or court days.

Conditional formatting for deadlines that are close

Conditional formatting turns a date column into a warning light. It fills a cell when the date falls inside a window you choose. The practice guide uses it on deadline sheets. Here is the setup on Mac.

1. Select the due date column, starting at the first data row.
2. Go to Home > Conditional Formatting > New Rule.
3. Choose Use a formula to determine which cells to format.
4. Enter a formula that compares the date with TODAY(). Point the window at one threshold cell so you can change it later.
5. Pick a fill color and click OK. To fix a rule later, go to Home > Conditional Formatting > Manage Rules.

Conditional formatting does not send reminders. The practice guide says reminders depend on Outlook or Power Automate. Keep the highlight in Excel, and keep the alert in the calendar tool you already check.

A common mistake is a rule that uses a plain cell reference where it needs a locked one. The rule then shifts as it copies down the column. Test the rule on a few rows before you apply it to the whole column.

Billing trackers and time totals in Excel

A billing tracker is a simple table with a hard rule. Every line needs a date, a matter, a task, hours, a rate, and an amount. Amount is hours times rate. Put that formula in the table once, and Excel fills it down each new row.

Hours cause the most trouble. Type hours as decimals, not as clock times. A clock-style entry turns into a time value, and the total comes out wrong. Check one row by hand before you trust the column.

Bill4Time, a time-tracking vendor, cites a survey saying attorneys average 3.1 hours a month on timesheets. The survey covers attorneys, not paralegals, and the year is not stated. Treat it as a rough signal, not a benchmark.

For totals by matter, use SUMIFS on the table. A pivot table works too. Insert > PivotTable is the quickest way to see billable hours by matter. Our step by step pivot table guide for Microsoft 365 on Mac walks through it.

A settlement calculator follows the same pattern. Keep each fee, cost, and lien on its own row. Then total the rows with SUM. Retyping numbers into a total cell is how mistakes creep in.

Mac limits to know before you build a shared workbook

Many Excel features match across Mac and Windows. A few do not. Check these limits before you plan a shared template or a data pull.

• Power Query on Excel for Mac needs Microsoft 365 build 16.69 or later. Find Get Data (Power Query) on the Data tab.
• Authoring in the Power Query Editor is not available in Excel for Mac. VBA can author Power Query, or you can build the query on Windows.
• Mac import sources include Excel workbooks, Text or CSV, XML, JSON, SharePoint Online lists, OData, blank tables, and blank queries. SQL Server import is in Insiders Beta only.
• The Copilot clean-data skill is generally available on all platforms. Run it with @clean-data or from the Skills menu. The skill recorder is Insider-only on Mac.
• This page could not confirm Power Pivot status on Mac. Check Microsoft's support pages before you plan a data model.

Templates work differently too. On Mac, the template folder is set in Word. Go to Word > Preferences > File Locations and set User templates, because Word and Excel share that folder. Templates in the Personal templates folder appear under the Personal tab when you choose New from Template.

Where Lazur fits in your Excel work

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. That covers the cell you are stuck on, the menu you cannot find, or the formula you did not write.

Ask where something is, and Lazur draws a circle and a label around it on your screen. Ask how to do something, and Lazur guides you one click at a time. It waits for each click. You stay in control of every change.

Hold fn to dictate. Dictation writes clean text at the cursor in any app. Snippets, a personal dictionary, and clipboard slots help with repeated work. Save your standard chronology entry as a snippet, then dictate only the facts.

Lazur does not click buttons, edit files, or operate other apps for you. It is not a plugin or add-in for Excel or any other app. Lazur runs on macOS, and Windows is planned, not available. Lazur has no partnership with any app maker.

Privacy matters more in a law office than in most offices. 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, and content is never used to train AI models. Client files are still privileged, so check your firm's policy first.

Mistakes paralegals make in Excel, and how to fix them

• Dates typed as text. Fix it by retyping the first date and filling down. A real date sorts, and text does not.
• Merged cells in the data area. Fix them by unmerging and keeping one value per cell.
• Duplicate chronology rows when two people add entries. Fix it with one owner per tracker and a filter on Bates number before each update.
• Hand-typed due dates. Fix them with formulas tied to the Holidays list, plus a notes column that states the rule.
• Macros that delete rows you still need. Test each macro on a copy, and keep the original file.
• Searching scans with ⌘ F. Find only works on searchable text, so review image-only scans by eye.

Parseur notes that search helps with names in searchable documents. It does not replace review. A tracker shows what you logged. It does not show what you missed.

A weekly routine for the tracker

1. Filter the deadlines column for dates within the next week.
2. Check the Holidays list against the court calendar.
3. Clear or change any highlighted rows you have handled.
4. Add new documents to the chronology, then sort by document date.
5. Save a dated copy before any large change.

Keep the routine on the same day each week. A fixed day turns the check into a habit. A routine catches the rows nobody looked at.

If you are starting from zero, begin with the case tracker and the deadline sheet. Add billing when those two hold up. Add the chronology when the next discovery set arrives. For the wider set of tools, see AI tools for paralegals on Mac.

To see how Lazur works with Excel in practice, read the Excel help page. When you are ready to try it, download Lazur for Mac and check plans and the free trial.