Excel Training Videos

Some videos from our online training – quick, clean, and to the point.

Quick Links

Video thumbnail for How to apply conditional formatting with a formula

Conditional Formatting

2:41

How to apply conditional formatting with a formula

Video thumbnail for SORT and SORTBY with multiple columns

Dynamic Array Formulas

3:02

SORT and SORTBY with multiple columns

Video thumbnail for The IF function

3:09

The IF function

Video thumbnail for Don't hard code values that may change

3:09

Don't hard code values that may change

Video thumbnail for How to rank values with the RANK function

2:59

How to rank values with the RANK function

Video thumbnail for How to build a combo chart

2:51

How to build a combo chart

Video thumbnail for How to clean text with CLEAN and TRIM

2:22

How to clean text with CLEAN and TRIM

Video thumbnail for Dynamic min and max data labels

3:14

Dynamic min and max data labels

Video thumbnail for FILTER function with two criteria

Dynamic Array Formulas

3:21

FILTER function with two criteria

Video thumbnail for Array formulas with AND and OR logic

Dynamic Array Formulas

3:36

Array formulas with AND and OR logic

Video thumbnail for What is an Excel Table

3:08

What is an Excel Table

Video thumbnail for How to perform a random sort

Dynamic Array Formulas

2:31

How to perform a random sort

Video thumbnail for How to highlight approximate match lookups

Conditional Formatting

3:55

How to highlight approximate match lookups

Video thumbnail for Dynamic arrays are native

Dynamic Array Formulas

2:52

Dynamic arrays are native

Video thumbnail for How to group a pivot table manually

2:51

How to group a pivot table manually

Video thumbnail for Charts and custom number formats

3:13

Charts and custom number formats

Video thumbnail for How to make a nested IF formula easier to read

3:06

How to make a nested IF formula easier to read

Video thumbnail for Two-way summary with dynamic arrays

Dynamic Array Formulas

3:37

Two-way summary with dynamic arrays

Video thumbnail for How to chart sunrise and sunset

3:49

How to chart sunrise and sunset

Video thumbnail for What is an array formula?

Dynamic Array Formulas

2:53

What is an array formula?

Video thumbnail for How to fill in missing data with a simple formula

3:19

How to fill in missing data with a simple formula

Video thumbnail for How to copy a pivot table without the data

2:43

How to copy a pivot table without the data

Video thumbnail for How to add unique count to a pivot table

3:27

How to add unique count to a pivot table

Video thumbnail for How to do a two-way lookup with INDEX and MATCH

3:18

How to do a two-way lookup with INDEX and MATCH

Video thumbnail for Intro to Boolean Logic

3:33

Intro to Boolean Logic

Video thumbnail for FILTER function basic example

Dynamic Array Formulas

2:44

FILTER function basic example

Video thumbnail for What is conditional formatting?

Conditional Formatting

2:33

What is conditional formatting?

Video thumbnail for What is an array?

Dynamic Array Formulas

2:34

What is an array?

Video thumbnail for How to count items in a filtered list

3:15

How to count items in a filtered list

Video thumbnail for How to set up a running total in a table

3:44

How to set up a running total in a table

Video thumbnail for How to refresh data in a pivot table

2:41

How to refresh data in a pivot table

Video thumbnail for The UNIQUE function

Dynamic Array Formulas

3:12

The UNIQUE function

Video thumbnail for How to look things up with INDEX

2:48

How to look things up with INDEX

Video thumbnail for How to create a mixed reference

2:33

How to create a mixed reference

Video thumbnail for How to clone a pivot table

3:11

How to clone a pivot table

Video thumbnail for Shortcuts to hide/unhide rows and columns

Excel Shortcuts

2:53

Shortcuts to hide/unhide rows and columns

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Charts video training course

Video training for Excel Tables

Dynamic Array Formulas