Category Archives: Everybody

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

Amazing 3D Map Charts in Excel 2016

Posted on September 21, 2018 by excelesquire

I recently joined a presentation at a meeting of the Professional Legal Trainers Group in New York City to discuss some of the new chart types in Excel 2016.  The crowd favorite was the new built-in 3D Maps.  While not … Continue reading →

Posted in CLE, Everybody, Practice Management, trial graphics | Leave a comment

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

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

Upcoming CLE Event in Houston, TX (with livestream)

Posted on June 16, 2017 by excelesquire

On July 13th, I will give a presentation called “Excel Essentials for the Practice of Law” at the Harris County Law Library in Houston.  The presentation is designed for lawyers, paralegals, and other legal professionals.  Participants will learn how to … Continue reading →

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Practice Management | 1 Comment

Spelling Bee Fundraiser for Harlem Hospital CCHP

Posted on March 31, 2017 by excelesquire

Hello readers!  Your humble narrator and Excel blogger will compete in a spelling bee fundraiser to benefit the Center for Comprehensive Health Practice, a terrific hospital serving needy residents in Harlem.  They are facing a difficult rent hike and this … Continue reading →

Posted in eDiscovery, Everybody | Tagged , , | 1 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 , , | 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 , , , , , , | 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 , , , , , , , | 5 Comments