Teaching analytics with modern Excel
Just like in biology, where cells are the building blocks of life, in your Excel workbook, cells serve as the foundational elements. In this post, you'll discover how to interact with individual cells …
Continue Reading about How to work with cells, rows and columns in Excel with openpyxl →
Working with Python code becomes significantly more manageable when objects are assigned clear, sensible names, and Excel is no different. This blog post covers how to create named ranges and tables …
Continue Reading about How to create named ranges and tables in Excel with openpyxl →
openpyxlSeveral packages facilitate working with Python and Excel, but openpyxl stands out as an excellent choice due to its comprehensive features for reading and writing workbooks. In this blog post, we …
Continue Reading about How to create and modify Excel workbooks with openpyxl →
openpyxl and xlsxwriter Python packages for ExcelExcel spreadsheets continue to be the primary tool for data management and analysis in the business world. Consequently, several Python packages have been developed to automate and enhance Excel's …
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) →
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 →