Excel Automation With Openpyxl

Build worksheets and charts with OpenPyXL

What you'll learn
Use OpenPyXL and Sheets
Worksheet Tables
Format Cells
Build 2D Charts
Requirements
No experience necessary
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 OpenPyXLBuild an employee timelogScrape the web and moreThis 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 QuestionsHow 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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 01.01 Run Openpyxl on the Web

Section 2: 02 Use OpenPyXL and Sheets

Lecture 3 02.01 Make a Workbook

Lecture 4 02.02 Save a Workbook

Lecture 5 02.03 Read a Workbook

Lecture 6 02.04 Work with Rows and Columns

Lecture 7 02.05 Use a Formula

Lecture 8 02.06 Use Dates

Lecture 9 02.07 Merge and Unmerge Cells

Lecture 10 02.08 Fold a Range

Lecture 11 02.09 Make a New Sheet

Lecture 12 02.10 Copy Data to a Sheet

Lecture 13 02.11 Remove a Sheet

Section 3: 03.01 Worksheet Tables

Lecture 14 03-01.01 Build a Table

Lecture 15 03-01.02 Style a Table

Section 4: 03.02 Format Cells

Lecture 16 03-02.01 Import Dataset

Lecture 17 03-02.02 Style a Cell

Lecture 18 03-02.03 Make a Named Style

Lecture 19 03-02.04 Copy a Style

Section 5: 04 Build 2D Charts

Lecture 20 04.01 Make a Chart

Lecture 21 04.02 Build Line Charts

Lecture 22 04.03 Build a Pie Chart

Lecture 23 04.04 Build a Scatter Chart

Lecture 24 04.05 Build an Area Chart

Section 6: 05 Project_ Employee Timelog

Lecture 25 05.01 Project Setup

Lecture 26 05.02 Expand Columns to Fit Content

Lecture 27 05.03 Add Dates

Lecture 28 05.04 Add Days of the Week

Section 7: 06 Write to a Text File

Lecture 29 06.01 Read Spreadsheet Data

Lecture 30 06.02 Store Spreadsheet Data

Lecture 31 06.03 Write to a Text File

Section 8: 07 Update a Spreadsheet

Lecture 32 07.01 Set Up Update Information

Lecture 33 07.02 Update the Spreadsheet

Section 9: 08 More Chart Types

Lecture 34 08.01 Build a Stock Chart

Lecture 35 08.02 Build a Doughnut Chart

Lecture 36 08.03 Build a Bubble Chart

Section 10: 09 Web Scraping

Lecture 37 09.01 Import Web Driver

Lecture 38 09.02 Scrape a Web Page

Lecture 39 09.03 Parse Page Data

Lecture 40 09.04 Put Data into Excel Sheet

Lecture 41 09.05 Clean Data

Anyone interested in automating Excel with Python