Tutorials > Excel Automation With Openpyxl

Excel Automation With Openpyxl


Date: 31 August 2022 | Posted by: voska89
Excel Automation With Openpyxl
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.77 GB | Duration: 4h 58m


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


Homepage
https://www.udemy.com/course/excel-automation-with-openpyxl/


DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article