Category 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 , , | Leave a comment

Create a Signed pdf/a Without Scanning the Entire Document

Posted on March 12, 2019 by excelesquire

Today, a quick non-Excel tip that may help preserve your sanity when it comes time to e-file a large brief.  Here in New York, and in other jurisdictions as well, briefs must be filed in pdf/a format. Among other things, this ensures that the document … Continue reading →

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

September Event with PLTG – New Charts in Excel 2016

Posted on August 31, 2018 by excelesquire

Professional Legal Trainers Group (PLTG) is a group of (mostly) New York law firm software trainers, which meets regularly to exchange ideas about supporting the legal training community.  They’ve invited me to their September 14th event called Effective Data Visualization: … Continue reading →

Posted in eDiscovery, Everybody, law firm training, Lit Support, Practice Management, trial graphics | 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 , | 1 Comment

Upcoming CLE Event for Chicago Bar Association – Advanced Excel for Litigators

Posted on March 23, 2018 by excelesquire

The CBA is hosting an exciting new Excel Esquire program called Advanced Excel for Litigators at the historic Chicago Bar Association Building from 12-3 pm on April 20th.  This will be a small, interactive program with plenty of opportunity for … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Native File Review, Practice Management | Tagged , , , , | Leave a 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

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

Scared Straight? Reviewing Excel Files in the Wake of Wells Fargo

Posted on August 21, 2017 by excelesquire

The Wells Fargo inadvertent disclosure episode provides a high-profile reminder that attorneys who are responsible for reviewing and producing client documents must thoroughly understand those documents.  There were several process breakdowns that led to the inadvertent disclosure of thousands of confidential records, … Continue reading →

Posted in CLE, eDiscovery, formulas, Lit Support, Native File Review, Practice Management | 5 Comments

Excel Filters and the Duty of Technology Competence

Posted on July 25, 2017 by excelesquire

The Harris County Law Library in Houston, Texas recently hosted my presentation “Excel Essentials for the Practice of Law.”  Among other topics, I explained how filters work in Excel, and how they present pitfalls for the unwary lawyer.  When lawyers … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Native File Review, Practice Management | Leave a comment