Modern Excel for Professional Services: 5 Functions Changing How We Work
Excel underpins daily operations in legal firms.
It supports billing analysis, WIP reviews, forecasting and partner reporting. Yet many teams still rely on legacy formulas and manual fixes that introduce risk.
Excel has moved on. Modern functions deliver stronger accuracy, clearer structure and better auditability. When used well, they improve control and confidence.
This series explores five functions that are reshaping how legal teams manage data. Each episode explains what the function does, why it matters and how it applies in practice.
Next, we turn to FILTER — and why legal teams should stop copying and pasting data every reporting cycle
In many law firms, reporting still involves a familiar routine:
- Filter
- Copy
- Paste into a new sheet
- Repeat next week
Whether reviewing WIP, overdue debt, matter lists, or fee earner performance, manual filtering creates multiple versions of the same data – and increases the risk of error.
There is a better way.
The FILTER function allows you to create dynamic views of your data that update automatically when the source data changes.
For example:
This instantly returns only the rows where invoices are marked as overdue.
- No copying
- No separate “report” sheet
- No risk of forgetting to refresh
Why this matters for legal teams:
✔ Reduces manual intervention in financial reporting
✔ Prevents version control issues
✔ Supports cleaner partner dashboards
✔ Improves confidence during month-end and billing cycles
Practical applications in a legal setting:
- Open matters only
- WIP above a certain threshold
- Time entries by department
- Overdue invoices by client
- Matters by responsible partner
Each result in the array corresponds to a value in
In the example shown above, the formula in F5 is:
Since the value in G2 is “Green”, the FILTER function extracts data from the array when the Team column equals “Green”. All matching records are returned to the worksheet starting from cell F5, where the formula resides.
At Baskerville Drummond LLP, we often see how small improvements in spreadsheet practice can significantly enhance financial control, operational efficiency, and reporting confidence. For Excel training please get in touch with Baskerville Drummond LLP.
Next episode: LET – The Most Underrated Excel Function.
More in this series
Episode 5: TEXTSPLIT – Quick Data Cleanup
Modern Excel for Professional Services: 5 Functions Changing How We Work Excel underpins daily operations in legal firms. It supports billing analysis, WIP reviews, forecasting and partner reporting. Yet many teams still rely on legacy formulas and manual fixes that...
Episode 4: LAMBDA – Build your own Excel functions
Modern Excel for Professional Services: 5 Functions Changing How We Work Excel underpins daily operations in legal firms. It supports billing analysis, WIP reviews, forecasting and partner reporting. Yet many teams still rely on legacy formulas and manual fixes that...
Episode 3: LET – Cleaner Formulas, Faster Sheets
Modern Excel for Professional Services: 5 Functions Changing How We Work Excel underpins daily operations in legal firms. It supports billing analysis, WIP reviews, forecasting and partner reporting. Yet many teams still rely on legacy formulas and manual fixes that...
Episode 1: XLOOKUP – Why VLOOKUP is officially retired
Modern Excel for Professional Services: 5 Functions Changing How We Work Excel underpins daily operations in legal firms. It supports billing analysis, WIP reviews, forecasting and partner reporting. Yet many teams still rely on legacy formulas and manual fixes that...
Martin Batt
07854 740 686
Latest Articles
Microsoft 365 companion apps are being retired: what are they and what do you need to do?
Microsoft is retiring its Microsoft 365 companion apps Calendar, People and Files; in December 2026. The apps will no longer work from 16 December 2026. You may lose them earlier if your IT team or Managed Service Provider (MSP) removes them ahead of Microsoft's...
Can I use Copilot – A simple guide
I often get asked “Can I use Copilot?” The following is my take on this. (Please note that if you have any questions or concerns – drop me a message/email, also check with your internal compliance team.) Can I Use Microsoft Copilot at Work? Imagine this. You're about...
Legal Tech and the Art of Invisibility
Why the future of legal technology is a world where we stop talking about legal technology. For decades, we've been building legal technology. We've digitised documents, automated precedents, moved practice management to hosted products in the cloud, introduced...
Talk to us today
Get In Touch
