Automating Excel

Welcome to Automating Excel with Python

Lesson 1 - Getting Set Up for Automation

Lesson 2 - Reading Spreadsheets with OpenPyXL

Quiz 2 - Reading Spreadsheets

Lesson 3 - Creating a Spreadsheet with OpenPyXL

Quiz 3 - Creating Spreadsheets

Lesson 4 - Styling Cells

Quiz 4 - Styling Cells

Lesson 5 - Conditional Formatting

Quiz 5 - Conditional Formatting

Lesson 6 - Creating Charts with OpenPyXL

Quiz 6 - Creating Charts

Lesson 7 - Chart Types

Quiz 7 - Chart Types

Lesson 8 - Converting CSV Files to Excel

Quiz 8 - Converting CSV Files

Lesson 9 - Using Pandas with Excel

Quiz 9 - Using Pandas with Excel

Lesson 10 - Automating Excel with XlsxWriter

Quiz 10 - XslxWriter

Thanks for Watching

Buy Course or Explore Memberships

Lesson 5 – Conditional Formatting

You are unauthorized to view this page. Login below or sign up here