Excel Training videos

These videos come from our Excel video training.

How to build a simple dynamic chart

In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart...
Run time: 3:56

How to use the CHOOSE function

In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated...
Run time: 3:41

How to generate random values

In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and...
Run time: 3:39

How to copy a pivot table without the data

When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.
Run time: 2:45

How to group a pivot table with custom buckets

Pivot tables are awesome tools for grouping data, and they do a lot of grouping automatically. But pivot tables also let you group data into your own custom buckets, which is great for...
Run time: 2:45

Calculate due dates with the WORKDAY function

This video show how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. You can use WORKDAY to calculate intelligent ship dates, delivery dates, and completion dates that...
Run time: 3:40

How to plot survey data in a bar chart

In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for...
Run time: 3:42

Shade groups of rows with conditional formatting

In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows,...
Run time: 3:01

Shortcuts Recipe Remove Blank Rows

In this video, we'll look at a simple shortcut recipe for removing thousands of blank rows in a large set of data. Shortcut recipes are just a series of shortcuts you perform in a...
Run time: 1:46

How to highlight approximate match lookups

In this video we show how to highlight approximate match lookups with conditional formatting and the LOOKUP function. Highlighting approximate matches is tricky, because you must replicate...
Run time: 3:55

30+ Excel Shortcuts in 12 minutes

Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular...
Run time: 12:22

Two-way lookup with INDEX and MATCH approximate

In this video, we'll look at how to build a two-way lookup with INDEX and MATCH, using approximate matching. This is a classic solution for non-exact lookups like income tax, shipping...
Run time: 3:10

How to highlight exact match lookups

In this video, we show you how to use conditional formatting to highlight rows and columns associated with exact match lookups. This is a sleek, interactive way to show users matching...
Run time: 4:20

Simplified formula example - 401k Match

In this video, we simplify two formulas, by replacing several IF function with MIN function and boolean logic. This is a great trick to make annoyingly complex formulas easier to read and...
Run time: 3:43

Complex formula example - 401k Match

In this video, we build two formulas to calculate the company match for a 401k contribution. This is a great example of building a complex formula with several nested IFs in small steps.
Run time: 3:17