Attorney at Work Today

Here’s how legal teams can use Microsoft 365 Copilot to build interactive law firm dashboards that help find the story inside lists, spreadsheets and document libraries.

This episode of Attorney at Work Today is brought to you by Answering Legal.


Adapted from an article by Ben Schorr.

Click here to read the full article. Head to Attorney at Work for more really good ideas.

What is Attorney at Work Today?

At Attorney at Work, our goal is to give you the information and inspiration you need to create a law practice and a life you love. With Attorney at Work Today, we're helping you experience the best of our content in a whole new way. Whether you're a lover of podcasts, learn best by listening, or just want to better your practice even in those moments when stopping to read an article isn't practicable, Attorney at Work Today is your premier pathway to the content that brings you to the next level in your career.

When I was in business school, when dinosaurs still roamed the earth, the principal problem we talked about was how to get more data and how to turn that data into information. Today, we have the opposite problem. We’re drowning in data, and it’s a constant battle to whittle down the information racing at us to just the actionable stuff.

A SharePoint list might track new client intake requests, litigation deadlines, equipment assignments, training attendance or marketing opportunities. A SharePoint document library might hold monthly AR aging reports, billing exports or operations spreadsheets. Those sources are useful, but only if someone has the time and skill to turn them into charts, filters, summaries and trends.

That is where Copilot in SharePoint is starting to get more interesting. With a Microsoft 365 Copilot license, Copilot can help you work with content already stored in SharePoint, including lists, libraries and files, and use natural language to create interactive reports and dashboards.

When we talk about SharePoint data for dashboards, we are usually talking about one of two things. Th first is SharePoint Lists.

A SharePoint list is structured data that lives directly in SharePoint. Think of it like a lightweight database or spreadsheet. Each row is an item, and each column captures a specific field, such as client name, matter number, deadline, amount or practice area. Lists are often used for intake tracking, task tracking, asset management and workflow queues.

The other is files Stored in a SharePoint library

A document library is where firms commonly store Excel workbooks, Word documents, PDFs and other files. For dashboards, Excel files are especially important. Many firms already generate monthly reports from accounting, billing, practice management, or case management systems and save them to SharePoint. Copilot can help summarize and visualize what is in those files without requiring someone to manually copy the data into a separate dashboard tool first.

But why does this matter for Law Firms?

Dashboards are not just pretty charts. A good dashboard answers practical management questions quickly.

Which clients have outstanding receivables over 90 days?

Which practice groups are opening the most new matters?

Which trainings have been completed, and who still needs to attend?

Historically, answering those questions often meant exporting data, cleaning it up, building formulas, creating pivot tables, formatting charts — and then doing it all again next month. Copilot doesn’t eliminate the need to understand your data, but it can significantly reduce the friction between “we have the information somewhere” and “we can see what is happening.”

Let’s consider some examples. The first example is a dashboard from a sharepoint list. Imagine your firm uses a SharePoint list to track new client intake. The list includes the prospective client name, practice area, referral source, intake date, assigned attorney, conflict-check status, and current stage. Instead of manually building a report, you could ask Copilot something like:

Create an interactive dashboard from this intake list. Include total new intakes by month, intakes by practice area, referral sources, average days from intake to conflict check, and a table of items still waiting for review. Add filters for practice area, responsible attorney, and intake stage.

This kind of dashboard can help a managing partner see whether intake volume is increasing, which practice areas are growing, where referrals are coming from, and whether opportunities are getting stuck in the process.

The same pattern works for many SharePoint lists: contract review queues, CLE attendance, equipment inventory, policy acknowledgments or pro bono matters. The key is to be specific about the business questions you want answered.

Now let’s look at a different example; one where a dashboard is built from excel files in a sharepoint library. Imagine your accounting team saves monthly accounts receivable aging reports as Excel workbooks in a SharePoint document library. January.xlsx, February.xlsx, March.xlsx and so on. Each workbook includes client, matter, responsible attorney, total balance, and aging buckets such as current, 30 days, 60 days, 90 days and 120-plus days.

You might ask Copilot:

Create an interactive dashboard based on the Excel files in this folder. Show total receivables by month, receivables over 90 days, top 10 clients by outstanding balance, and balances by responsible attorney. Include trend lines from January through July and add filters for attorney and aging category. Include a short executive summary explaining what changed over time.

For a firm administrator, this is much more useful than opening seven separate spreadsheets and trying to remember which numbers changed. Copilot can help turn a folder full of monthly reports into a clearer management view: what is improving, what is worsening, and where someone should follow up.

Remember, good Dashboards Start With Good Data.

Copilot can help you analyze and present information, but it cannot magically fix every data problem. If your list has unclear column names, inconsistent matter numbers, missing dates, duplicate entries, or 10 different spellings of the same attorney’s name, the dashboard may reflect that confusion.

Before asking Copilot for a dashboard, check the basics:

Use clear column names.

Keep dates in date columns, not typed into notes fields.

Use consistent names for attorneys, clients, departments and practice groups.

Make sure the people who will use the dashboard have permission to see the underlying data.

This is especially important in law firms because dashboards can easily expose sensitive client, matter, financial or personnel information. Copilot respects Microsoft 365 permissions, but that does not mean every dashboard should be broadly shared. If the dashboard is based on data only the finance team should see, keep it in a location with properly limited access.

Interactive dashboards used to require someone with reporting experience, enough Excel skill to survive pivot tables, or access to a more formal business intelligence tool. Those tools still matter, especially for complex reporting. But for many everyday management questions, Copilot in SharePoint may offer a faster path from stored information to useful insight.