Tag Archives: Excel

Microsoft Excel for Lawyers on PLI 1/10/23

Posted on January 6, 2023 by excelesquire

On January 10, 2023 at 1 pm EST I’ll be presenting a One-Hour Briefing on the PLI platform called Microsoft Excel for Lawyers. This online program includes CLE credit in many jurisdictions, and may be available free of charge if … Continue reading →

Posted in CLE, eDiscovery, Everybody, law firm training, Native File Review | Tagged , , | Leave a comment

Pseudo-Scientific Notation, or The Mysterious Case of the Middle E

Posted on February 5, 2018 by excelesquire

Typing a part number like 32E50 into an Excel spreadsheet can give you fits.  Excel thinks you are using shorthand for scientific notation, and converts this string into the number 3.20E+51 (or 32 with 50 zeroes) – Ugh!  The way to overcome … Continue reading →

Posted in Everybody, formulas, Lit Support | Tagged , , , , , | 1 Comment

Finding and Reviewing Comment Boxes in Excel Files

Posted on January 25, 2018 by excelesquire

Following the Wells Fargo inadvertent disclosure episode, I wrote a blog post describing several ways to find hidden content in Excel files.  In this post I discuss another feature of Excel that all lawyers, but especially legal document reviewers, should know about: the comment box. … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Native File Review | Tagged , , , , , , | 2 Comments

Nassau County Bar Association CLE Event – March 8

Posted on March 2, 2017 by excelesquire

The Nassau Academy of Law, the educational arm of the NCBA, will host an Excel Esquire CLE lunch program called “Excel Essentials for the Practice of Law” on Wednesday, March 8.  Lunch is served at 12:30, and the one-hour program … Continue reading →

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

Open and Analyze a Production Metadata File (dat file) in Excel

Posted on September 26, 2016 by excelesquire

Does this scenario sound familiar?  Your adversary drops a production on you in the form of a large zip file, and you need to know what’s in that production NOW. For example, you might have a motion to compel hearing later that day–are these … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Practice Management | Tagged , , , | 1 Comment

“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

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

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

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