Category Archives: formulas

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

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

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

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