Analytics & AI for Modern Excel
As a long-time Python enthusiast who has frequently recommended Excel users delve into Python (and even authored a book on the subject), a prevalent question I encountered from hesitant Excel users …
Continue Reading about Here are some quick wins for using Python in Excel →
Look what touched down in my mailbox today... 🏈 _Football Analytics with Python & R_ by Eric Eager and Richard Erickson. I had the pleasure to be a tech reviewer for this book …
Continue Reading about Review: Football Analytics with Python & R →
I’m excited to share that “pandas Analytics for Excel users,” a course I produced with Madecraft, is now available on LinkedIn Learning. View the course with a one-month free trial …
Continue Reading about Using Python with Excel (LinkedIn Learning & Madecraft) →
I'm excited to share that "pandas Analytics for Excel users," a course I produced with Madecraft, is now available on LinkedIn Learning. Also be sure to check your local library, …
Continue Reading about Pandas analytics for Excel users (LinkedIn Learning & Madecraft) →
openpyxlExcel's popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for …
Continue Reading about How to format a column as percentage in Excel using openpyxl →
openpyxlExcel's popularity stems from its user-friendly data formatting and presentation capabilities. Take, for example, the nuisance of narrow columns. Resolving this issue in Excel is as simple as …
Continue Reading about How to automatically adjust Excel column widths in openpyxl →