-
-
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
Tag Archives: metadata
Open and Analyze a Production Metadata File (dat file) in Excel
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 eDiscovery analytics, Excel, Litigation support, metadata
|
1 Comment
“Excel Essentials for Busy Lawyers” Approved for New York CLE Credit!
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 →
Find Inconsistent Document Tags with Excel
Scenario: You’re doing QC on a batch of reviewed documents that needs to be released for production. One thing you need to check for is whether family members (i.e., emails and their attachments) have been coded consistently. If an email is tagged … Continue reading →
Tracking Duplicates with MATCH, INDEX, and COUNTIF
Today’s post is about a powerful Excel formula for tracking duplicates in a large set of email metadata. This routine is not for the faint of heart, but if you are managing a document production, supervising a redaction project, or creating … Continue reading →
Posted in eDiscovery, formulas, Lit Support, Privilege Logs
|
Tagged eDiscovery, eDiscovery analytics, electronic discovery, Formulas, Litigation support, metadata, VLOOKUP
|
2 Comments
April CLE Courses Now Enrolling in NYC!
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 →
Sort Email Metadata Without Losing the Attachments
This routine is a big favorite in my New York Excel CLE course Tools of the Trade: Excel Skills Every Litigator Should Know. Click here for more information about the course. Scenario: You have a set of email metadata corresponding to a … Continue reading →
Posted in eDiscovery, formulas, Lit Support, Privilege Logs
|
Tagged eDiscovery, Litigation support, metadata, Privilege Logs
|
2 Comments
Excel Esquire CLE Courses Now Enrolling in NYC!
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 →
Excel Esquire 