Using Python with Excel

Take your Microsoft Excel skills to the next level using Python, one of the world’s most popular object-oriented programming languages.

Introduction

• Managing Excel with Python

1. Python and pandas

• Jupyter Notebooks basics
• Introducing the Python pandas library
• Loading and saving data with pandas
• Viewing and inspecting data with pandas
• Manipulating data with pandas
• Working with dates and times in pandas

2. openpyxl

• Using openpyxl with Workbooks
• Selecting cells, rows, and columns
• Adding workbook formatting
• Creating names, ranges, and tables

3. Working with Reports

• Managing multiple sheets
• Working with large worksheets
• Conditional formatting
• Creating Excel plots in Python
• Exporting Python plots to Excel

Conclusion

• Next steps