Back
Course details
View pricing Try for free
View pricing Try for free

Python with Excel

(12 reviews)

Features

Premium video tutorials

Award-winning instructors

Personalized learning

Get certified

Learn at your own pace

Mobile (learn on-the-go)

Unlimited tests and quizzes

Regularly updated content


Overview

In this beginner-friendly course, you will learn how to use Python with Excel in tandem to drastically improve your data crunching and analysis skills. 

In 40 short lessons, you will combine the power of Python and Excel using openpxyl to create, manipulate, and present data.

By the end of the course, you will be able to create spreadsheets, crunch data, and present information as charts and graphs solely using Python commands.

Using Python for Excel is ideal for those who work closely with databases or large spreadsheets, or who are interested in learning more about data analytics.

The course only requires a basic understanding of Excel and doesn’t require any previous Python or coding experience.

In this course, you will learn how to:

  • Download and install Python, Sublime Text, Git Bash, and Python openpxyl
  • Create your first python program
  • Use variables, print (), lists, tuples, and loops
  • Create workbooks and worksheets using Python
  • Read and open Excel files in Python
  • Use Excel formulas in the Python terminal
  • Manipulate data and spreadsheets using Python
  • Format and style spreadsheets using Python
  • Create basic and advanced charts and graphs
  • Create and manipulate tables
  • Add images to Excel spreadsheets using Python

Want to learn more Python skills? Check out the Intro to Python and Python for Data Analysis courses.

Python with Excel
Focus video player for keyboard shortcuts
Auto
  • HD
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Summary

Skill level: Beginner
Certificate: Yes (Excel certification)
Lessons: 40
Accredited by: CPD
Pre-requisites: None
Video duration: 3h 09m
Estimated study time: 20h for all materials

Accreditations and approvals

CPD - The CPD Certification Service. Microsoft Partner

Instructor

John Elder

John Elder

Presenter


Syllabus

Installation and Setup 5 lessons

1

Introduction

We'll spend a few minutes discussing what we'll learn throughout the course.

2

Download and Install Python

In this lesson, we'll download and install the Python programming language.

3

Download and Install Sublime Text

We're going to use the Sublime Text Editor to write our code in this course. So in this lesson, we'll download and install Sublime Text.

4

Download and Install Git Bash

To run the Python programs that we write, we need a terminal. We'll be using the git bash terminal in this course, so let's show how to download and install Git Bash.

5

Virtual Environment

To use Python properly, we create a virtual environment. In this lesson, we'll explain how to set one up.

Introduction To Python Programming 6 lessons Free Lesson

1

Try it!

Your First Python Program

In this lesson, we'll create our first Python program, called hello.py.

2

Python Variables and Print()

In this lesson, we'll discuss how to store data within your program using variables and how to display them using the Print() command.

3

Python Lists

Python lists are used to keep track of a list of items. They can be text, numbers, variables, other lists and more.

4

Python Tuples

Tuples are just like lists, but they can't be changed once created. Let's discuss how to create and reference them.

5

Python For Loops

For loops are used to loop through things like lists or groups of data.

6

Random Numbers

In this lesson, we'll show how to generate random numbers.

Introduction to OpenPYXL 10 lessons Free Lesson

1

Pip Install openpyxl and import

openpyxl is the Python library that we'll use to connect our Python code to Excel.

2

Creating Workbooks and Worksheets

To work with workbooks and worksheets in excel, we need to import some things from openpyxl.

3

Load Existing Excel File and Grab One Cell

To load data from an existing Excel spreadsheet, we need to import load_workbook from openpyxl.

4

Change Existing Cells - Method 2

There's more than one way to change data in a spreadsheet cell. This method is handy to use when looping using For Loops.

5

Try it!

Using Excel Formulas

Using Excel formulas in our Python code is easy!

6

Existing Excel - Cell Range

In this lesson, we'll discuss how to grab a whole range of cells.

7

Existing Excel - Column and Column Range

