Category Archives: Privilege Logs

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

Posted on January 10, 2017 by excelesquire

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

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

Posted on February 10, 2016 by excelesquire

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

Tracking Duplicates with MATCH, INDEX, and COUNTIF

Posted on June 14, 2015 by excelesquire

Today’s post is about a powerful Excel formula for tracking duplicates in a large set of email metadata.  This routine is not for the faint of heart, but if you are managing a document production, supervising a redaction project, or creating … Continue reading →

Posted in eDiscovery, formulas, Lit Support, Privilege Logs | Tagged , , , , , , | 2 Comments

April CLE Courses Now Enrolling in NYC!

Posted on March 10, 2015 by excelesquire

Tools of the Trade: Excel Skills Every Litigator Should Know carries 3.0 New York CLE credits, and April classes are now enrolling in New York City. The first CLE course of its kind, Tools of the Trade takes you step by … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Practice Management, Privilege Logs | Tagged , , , , , , , , , , , | Leave a comment

Sort Email Metadata Without Losing the Attachments

Posted on January 29, 2015 by excelesquire

This routine is a big favorite in my New York Excel CLE course Tools of the Trade: Excel Skills Every Litigator Should Know. Click here for more information about the course. Scenario: You have a set of email metadata corresponding to a … Continue reading →

Posted in eDiscovery, formulas, Lit Support, Privilege Logs | Tagged , , , | 2 Comments

Excel Esquire CLE Courses Now Enrolling in NYC!

Posted on November 25, 2014 by excelesquire

Tools of the Trade: Excel Skills Every Litigator Should Know is now approved for 3.0 New York CLE credits, and December classes are now enrolling in New York City. The first CLE course of its kind, Tools of the Trade takes you … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Practice Management, Privilege Logs | Tagged , , , , , , , , , , , | Leave a comment

Turbocharge Your Clipboard to Copy & Paste Multiple Items

Posted on October 26, 2014 by excelesquire

Ever wish Excel could remember the last 10 things you copied to the clipboard, and would let you paste any of them?  In fact, you can get it to remember the last 24, when you activate the Office Clipboard. Suppose … Continue reading →

Posted in eDiscovery, Everybody, Privilege Logs | Leave a comment

Use Excel to Count the Number of Emails in Each Email Chain

Posted on October 17, 2014 by excelesquire

Courts and litigants have long struggled with the question of how to describe email chains on a privilege log.  Should you log only the most recent email, or log every email in the chain–or something in between?  New York has … Continue reading →

Posted in eDiscovery, formulas, Lit Support, Privilege Logs | Tagged , | 7 Comments

Filter at Warp Speed with Filter by Selection

Posted on October 4, 2014 by excelesquire

Suppose you’re scrolling through some data and you come across an interesting value. You’d like to know if there are more values like the current one.   It might be a name on a privilege log, the name of a creditor, a … Continue reading →

Posted in eDiscovery, Native File Review, Privilege Logs | Leave a comment