Teaching analytics with modern Excel
Despite claims that AI has made Excel obsolete, the combination of AI and Excel has actually increased the program's power and accessibility for extracting insights and querying data. That said, AI is …
Continue Reading about How to get AI-powered insights in Excel with Analyze Data →
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) →
openpyxlIn a previous post, I discussed Python's role in the modern Excel stack. Another advantage of using Python with Excel is the wealth of data visualization options available. When working with Excel …
Continue Reading about How to visualize data in Excel with openpyxl →