Automating Excel with Python Video Course

Automating Excel

1. Welcome to Automating Excel with Python
2. Lesson 1 - Getting Set Up for Automation
3. Lesson 2 - Reading Spreadsheets with OpenPyXL
4. Quiz 2 - Reading Spreadsheets
5. Lesson 3 - Creating a Spreadsheet with OpenPyXL
6. Quiz 3 - Creating Spreadsheets
7. Lesson 4 - Styling Cells
8. Quiz 4 - Styling Cells
9. Lesson 5 - Conditional Formatting
10. Quiz 5 - Conditional Formatting
11. Lesson 6 - Creating Charts with OpenPyXL
12. Quiz 6 - Creating Charts
13. Lesson 7 - Chart Types
14. Quiz 7 - Chart Types
15. Lesson 8 - Converting CSV Files to Excel
16. Quiz 8 - Converting CSV Files
17. Lesson 9 - Using Pandas with Excel
18. Quiz 9 - Using Pandas with Excel
19. Lesson 10 - Automating Excel with XlsxWriter
20. Quiz 10 - XslxWriter
21. Thanks for Watching