-
-
Recent Posts
- Microsoft Excel for Lawyers on PLI 1/10/23
- Create a Signed pdf/a Without Scanning the Entire Document
- Amazing 3D Map Charts in Excel 2016
- September Event with PLTG – New Charts in Excel 2016
- “Very Hidden” Worksheets in Excel – Another eDiscovery Challenge
- Upcoming CLE Event for Chicago Bar Association – Advanced Excel for Litigators
- Pseudo-Scientific Notation, or The Mysterious Case of the Middle E
- Finding and Reviewing Comment Boxes in Excel Files
- Avoiding Inadvertent Productions and Other Excel Blunders: New CLE via Wolters Kluwer/myLawCLE
- Digital Detectives Podcast Interview with Excel Esquire’s Ben Kusmin – Spreadsheets as Evidence
- Scared Straight? Reviewing Excel Files in the Wake of Wells Fargo
- Excel Filters and the Duty of Technology Competence
- Upcoming CLE Event in Houston, TX (with livestream)
- Spelling Bee Fundraiser for Harlem Hospital CCHP
- Nassau County Bar Association CLE Event – March 8
Categories
Category Archives: Uncategorized
Analyze Matter Data with Pivot Tables
In this post I’ll explain how to use one of the most powerful data analysis tools in Excel – the Pivot Table. My example involves a list of new pro bono matters, but pivot tables are also an effective way … Continue reading
Posted in Uncategorized
2 Comments
Reverse Names with Find & Replace
In a recent post I explained how to count the number of pages in a list of Bates ranges. Today I’ll discuss a common text formatting issue. Suppose you have a long list of names of the form “Cook, Mary” … Continue reading
Excel Esquire 