Teaching analytics with modern Excel
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 →
pandas, openpyxl and Power QueryIn an earlier post I provided an overview of how to use the pandas and openpyxl packages together to automate the production of Excel workbooks. In that post, I likened pandas as the "Power Query of …
Continue Reading about How to understand the relationship between pandas, openpyxl and Power Query →
I had a great discussion with host Paul Barnhurst along with fellow guests and Excel MVPs Mark Proctor and Celia Alves on why and how finance and FP&A can be more effective and efficient in …
Continue Reading about How to improve your Excel skills (FP&A Today podcast) →
