Category Archives: Everybody

Create a Signed pdf/a Without Scanning the Entire Document

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

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

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

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)

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

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

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