Completed
Excel and Python
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
The Boring Python Office Talk - Automate Powerpoint, Excel, and PDF with Python
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Motivation
- 3 The Challenge
- 4 What you should get from this Talk
- 5 Things we want Python to do.
- 6 Modules Used
- 7 Overall Program Flow
- 8 Excel and Python
- 9 Loading the Input Files
- 10 Data Transformation and Pivots
- 11 Simple Export to Excel
- 12 Adding an Introduction Sheet
- 13 Custom Formats by Hand (1/2)
- 14 Tables & Conditional Formats (1/2)
- 15 Creating Charts (1/2)
- 16 So much for Excel
- 17 Powerpoints with PPTX
- 18 Adding Text Boxes and Graphics
- 19 Adding Table Data to a Slide
- 20 Adding Charts to a Slide (1/2)
- 21 PPTX to PDF with Libreoffice CLI
- 22 Combining PDF Files
