Tag Archives: Excel Formulas

“Excel Essentials for Busy Lawyers” Approved for New York CLE Credit!

Posted on November 2, 2015 by excelesquire

Excel Esquire’s signature course has been re-approved for New York CLE credit for 2019!  Excel Essentials for Busy Lawyers is a 2-hour workshop for beginner and intermediate Excel users, and covers the basics of filtering, sorting, and analyzing data, as well as performing … Continue reading →

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

Generate Properly-formatted Bates Numbers in a Snap

Posted on September 23, 2015 by excelesquire

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 , , , | 4 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