We can grab an entire column of data from an Excel spreadsheet.

8

Existing Excel - Row Range

Use this method when you want to grab an entire row - or a range of rows - from an Excel spreadsheet.

9

Existing Excel - Iterate Thru Rows

Let's discuss another method to iterate through rows in an Excel spreadsheet when you need a little more control.

10

Existing Excel - Iterate Thru Columns

Just like iterating through rows, we can also iterate through columns.

Hands on Exercise 1 lesson

1

Create Excel Spreadsheet Using Python and Random Numbers

Let's take what we've learned so far and put it to use with an exercise!

Formatting And Styling Spreadsheets With Python 6 lessons Free Lesson

1

Merge Cells and Unmerge Cells

In this lesson, we'll cover how to merge and unmerge cells.

2

Try it!

Cell Font Properties

We can change the font color and sizing by using the font property.

3

Cell Alignment

In this lesson, we'll discuss methods to change the alignment of text in a cell.

4

Cell Fill (Pattern Fill)

Pattern Fill allows you to change the color and pattern of a cell.

5

Cell Fill (Gradient Fill)

We can easily change the gradient color of a cell in a spreadsheet.

6

Borders and Sides

In this lesson, we'll discuss how to change the border style and thickness of a spreadsheet cell.

Working With Charts And Graphs 9 lessons

1

Intro To Charts And Graphs - Pie Charts

In this lesson, we'll learn how to add Pie Charts to a spreadsheet.

2

Intro To Charts and Graphs - Bar Charts, Line Charts, Area Charts, ScatterCharts

There are many other basic charts you can use with openpyxl, such as bar charts, line charts, area charts, and scatter charts.

3

Bar Charts - Vertical, Horizontal, Stacked, and 3D

In this lesson, we'll look at Bar Charts - Vertical, Horizontal, Stacked, and 3D - in a little more detail.

4

Area Charts - 2D and 3D

In this lesson, we'll discuss how to add 2D and 3D Area Charts to your spreadsheet.

5

Radar Charts

Let's show how to add Radar Charts to your spreadsheet.

6

Doughnut Charts

In this lesson, we'll look at how to add Doughnut Charts.

7

Surface Charts

We'll discuss how to add Surface Charts to your spreadsheet.

8

Bubble Chart

Use these steps to add a Bubble Chart to your spreadsheet.

9

Projected Pie Charts

In this lesson, we'll look at Projected Pie charts, which are pie charts with some chunks pulled out and projected to the side.

Creating Excel Tables 3 lessons

1

Tables - Part 1

Tables are good for sorting data manually in your spreadsheet, and for drilling down and re-imagining your data.

2

Tables - Part 2

In this lesson, we'll build a Table.

3

Adding Images

We'll cover how to add images to your spreadsheet.

Download syllabus


Certificates

You can earn 2 certificates with this course

Certificate of Training

Rewarded upon successful completion of your training course.

See sample

Certificate of Achievement

Rewarded upon successful completion of your training course and test.

See sample
Get started View pricing
View pricing Get started

See what our customers are saying...

“Really straight forward and easy to use. ”

DANNIELLE WARWICK

“Absolutely great.”

Stefan Kaps

“Good and clear instructions. Keep it up😃”

Michael R. Hallare

“Very detailed and interesting, would highly recommend”

Jessen Nullathemby

“Very logical and easy to learn from this web tool.”

Alan HU

“I enjoyed it. I especially like the mini lessons so you don't get overwhelmed with any one concept.”

KELLY AMBROISE

Others who bought this course also viewed

Microsoft PowerPoint 365
     4.7 (101 reviews)
Recommended
Project Management Basics
     4.7 (234 reviews)
Recommended
Microsoft Excel 365 - Basic & Advanced
     4.7 (2,479 reviews)
GoSkills Unlimited
     4.7 (32,083 reviews)
Back to the top

© 2023 GoSkills Ltd. Skills for career advancement