Why Excel Is The Most Underappreciated Program In Your Law Office

Do you know all the ways you can use Microsoft Excel to increase your productivity?

Microsoft Excel just does not get the respect that it deserves in law offices. It’s underutilized and underappreciated. It’s not that people don’t need Excel for day-to-day use in a law office, I think the problem is that people just don’t know how to use it very well.

Excel is not just a program for adding up numbers in columns; it’s a program for organizing data and analyzing the relationship between the data. You can use it as a database, contact management software, a billing database, a calendaring program, or a thousand other legal uses. Excel is not going to replace more expensive specialty litigation software, but here are some ways you can use it to increase your productivity:

Calendaring Court Dates

If your deadline to file your motion for summary judgment motion is 70 days before the hearing, how do you calculate it with a hearing date of July 17, 2015, if you also have to add 5 days for mailing? Try this:

In cell A1, type: =7/17/2015

In cell B1, type: 5

In cell C1, type: =A1-70-B1

Want to see if you have calculated a date that falls on a weekend? Do this:

Sponsored

Click the cell C1. Under the dropdown box where it says “Date,” select “Long Date.” If your calculation shows a date on a Saturday or Sunday, move it to the Friday before. If you now see a bunch of # signs, your column is too narrow. Put your cursor between the C and the D and drag the C column out wider.

What about if you want to calculate when the interrogatories you just propounded are due if it’s 30 days from today plus 5 days for out-of-state-mail service? Do this:

In cell A1, type: =today()

In cell B1, type: =A1+30+ 5

Sponsored

Analyzing Voluminous Privilege Logs

What if opposing counsel gives you a PDF version of a privilege log that is several hundred pages — how do you begin to analyze that? You can use Adobe Acrobat to save it as an Excel spreadsheet. Then, highlight all of the data and choose “Format as Table.”

Now that it’s a table, you can filter the data more easily. Say, for example, that you want to focus on just documents from 2006. Click on the little arrow by the Date column:

Uncheck “Select All” and put a check by just 2006. You can do this for other columns also. So, if you are wondering why PowerPoints are attorney-client privileged, filter that column to show just PowerPoints.

One you have reviewed the data you want and find something that jumps out at you, highlight the rows. Use a different color for different issues. Then, filter your table to show just the highlighted rows by clicking on a dropdown arrow and choosing to filter by color:

Power e-discovery tip: most load files are produced in a file format that can be opened in Excel. Save a copy of your load files and open them in Excel. Change the data to a table and get some quick, sortable data about your large productions.

Deeper Analysis With Pivot Tables

Pivot Tables let you prepare statistics about the data in your table. Here, let’s count how many of each file type we have. I highlight my table and select Summarize with Pivot Table under the table tab:

Now, I have a new sheet that has a blank table. I have my options to set up the table on the right and the table itself on the left. To calculate how many of each document type, I am going to drag “Type of Document” down into the Columns area below. Next, I drag it also into Values.

This creates a table where there are column headers for each document type and underneath, there is is a count of each document type. It should look like this:

Here, I see that 4 of the 8 documents are e-mails.

Conclusion

There is so much that you can do in Excel. You can create billable time databases and filter them to show only certain months on an invoice you send to a client. You can do charts and graphs. Spending the time learning how to use the additional features of Excel, or any program, can help you work more efficiently and spend less time doing boring, tedious tasks.

Earlier: The Rage-Inducing Word Versus WordPerfect Debate


Jeff Bennion is a solo practitioner from San Diego. When not handling his own cases, he’s consulting lawyers on how to use technology to not be boring in trial or managing e-discovery projects in mass torts/complex litigation cases. If you want to be disappointed in a lack of posts, you can follow him on Twitter or on Facebook. If you have any ideas of things you want him to cover, email Jeff at jeff@trial.technology.

CRM Banner