Tag Archives: paralegal

Hide Your Name When Printing Outlook Emails

Posted on May 20, 2016 by excelesquire

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

Redact Native Excel Files with the Filter Tool

Posted on February 22, 2016 by excelesquire

Sometimes you need to produce only certain rows of a large Excel spreadsheet.  Some lawyers will painstakingly apply redaction stamps to hundreds of pages of tiff images, leaving only the responsive rows visible. This is a terrible waste of time and money, and … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Native File Review, Practice Management | 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

Find Inconsistent Document Tags with Excel

Posted on September 8, 2015 by excelesquire

Scenario:  You’re doing QC on a batch of reviewed documents that needs to be released for production.  One thing you need to check for is whether family members (i.e., emails and their attachments) have been coded consistently.  If an email is tagged … Continue reading →

Posted in CLE, eDiscovery, formulas, Lit Support | Tagged , , , , , , , , , | 1 Comment

Print a Rough Deposition Transcript in Half the Pages

Posted on April 17, 2015 by excelesquire

The court reporter just emailed you the rough transcript of today’s deposition, and you’ve absolutely, positively, got to read it on the train tonight.  The idea of reading it off a tablet makes your head hurt, but printing out that .txt file is … Continue reading →

Posted in Everybody, Lit Support, Practice Management | Tagged , , , , | 2 Comments

Create Automated Hyperlinks to NY Court Records in SCROLL

Posted on November 3, 2014 by excelesquire

If you litigate in the New York courts, then you’re familiar with SCROLL–the court-maintained web site where you can enter a case’s index number and pull up the docket for that case.  Now wouldn’t it be nice if you could … Continue reading →

Posted in eDiscovery, Everybody, formulas, Lit Support, Practice Management | Tagged , , , , | 2 Comments