Automating Excel

Welcome to Automating Excel with Python

Lesson 1 - Getting Set Up for Automation

Lesson 2 - Reading Spreadsheets with OpenPyXL

Lesson 3 - Creating a Spreadsheet with OpenPyXL

Lesson 4 - Styling Cells

Lesson 5 - Conditional Formatting

Lesson 6 - Creating Charts with OpenPyXL

Lesson 7 - Chart Types

Lesson 8 - Converting CSV Files to Excel

Lesson 9 - Using Pandas with Excel

Lesson 10 - Automating Excel with XlsxWriter

Buy Course or Explore Memberships

Lesson 9 – Using Pandas with Excel