starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Courses
  2. >
  3. Python Excel

Python Excel

This course shows you how to use OpenPyXL to automate functions in Excel using Python, automate Excel tasks and build a wide range of Excel projects.

John Bura
John Bura
Business | advanced | 3 hours 30 minutes |   Published: Jan 2021

    Discussions

Overview

1.2KSTUDENTS*
92.8%RECOMMEND*

This course includes:

  • 3+ hours of on-demand video
  • 9 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
This course shows you how to use OpenPyXL to automate functions in Excel using Python, automate Excel tasks and build a wide range of Excel projects.

Skills You Will Gain

Excel
OpenPyxl
Python
Python and charts
Python and datasets

Learning Outcomes (At The End Of This Program, You Will Be Able To...)

Prerequisites

None other than a basic understanding of computers

Who Should Attend

Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.

Curriculum

Instructors

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
1Module 01: Introduction to the Course
2Module 02: Use OpenPyXL and Sheets
3Module 03: Worksheet Tables
4Module 04: Build 2D Charts
5Module 05: Project Employee Time log
6Module 06: Write to a Text File
7Module 07: Update a Spreadsheet
8Module 08: More Chart Types
9Module 09: Web Scrapping

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 01 - Course Overview

Segment - 02 - Run OpenPyXL on the Web

Source File

John Bura

John Bura

John Bura is a seasoned game developer, eLearning innovator, and AI coach with over 15 years of experience in the tech industry. Based in Vancouver, Canada, he serves as the CEO of Mammoth Interactive, where he leads the development of top-ranking games and applications across multiple platforms. His leadership also extends to Devonian Apps, a SaaS company known for delivering high-quality, fast-to-market digital products.

John is deeply passionate about education through technology. As a celebrated Udemy instructor, he has empowered over 300,000 students worldwide through practical courses on HTML5, Xcode, and game design, with his teaching style widely recognized for its clarity and real-world applicability. His dedication to curriculum excellence was further reflected in his role as a Program Advisor at Centennial College, where he shaped game design education to match industry demands.

With a rich background in both creative and technical disciplines, John has had his work featured by major industry players like Nickelodeon. As a forward-thinking AI expert, he now coaches businesses on building intelligent, automated infrastructures to increase efficiency and scalability. He's currently developing a cutting-edge tool that automates podcast and video production for content creators, furthering his mission to make innovation accessible.

Whether building games, coaching teams, or designing AI-powered tools, John blends creativity with technical mastery to drive productivity, foster innovation, and inspire learners around the world.

VIEW MY CHANNEL

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 03 - Make a Workbook

Segment - 04 - Save a Workbook

Segment - 05 - Work with Rows and Columns

Segment - 06 - Merge and Unmerge Cells

Segment - 07 - Fold a Range

Segment - 08 - Make a New Sheet

Segment - 09 - Copy Data to a Sheet

Segment - 10 - Remove a Sheet

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 17 - Make a Chart

Segment - 18 - Build Line Charts

Segment - 19 - Build a Pie Chart

Segment - 21 - Build an Area Chart

Segment - 20 - Build a Scatter Chart

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 22 - Project Setup

Segment - 23 - Expand Columns to Fit Content

Segment - 24 - Add Dates

Segment - 25 - Add Days of the Week

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 29 - Set up Update Information

Segment - 30 - Update the Spreadsheet

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 34 - Import Web Driver

Segment - 35 - Scrape a Web Page

Segment - 36 - Parse Page Data

Segment - 37 - Put Data into Excel Sheet

Segment - 38 - Clean Data

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 26 - Read Spreadsheet Data

Segment - 27 - Store Spreadsheet Data

Segment - 28 - Write to a Text File

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 11 - Build a Table

Segment - 12 -Style a Table

Segment - 13 - Import Dataset

Segment - 14 - Style a Cell

Segment - 15 - Make a Named Style

Segment - 16 - Copy a Style

Source Files

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 31 - Build a Stock Chart

Segment - 32 - Build a Doughnut Chart

Segment - 33 - Build a Bubble Chart

Source File