Description

Learn Excel automation from scratch.

Hands On Lectures Including: Learn how to run Openpyxl on the web, which means no software installation required.

Learn simple sheet manipulate tasks with Openpyxl, including making your first workbook automatically.

Work with tables to automate your worksheets.

Learn how to format cells with Python.

Build 2D charts with Python and data.

Build an employee timelog project to put in your portfolio.

Learn how to scrape the web and save it to an Excel file.

And much more!

• 1. 01 Introduction to the Course
  • Automate Excel Files - OpenPyXL | Course Overview | 1.1

    2:21

  • Automate Excel Files - OpenPyXL | Run OpenPyXL on the Web | 1.1

    1:45

• 2. 02 Use OpenPyXL and Sheets
  • Automate Excel Files - OpenPyXL | Make a Workbook | 2.1

    11:01

  • Automate Excel Files - OpenPyXL | Save a Workbook | 2.2

    3:52

  • Automate Excel Files - OpenPyXL | Read a Workbook | 2.3

    8:02

  • Automate Excel Files - OpenPyXL | Work with Rows and Columns | 2.4

    8:07

  • Automate Excel Files - OpenPyXL | Use a Formula | 2.5

    8:41

  • Automate Excel Files - OpenPyXL | Use Dates | 2.6

    7:18

  • Automate Excel Files - OpenPyXL | Merge and Unmerge Cells | 2.7

    7:12

  • Automate Excel Files - OpenPyXL | Fold a Range | 2.8

    6:18

  • Automate Excel Files - OpenPyXL | Make a New Sheet | 2.9

    3:18

  • Automate Excel Files - OpenPyXL | Copy Data to a Sheet | 2.10

    4:36

  • Automate Excel Files - OpenPyXL | Remove a Sheet | 2.11

    3:46

• 3. 03.01 Worksheet Tables
  • Automate Excel Files - OpenPyXL | Build a Table | 3.1

    15:50

  • Automate Excel Files - OpenPyXL | Style a Table | 3.2

    8:56

• 4. 03.02 Format Cells
  • Automate Excel Files - OpenPyXL | Import Dataset | 3.3

    4:20

  • Automate Excel Files - OpenPyXL | Style a Cell | 3.4

    6:47

  • Automate Excel Files - OpenPyXL | Make a Named Cell | 3.5

    6:58

  • Automate Excel Files - OpenPyXL | Copy a Style | 3.6

    4:59

• 5. 04 Build 2D Charts
  • Automate Excel Files - OpenPyXL | Make a Chart | 4.1

    11:04

  • Automate Excel Files - OpenPyXL | Build LIne Charts | 4.2

    15:30

  • Automate Excel Files - OpenPyXL | Build a Pie Chart | 4.3

    14:09

  • Automate Excel Files - OpenPyXL | Build a Scatter Chart | 4.4

    11:22

  • Automate Excel Files - OpenPyXL | Build an Area Chart | 4.5

    8:22

• 6. 05 Project_ Employee Timelog
  • Automate Excel Files - OpenPyXL | Project Setup | 5.1

    4:30

  • Automate Excel Files - OpenPyXL | Expand Columns to Fit Content | 5.2

    6:35

  • Automate Excel Files - OpenPyXL | Add Dates | 5.3

    7:34

  • Automate Excel Files - OpenPyXL | Add Days of the Week | 5.4

    7:12

• 7. 06 Write to a Text File
  • Automate Excel Files - OpenPyXL | Read Speadsheet | 6.1

    7:12

  • Automate Excel Files - OpenPyXL | Store Spreadsheet Data | 6.2

    3:39

  • Automate Excel Files - OpenPyXL | Write to a Text File | 6.3

    5:22

• 8. 07 Update a Spreadsheet
  • Automate Excel Files - OpenPyXL | Update the Spreadsheet | 7.2

    5:42

  • Automate Excel Files - OpenPyXL | Set Up Update Information | 7.1

    3:44

• 9. 08 More Chart Types
  • Automate Excel Files - OpenPyXL | Build a Stock Chart | 8.1

    9:14

  • Automate Excel Files - OpenPyXL | Build a Doughnut Chart | 8.2

    9:23

  • Automate Excel Files - OpenPyXL | Build a Bubble Chart | 8.3

    8:54

• 10. 09 Web Scraping
  • Automate Excel Files - OpenPyXL | Import Web Driver | 9.1

    8:07

  • Automate Excel Files - OpenPyXL | Scrape a Web Page | 9.2

    6:07

  • Automate Excel Files - OpenPyXL | Parse Page Data | 9.3

    9:18

  • Automate Excel Files - OpenPyXL | Put Data into Excel Sheet | 9.4

    6:23

  • Automate Excel Files - OpenPyXL | Clean Data | 9.5

    4:39