Tag Archives: CLE

Upcoming CLE Event for Chicago Bar Association – Advanced Excel for Litigators

The CBA is hosting an exciting new Excel Esquire program called Advanced Excel for Litigators at the historic Chicago Bar Association Building from 12-3 pm on April 20th.  This will be a small, interactive program with plenty of opportunity for … Continue reading

Posted in CLE, eDiscovery, Lit Support, Native File Review, Practice Management | Tagged , , , , | Leave a comment

Finding and Reviewing Comment Boxes in Excel Files

Following the Wells Fargo inadvertent disclosure episode, I wrote a blog post describing several ways to find hidden content in Excel files.  In this post I discuss another feature of Excel that all lawyers, but especially legal document reviewers, should know about: the comment box. … Continue reading

Posted in CLE, eDiscovery, Lit Support, Native File Review | Tagged , , , , , , | 2 Comments

Highlight Every Other Row of a Privilege Log (or other spreadsheet!)

Happy New Year, readers! Today’s tip is an old favorite, and one that can save you a lot of tedious work.   It exploits Excel’s conditional formatting feature to quickly highlight every other row of your privilege log, or any other … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Practice Management, Privilege Logs | Tagged , , , , , , | 1 Comment

Hide Your Name When Printing Outlook Emails

When you print an Outlook email–whether your own or someone else’s–your own name appears by default in large text at the top of the printout. This is awkward if you are printing emails as a delegate, or are using them as … Continue reading

Posted in CLE, Everybody, Lit Support, Practice Management | Tagged , , , , , , , | 5 Comments

Get Excel to Automatically Launch Documents from an Exhibit List, Privilege Log, or Hot Documents List

Today I’ll explain how to create a schedule of documents or other files in Excel that includes a hyperlink for each document.  Anyone reviewing this list will be able to open any document described on it by just clicking the link.  This makes it … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Privilege Logs | Tagged , , , , , , , | 5 Comments

Generate Properly-formatted Bates Numbers in a Snap

Let’s say you get the following panicked email from an attorney on your team: You understand that these are the Bates numbers for documents on the Big Bank case, but you need to convert them to the proper format in order … Continue reading

Posted in CLE, eDiscovery, formulas, Lit Support | Tagged , , , | 3 Comments