Tag Archives: eDiscovery

“Very Hidden” Worksheets in Excel – Another eDiscovery Challenge

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

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

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

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

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

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

Nassau County Bar Association CLE Event – March 8

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

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

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 , , , , , , | 1 Comment