Tag Archives: eDiscovery

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 CLE, eDiscovery, Excel | Leave a comment

“Very Hidden” Worksheets in Excel – Another eDiscovery Challenge

Posted on August 27, 2018 by excelesquire

Most experienced Excel users know how to find and unhide hidden worksheets in an Excel file. Typically, you can right-click on any tab name and you will see the Unhide option if there are any hidden worksheets. (More about that below) Any attorney … Continue reading →

Posted in CLE, eDiscovery, Native File Review, Practice Management | Tagged eDiscovery, technology competence | 1 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 bombogenesis, eDiscovery, Excel, Punxsutawney Phil, scientific notation, Tide Pods | 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 CLE, document review, Duty of Technology Competence, eDiscovery, Excel, Relativity, Wells Fargo | 2 Comments

Avoiding Inadvertent Productions and Other Excel Blunders: New CLE via Wolters Kluwer/myLawCLE

Posted on October 9, 2017 by excelesquire

Wolters Kluwer/myLawCLE will webcast my exciting new CLE presentation from 2-4 pm on October 16th. I will use real Excel files to explain tricky features of Excel that attorneys must be aware of, such as hidden content, filters, comment boxes, … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Native File Review, Practice Management | Tagged Don't be a statistic, eDiscovery, inadvertent disclosure, inadvertent production, managed document review, Native Excel review | Leave a comment

Digital Detectives Podcast Interview with Excel Esquire’s Ben Kusmin – Spreadsheets as Evidence

Posted on September 20, 2017 by excelesquire

Sharon Nelson and John Simek from the Legal Talk Network’s Digital Detectives podcast recently interviewed Excel Esquire’s Ben Kusmin about the pitfalls (and opportunities) faced by lawyers when handling their clients’ Excel spreadsheets. Among other things, we discussed native review of … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Native File Review, Practice Management | Tagged Duty of Technology Competence, eDiscovery, Excel CLE, legal document review, managed review, Relativity, Wells Fargo | Leave a comment

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 eDiscovery, Excel, New York CLE | Leave a comment

Highlight Every Other Row of a Privilege Log (or other spreadsheet!)

Posted on January 10, 2017 by excelesquire

Happy New Year, readers! Today’s tip is an old favorite, and one that can save you a lot of tedious work. It exploits Excel’s conditional formatting feature to quickly highlight every other row of your privilege log, or any other … Continue reading →

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Practice Management, Privilege Logs | Tagged CLE, conditional formatting, eDiscovery, Excel logic formulas, Excel training, priv log, privilege log | 1 Comment

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 CLE, eDiscovery, Law Practice Management, Litigation support, Microsoft Outlook, paralegal, Privilege Logs, Wizard in medieval times | 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 custom footer, eDiscovery, electronic discovery, Excel CLE, Filtering, Law Practice Management, Litigation support, native file redaction, native file review, paralegal, redactio ad absurdum | 1 Comment