Course curriculum

  • 1

    Welcome to the course!

    • Instructor bio - John Bura
    • Key pointers for this program
    • Joining the Alumni Community
  • 2

    Introduction to the Course

    • Segment - 01 - Course Overview
    • Segment - 02 - Run OpenPyXL on the Web
    • Source File
  • 3

    Use OpenPyXL and Sheets

    • 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
  • 4

    Worksheet Tables

    • 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
  • 5

    Build 2D Charts

    • 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
  • 6

    Project Employee Time log

    • Segment - 22 - Project Setup
    • Segment - 23 - Expand Columns to Fit Content
    • Segment - 24 - Add Dates
    • Segment - 25 - Add Days of the Week
    • Source File
  • 7

    Write to a Text File

    • Segment - 26 - Read Spreadsheet Data
    • Segment - 27 - Store Spreadsheet Data
    • Segment - 28 - Write to a Text File
    • Source File
  • 8

    Update a Spreadsheet

    • Segment - 29 - Set up Update Information
    • Segment - 30 - Update the Spreadsheet
    • Source File
  • 9

    More Chart Types

    • Segment - 31 - Build a Stock Chart
    • Segment - 32 - Build a Doughnut Chart
    • Segment - 33 - Build a Bubble Chart
    • Source File
  • 10

    Web Scrapping

    • 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