Automate Excel Files with Python OpenPyXL

40 casts | 4:51:11 for the total course

Excel Python Openpyxl

Description

Buff your skills to keep your job and get a raise in ANY economic climate. This course

BUNDLE keeps your skills sharp and your paycheque up!

  • Build worksheets and charts with OpenPyXL
  • Build an employee timelog
  • Scrape the web and more

This masterclass is without a doubt the most comprehensive course available anywhere online. Even if you have zero experience, this course will take you from beginner to professional.

Frequently Asked Questions

How do I obtain a certificate? Each certificate in this bundle is only awarded after you have completed every lecture of the course.

Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification. Is this an eBook or videos?

The majority of this course bundle will be video tutorials (screencasts of practical coding projects step by step.) We will also have several PDFs and all source code.

Can’t I just learn via Google or YouTube? This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive 5 course curriculum to take you from absolute beginner to starting a high paying career.

How will I practice to ensure I’m learning? With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time. Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.

Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency minded software for technology workers like you.

Try a course today

  • 1. 1 - 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. 2 - 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. 3.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. 3.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 | Copy a Style | 3.6

      4:59

  • 5. 4 - 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. 5 - 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. 6 - 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. 7 - Update a Spreadsheet
    • Automate Excel Files - OpenPyXL | Set Up Update Information | 7.1

      3:44

    • Automate Excel Files - OpenPyXL | Update the Spreadsheet | 7.2

      5:42

  • 9. 8 - 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. 9 - 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

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet