Python with Excel

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

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

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.

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.

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

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

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

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

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

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

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

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

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

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

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

Using Excel formulas in our Python code is easy!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

In this lesson, we'll build a Table.

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