Category Archives: Everybody

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

Reverse Names Easily with Find & Replace

Posted on May 21, 2015 by excelesquire

A student in one of my CLE programs recently asked me the following question:  What do you do when you have a long list of names of the form “Cook, Mary” and you want to put them in the form “Mary … Continue reading →

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

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

A Brief Aside on the Use of Hyphens

Posted on December 16, 2014 by excelesquire

The sun doesn’t rise and set on spreadsheets; we’ve got briefs to write, too!  Here is a rule that I see broken frequently: Use a hyphen to create two-word adjectives, but not when the two words are used as a … Continue reading →

Posted in Everybody | Tagged , , | 1 Comment

Find & Redact Social Security Numbers in Excel Files

Posted on November 10, 2014 by excelesquire

A raft of state and federal laws require the redaction of social security numbers from publicly available documents.  For attorneys, this usually means that documents produced in litigation must be scrubbed of SSN’s.   In my experience, many parties resort to … Continue reading →

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Native File Review | Tagged , , , , , , , | Leave a comment

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

Pain-Free Way to Add Up Billable Hours

Posted on October 27, 2014 by excelesquire

Juggling multiple matters means adding up many time increments to come up with the correct number of billable hours for each matter, each day.  Here’s an easy way to add up all the time on a given matter automatically. Set … Continue reading →

Posted in Everybody, formulas, Practice Management | Tagged , | 3 Comments

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

5 Killer Formatting Tricks

Posted on October 14, 2014 by excelesquire

1.  Scroll-free Fonts Scrolling through all the available fonts to find the one you want can be a pain.  If you know the name of it, you can simply click into the box containing the active font and begin typing the name … Continue reading →

Posted in eDiscovery, Everybody, formulas | Tagged , , , | Leave a comment

Get Excel to List the Files in a Folder

Posted on October 10, 2014 by excelesquire

There is a particular folder on my hard drive with several dozen files in it. I wish I had a list of those files so that I could email them, or create an exhibit list, etc. The following routine will … Continue reading →

Posted in eDiscovery, Everybody | 7 Comments