Excel Training Videos

These videos come from our online training. Mastering Excel requires a lot of practice — you must learn by doing. We make short videos so you can watch a demo and practice a skill in less than 10 minutes. Quick, clean, and to the point.

Quick Links

How to update a pivot chart

2:42

How to update a pivot chart

How to use VLOOKUP to merge tables

3:06

How to use VLOOKUP to merge tables

How to create a mixed reference

2:33

How to create a mixed reference

Basic XLOOKUP approximate match

Dynamic Array Formulas

3:22

Basic XLOOKUP approximate match

How to add a secondary axis to a chart

2:56

How to add a secondary axis to a chart

How to use the COUNT function

1:31

How to use the COUNT function

Structured reference syntax examples

3:33

Structured reference syntax examples

Shortcuts to group, ungroup, and outline

Excel Shortcuts

3:05

Shortcuts to group, ungroup, and outline

Pivot Table Example - Sales by sales person

2:02

Pivot Table Example - Sales by sales person

The UNIQUE function

Dynamic Array Formulas

3:12

The UNIQUE function

How to control grand totals in a pivot table

1:53

How to control grand totals in a pivot table

How to move and resize a chart in Excel

2:45

How to move and resize a chart in Excel

How to highlight above and below average values

Conditional Formatting

2:43

How to highlight above and below average values

How to undo and redo changes in Excel

2:39

How to undo and redo changes in Excel

How to delete conditional formatting rules

Conditional Formatting

2:20

How to delete conditional formatting rules

How to group a pivot table by day of week

3:39

How to group a pivot table by day of week

How to create zebra stripes with conditional formatting

Conditional Formatting

3:30

How to create zebra stripes with conditional formatting

How to copy and lock structured references

3:36

How to copy and lock structured references

Shortcuts for named ranges

Excel Shortcuts

3:39

Shortcuts for named ranges

How to navigate a workbook

2:32

How to navigate a workbook

Charts and custom number formats

3:13

Charts and custom number formats

What is a formula?

2:28

What is a formula?

Named ranges as absolute references

2:16

Named ranges as absolute references

How to manage named ranges

2:17

How to manage named ranges

How to find text with a formula

3:16

How to find text with a formula

List duplicate values with FILTER

Dynamic Array Formulas

2:52

List duplicate values with FILTER

How to apply subscript, superscript, and strikethrough formatting in Excel

3:03

How to apply subscript, superscript, and strikethrough formatting in Excel

How to make a nested IF formula easier to read

3:06

How to make a nested IF formula easier to read

How to select cells in Excel

2:21

How to select cells in Excel

How to create 3D references

3:08

How to create 3D references

Shortcuts to move the active cell

Excel Shortcuts

3:03

Shortcuts to move the active cell

How to change the font color in Excel

2:40

How to change the font color in Excel

How to remove an Excel Table

3:08

How to remove an Excel Table

How to count characters with the LEN function

2:52

How to count characters with the LEN function

How to calculate years and months between dates

3:51

How to calculate years and months between dates

How to find and replace a value

2:36

How to find and replace a value

How to find and open recent workbooks

2:03

How to find and open recent workbooks

How to test a conditional formatting formula

Conditional Formatting

3:15

How to test a conditional formatting formula

How to calculate and highlight expiration dates

3:54

How to calculate and highlight expiration dates

Chart colors and styles

2:35

Chart colors and styles

Understanding data series

2:46

Understanding data series

How to use multiplication in a formula

2:07

How to use multiplication in a formula

The SEQUENCE function

Dynamic Array Formulas

3:11

The SEQUENCE function

Structured references inside a table

2:53

Structured references inside a table

How to use relative references - example 2

2:37

How to use relative references - example 2

How to use the COUNTIF function

3:03

How to use the COUNTIF function

How to create a new pivot table style

3:15

How to create a new pivot table style

XLOOKUP with boolean logic

Dynamic Array Formulas

3:05

XLOOKUP with boolean logic

Welcome

2:26

Welcome

How to use MATCH to find approximate matches

2:53

How to use MATCH to find approximate matches

How to search in formulas and values in Excel

2:41

How to search in formulas and values in Excel

How to change case with UPPER LOWER and PROPER

2:59

How to change case with UPPER LOWER and PROPER

How to use addition in a formula

2:20

How to use addition in a formula

How to use date formatting in Excel

2:53

How to use date formatting in Excel

Introducing Excel shortcuts

Excel Shortcuts

3:54

Introducing Excel shortcuts

SEQUENCE of dates

Dynamic Array Formulas

2:45

SEQUENCE of dates

How to apply general formatting in Excel

2:31

How to apply general formatting in Excel

Conditional formatting formula in a table

3:09

Conditional formatting formula in a table

How to insert and delete columns in Excel

1:55

How to insert and delete columns in Excel

How to format chart and plot area

2:37

How to format chart and plot area

FILTER data between two dates

Dynamic Array Formulas

3:06

FILTER data between two dates

How to group a pivot table manually

2:51

How to group a pivot table manually

Basic XLOOKUP example

Dynamic Array Formulas

2:48

Basic XLOOKUP example

Sort by custom list with SORTBY

Dynamic Array Formulas

2:50

Sort by custom list with SORTBY

How to generate random dates

Dynamic Array Formulas

2:53

How to generate random dates

Recommended charts

2:45

Recommended charts

How to use borders and fills together in Excel

2:30

How to use borders and fills together in Excel

How to use scientific formatting in Excel

2:32

How to use scientific formatting in Excel

How to apply a table style

2:29

How to apply a table style

How to display current date and time

1:51

How to display current date and time

How to add a calculated field to a pivot table

3:04

How to add a calculated field to a pivot table

Why you should use a table for your pivot table

3:14

Why you should use a table for your pivot table

Shortcuts for editing cells

Excel Shortcuts

3:35

Shortcuts for editing cells

Conditional formatting with two variable inputs

Conditional Formatting

2:59

Conditional formatting with two variable inputs

How to enter data in Excel

1:42

How to enter data in Excel

How to change column widths in Excel

2:29

How to change column widths in Excel

Basic SORT function example

Dynamic Array Formulas

2:33

Basic SORT function example

How to fill in missing data with a simple formula

3:19

How to fill in missing data with a simple formula

$How to change the math used for pivot table values$

2:43

How to change the math used for pivot table values

How to build all-in-one formulas

3:44

How to build all-in-one formulas

How to compare two lists and highlight differences

Conditional Formatting

2:28

How to compare two lists and highlight differences

Shortcuts for formatting

Excel Shortcuts

3:54

Shortcuts for formatting

Dynamic min and max data labels

3:14

Dynamic min and max data labels

TEXTAFTER with TEXTBEFORE

Dynamic Array Formulas

3:48

TEXTAFTER with TEXTBEFORE

How to create a multi level axis

3:36

How to create a multi level axis

Excel TEXTSPLIT function

Dynamic Array Formulas

3:17

Excel TEXTSPLIT function

How to create a new table style

3:41

How to create a new table style

How to use data bars with conditional formatting

Conditional Formatting

3:10

How to use data bars with conditional formatting

How to select rows and columns in Excel

1:43

How to select rows and columns in Excel

How to create a dynamic named range with a Table

3:00

How to create a dynamic named range with a Table

How to rename fields in a pivot table

3:08

How to rename fields in a pivot table

Shortcuts to insert/delete rows and columns

Excel Shortcuts

3:10

Shortcuts to insert/delete rows and columns

How to save a workbook in a different format

2:48

How to save a workbook in a different format

How to save a formula that's not finished

1:19

How to save a formula that's not finished

How to use the SUMIF function

3:43

How to use the SUMIF function

How to sort a pivot table by value

2:55

How to sort a pivot table by value

What's an absolute reference?

3:00

What's an absolute reference?

What is a function?

2:16

What is a function?

How to highlight rows using multiple criteria

Conditional Formatting

3:18

How to highlight rows using multiple criteria

FILTER function with two criteria

Dynamic Array Formulas

3:21

FILTER function with two criteria

How to drill down into a pivot table

2:12

How to drill down into a pivot table

Shortcuts to cut copy paste

Excel Shortcuts

2:33

Shortcuts to cut copy paste

Shortcuts to undo, redo and repeat

Excel Shortcuts

3:22

Shortcuts to undo, redo and repeat

How to use CHAR and CODE functions

3:04

How to use CHAR and CODE functions

How to create a basic chart

2:26

How to create a basic chart

Boolean algebra in Excel

Dynamic Array Formulas

3:00

Boolean algebra in Excel

How to check and debug a formula with F9

3:12

How to check and debug a formula with F9

Standalone and embedded charts

2:01

Standalone and embedded charts

Excel charting tools overview

3:31

Excel charting tools overview

How to filter a pivot table to show top values

1:57

How to filter a pivot table to show top values

How to add a field to a pivot table more than once

2:14

How to add a field to a pivot table more than once

How to check line length with conditional formatting

Conditional Formatting

3:06

How to check line length with conditional formatting

How to enter functions

3:01

How to enter functions

How to clone a pivot table

3:11

How to clone a pivot table

How to use Center Across Selection in Excel

2:54

How to use Center Across Selection in Excel

Excel formula error codes

4:22

Excel formula error codes

How to use a formula with conditional formatting

Conditional Formatting

3:07

How to use a formula with conditional formatting

How to build a clustered column chart

2:54

How to build a clustered column chart

XLOOKUP with multiple lookup values

Dynamic Array Formulas

2:39

XLOOKUP with multiple lookup values

How to create a formula with nested IFs

3:15

How to create a formula with nested IFs

How to build a column chart

3:22

How to build a column chart

How to apply a border using ribbon presets in Excel

2:51

How to apply a border using ribbon presets in Excel

How to use VLOOKUP

3:10

How to use VLOOKUP

How to wrap text in cells in Excel

2:41

How to wrap text in cells in Excel

How to use INDEX and MATCH with a table

3:20

How to use INDEX and MATCH with a table

Pivot Table Example - Voting results

1:44

Pivot Table Example - Voting results

How to work with data series

2:42

How to work with data series

Shortcuts for drag and drop

Excel Shortcuts

2:43

Shortcuts for drag and drop

How to quickly create a pivot table

2:56

How to quickly create a pivot table

Conditional formatting with one variable input

Conditional Formatting

2:43

Conditional formatting with one variable input

Anatomy of an Excel Table

2:42

Anatomy of an Excel Table

How to format numbers in a pivot table

2:15

How to format numbers in a pivot table

How to use Table filters

3:29

How to use Table filters

How to concatenate with line breaks

3:15

How to concatenate with line breaks

How to align text across cells with merge in Excel

2:55

How to align text across cells with merge in Excel

How to trace a formula error

2:29

How to trace a formula error

How to customize axis labels

3:06

How to customize axis labels

Shortcuts for the current Date and Time in Excel

0:55

Shortcuts for the current Date and Time in Excel

How to use concatenation to clarify assumptions

3:20

How to use concatenation to clarify assumptions

How to group values with VLOOKUP

2:41

How to group values with VLOOKUP

Shortcuts to navigate workbooks

Excel Shortcuts

3:36

Shortcuts to navigate workbooks

Use a throwaway chart to sanity check data

2:53

Use a throwaway chart to sanity check data

How to perform a random sort

Dynamic Array Formulas

2:31

How to perform a random sort

How to combine functions in a formula

2:45

How to combine functions in a formula

How to control subtotals in a pivot table

3:03

How to control subtotals in a pivot table

How to use absolute references - example 2

2:49

How to use absolute references - example 2

How to use time formatting in Excel

2:49

How to use time formatting in Excel

Shortcuts for selecting cells in Excel

2:09

Shortcuts for selecting cells in Excel

How to create a reference to another worksheet

2:55

How to create a reference to another worksheet

Pivot Table Example - IMDB Movie data

2:28

Pivot Table Example - IMDB Movie data

How to create an Excel Table

3:08

How to create an Excel Table

How to chart sunrise and sunset

3:49

How to chart sunrise and sunset

How to use a slicer with multiple pivot tables

2:30

How to use a slicer with multiple pivot tables

How to save a workbook

2:16

How to save a workbook

How to use the AVERAGEIF function

3:14

How to use the AVERAGEIF function

How to edit data in Excel

1:22

How to edit data in Excel

How to use the status bar for quick calculations

2:36

How to use the status bar for quick calculations

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

3:18

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

How to troubleshoot VLOOKUP approximate match

2:43

How to troubleshoot VLOOKUP approximate match

Pivot Table Example - Instrument readings

2:32

Pivot Table Example - Instrument readings

How to pick names out of a hat with Excel

3:07

How to pick names out of a hat with Excel

How to create a complex formula step by step

3:07

How to create a complex formula step by step

How to see arrays in formulas

Dynamic Array Formulas

2:55

How to see arrays in formulas

How to remove duplicates from a table

2:54

How to remove duplicates from a table

How to sort a pivot table manually

2:04

How to sort a pivot table manually

How to create a custom number format in Excel

2:48

How to create a custom number format in Excel

How to add a title and legend to a chart

3:00

How to add a title and legend to a chart

How to apply a fill to cells in Excel

2:48

How to apply a fill to cells in Excel

How to test conditional formatting with dummy formula

Conditional Formatting

3:28

How to test conditional formatting with dummy formula

How to rank values with the RANK function

2:59

How to rank values with the RANK function

How to count items in a filtered list

3:15

How to count items in a filtered list

How to extract text with LEFT and RIGHT

2:35

How to extract text with LEFT and RIGHT

How to highlight approximate match lookups

Conditional Formatting

3:55

How to highlight approximate match lookups

How to make a histogram chart

3:15

How to make a histogram chart

How to use number formatting in Excel

2:47

How to use number formatting in Excel

The Format Task pane

3:04

The Format Task pane

How to build a simple pivot chart dashboard

3:28

How to build a simple pivot chart dashboard

How to enter historical dates in Excel

2:14

How to enter historical dates in Excel

Excel TEXTBEFORE function

Dynamic Array Formulas

3:48

Excel TEXTBEFORE function

Data validation with an Excel table

3:09

Data validation with an Excel table

Shade groups of rows with conditional formatting

Conditional Formatting

3:01

Shade groups of rows with conditional formatting

How to use the SUM function

1:32

How to use the SUM function

How to use the MATCH Function for exact matches

3:23

How to use the MATCH Function for exact matches

How to create a basic Excel chart

3:10

How to create a basic Excel chart

Chart elements and layouts

2:57

Chart elements and layouts

How to collapse and expand pivot table groups

2:40

How to collapse and expand pivot table groups

What to do when VLOOKUP returns NA

2:40

What to do when VLOOKUP returns NA

How to align text vertically in Excel

3:08

How to align text vertically in Excel

Shortcuts for Excel Tables

Excel Shortcuts

3:17

Shortcuts for Excel Tables

How to reverse a chart axis

3:06

How to reverse a chart axis

How to find and highlight formulas

3:54

How to find and highlight formulas

Excel TEXTAFTER function

Dynamic Array Formulas

4:15

Excel TEXTAFTER function

How to add additional conditional formatting rules

Conditional Formatting

2:58

How to add additional conditional formatting rules

How to generate random times

Dynamic Array Formulas

2:45

How to generate random times

SEQUENCE of times

Dynamic Array Formulas

3:03

SEQUENCE of times

Nesting dynamic array formulas

Dynamic Array Formulas

3:02

Nesting dynamic array formulas

How to name and format worksheet tabs

2:21

How to name and format worksheet tabs

How to enter dates in Excel

1:19

How to enter dates in Excel

How to create date and time series with formulas

3:24

How to create date and time series with formulas

Conditional Formatting

2:56

How to use Icon sets with conditional formatting

The order of operations

2:54

The order of operations

23 Excel formula tips

9:19

23 Excel formula tips

Filter with dynamic dropdown list

Dynamic Array Formulas

2:55

Filter with dynamic dropdown list

Why VLOOKUP is better than nested IFs

2:56

Why VLOOKUP is better than nested IFs

How to create a standalone chart

2:31

How to create a standalone chart

How to create a dynamic named range with INDEX

4:07

How to create a dynamic named range with INDEX

How to insert and delete rows in Excel

1:49

How to insert and delete rows in Excel

3 basic array formulas

Dynamic Array Formulas

2:55

3 basic array formulas

How to freeze columns or rows in a list

2:27

How to freeze columns or rows in a list

Anatomy of an Excel chart

2:28

Anatomy of an Excel chart

How to build an area chart

3:53

How to build an area chart

How to build a stacked column chart

3:33

How to build a stacked column chart

How to filter a list

2:44

How to filter a list

How to use drag and drop in Excel

1:56

How to use drag and drop in Excel

How to use Calculated Columns

2:49

How to use Calculated Columns

A tour of the Excel Ribbon

3:09

A tour of the Excel Ribbon

Unique values with criteria

Dynamic Array Formulas

3:08

Unique values with criteria

How to make an exact copy of a formula

2:59

How to make an exact copy of a formula

How to edit and add to chart data

2:25

How to edit and add to chart data

How to hide and unhide worksheets

2:12

How to hide and unhide worksheets

How to set a default custom table style

3:29

How to set a default custom table style

What is Excel?

2:32

What is Excel?

How to highlight text values with conditional formatting

Conditional Formatting

2:08

How to highlight text values with conditional formatting

How to add slicers to a pivot table

3:14

How to add slicers to a pivot table

Shortcuts for functions

Excel Shortcuts

3:02

Shortcuts for functions

How to rank with a pivot table

3:09

How to rank with a pivot table

Conditional formatting based on a different cell

Conditional Formatting

2:24

Conditional formatting based on a different cell

What is a cell reference?

2:15

What is a cell reference?

How to use the format painter

3:13

How to use the format painter

Shortcut recipe: fill in missing data

Excel Shortcuts

2:42

Shortcut recipe: fill in missing data

How to format font and font size in Excel

3:05

How to format font and font size in Excel

The IF function

3:09

The IF function

10 pivot table problems and easy fixes

11:01

10 pivot table problems and easy fixes

Dynamic arrays are native

Dynamic Array Formulas

2:52

Dynamic arrays are native

How to work with dates

2:54

How to work with dates

How to make a Pareto chart

2:50

How to make a Pareto chart

Examples of flagged errors in formulas

3:00

Examples of flagged errors in formulas

How to filter with multiple criteria

3:07

How to filter with multiple criteria

How to generate random text values

Dynamic Array Formulas

2:58

How to generate random text values

Shortcuts for borders

Excel Shortcuts

3:15

Shortcuts for borders

What is an array formula?

Dynamic Array Formulas

2:53

What is an array formula?

How to sort using more than one column

2:56

How to sort using more than one column

Shortcuts for charts

Excel Shortcuts

2:53

Shortcuts for charts

What is an array?

Dynamic Array Formulas

2:34

What is an array?

How to use SUMIFS with an Excel Table

3:35

How to use SUMIFS with an Excel Table

Shortcuts for extending selections

Excel Shortcuts

2:51

Shortcuts for extending selections

How to change chart data

2:07

How to change chart data

How to move and copy worksheets to other workbooks

2:47

How to move and copy worksheets to other workbooks

Shortcuts to navigate worksheets

Excel Shortcuts

3:17

Shortcuts to navigate worksheets

How to fill in missing data part 2

2:55

How to fill in missing data part 2

Spilling and the spill range

Dynamic Array Formulas

2:34

Spilling and the spill range

How to use absolute references - example 1

2:37

How to use absolute references - example 1

Shortcuts for number formats

Excel Shortcuts

2:24

Shortcuts for number formats

How to trace formula relationships

3:13

How to trace formula relationships

How to create a new workbook

2:06

How to create a new workbook

How to move around big lists fast

2:40

How to move around big lists fast

How to build a combo chart

2:51

How to build a combo chart

Complex formula example 401k Match

3:17

Complex formula example 401k Match

How to quickly remove rows that have empty values

3:46

How to quickly remove rows that have empty values

How to show duplicate values with conditional formatting

Conditional Formatting

1:59

How to show duplicate values with conditional formatting

How to enter times in Excel

1:46

How to enter times in Excel

How to look things up with INDEX

2:48

How to look things up with INDEX

How to add a calculated item to a pivot table

3:33

How to add a calculated item to a pivot table

How to randomly assign people to teams

3:49

How to randomly assign people to teams

How to filter a pivot table globally

2:41

How to filter a pivot table globally

How to indent cell content in Excel

3:02

How to indent cell content in Excel

Shortcuts to find and replace

Excel Shortcuts

2:33

Shortcuts to find and replace

How to apply a pivot table style

2:27

How to apply a pivot table style

Selecting chart elements

3:13

Selecting chart elements

Understanding pivot charts

3:21

Understanding pivot charts

How to apply different underline options in Excel

2:41

How to apply different underline options in Excel

What is a number format in Excel?

3:21

What is a number format in Excel?

30 Excel Shortcuts in 12 minutes

Excel Shortcuts

12:21

30 Excel Shortcuts in 12 minutes

How to build a pie chart

3:04

How to build a pie chart

How to copy a table style to another file

2:26

How to copy a table style to another file

How to step through complex formulas using Evaluate

3:16

How to step through complex formulas using Evaluate

TEXTSPLIT with numbers

Dynamic Array Formulas

3:30

TEXTSPLIT with numbers

What is text in Excel

3:07

What is text in Excel

How to make a stacked area chart

3:26

How to make a stacked area chart

How to insert symbols and special characters in Excel

3:18

How to insert symbols and special characters in Excel

How to show top or bottom n results

Dynamic Array Formulas

2:56

How to show top or bottom n results

How to add a slicer to a pivot chart

2:11

How to add a slicer to a pivot chart

How to modify a calculated item in a pivot table

2:56

How to modify a calculated item in a pivot table

How to create a conditional formatting rule

Conditional Formatting

2:27

How to create a conditional formatting rule

A tour of the Excel interface

2:34

A tour of the Excel interface

How to quickly remove blank rows

2:01

How to quickly remove blank rows

How to add a conditional formatting key

Conditional Formatting

3:28

How to add a conditional formatting key

Why pivot tables?

10:00

Why pivot tables?

Shortcuts for Excel dialog boxes (Mac)

Excel Shortcuts

3:25

Shortcuts for Excel dialog boxes (Mac)

How to use the AVERAGEIFS function

3:20

How to use the AVERAGEIFS function

How to build a 100% stacked chart with percentages

2:47

How to build a 100% stacked chart with percentages

Array formulas with AND and OR logic

Dynamic Array Formulas

3:36

Array formulas with AND and OR logic

How to delete data in Excel

2:00

How to delete data in Excel

How to create a pivot chart 2016

2:40

How to create a pivot chart 2016

If this OR that

3:02

If this OR that

How to add and remove data series

2:38

How to add and remove data series

Shortcuts for formulas

Excel Shortcuts

4:05

Shortcuts for formulas

How to duplicate data in Excel

2:44

How to duplicate data in Excel

How to use data labels

2:42

How to use data labels

A tour of the File tab

2:44

A tour of the File tab

How to find a formatted value in Excel

2:53

How to find a formatted value in Excel

How to sort a pivot table alphabetically

2:55

How to sort a pivot table alphabetically

Introduction to table styles

1:35

Introduction to table styles

How to move and copy worksheets in Excel

2:20

How to move and copy worksheets in Excel

How to replace nested IFs with VLOOKUP

3:55

How to replace nested IFs with VLOOKUP

How to access field settings in a pivot table

2:05

How to access field settings in a pivot table

How to use the Quick Access Toolbar

2:59

How to use the Quick Access Toolbar

How to group a pivot table by numbers

3:08

How to group a pivot table by numbers

How to draw borders and border grids in Excel

2:50

How to draw borders and border grids in Excel

How to calculate maximum and minimum values

2:53

How to calculate maximum and minimum values

How to build a line chart

2:48

How to build a line chart

Shortcut recipe: delete blank rows

Excel Shortcuts

1:38

Shortcut recipe: delete blank rows

How to insert and delete worksheets

2:30

How to insert and delete worksheets

How to filter a pivot table with multiple filters

2:36

How to filter a pivot table with multiple filters

How to find a value in Excel

3:25

How to find a value in Excel

Shortcuts for Go To Special

Excel Shortcuts

4:22

Shortcuts for Go To Special

How to copy a pivot table without the data

2:43

How to copy a pivot table without the data

How to use named ranges with tables

2:38

How to use named ranges with tables

Anatomy of an Excel chart 2016

2:07

Anatomy of an Excel chart 2016

How to use accounting formatting in Excel

2:39

How to use accounting formatting in Excel

What is a dynamic named range

2:35

What is a dynamic named range

How to create a second pivot chart

2:15

How to create a second pivot chart

How to filter a pivot table by date

3:04

How to filter a pivot table by date

How to edit a formula

2:26

How to edit a formula

FILTER with boolean logic

Dynamic Array Formulas

2:57

FILTER with boolean logic

What is a pivot table?

2:44

What is a pivot table?

How to create a named constant

2:32

How to create a named constant

TEXTAFTER and TEXTBEFORE advanced options

Dynamic Array Formulas

3:41

TEXTAFTER and TEXTBEFORE advanced options

How to build a search box with conditional formatting

Conditional Formatting

3:34

How to build a search box with conditional formatting

How to format individual characters in Excel

2:42

How to format individual characters in Excel

How to create a custom time format

3:41

How to create a custom time format

What is a pivot chart

3:14

What is a pivot chart

How to add a second pivot chart

1:51

How to add a second pivot chart

Shortcut for entering data in more than one cell in Excel

1:14

Shortcut for entering data in more than one cell in Excel

How to chart generations with floating bars

3:37

How to chart generations with floating bars

How to use the REPT function to repeat things

2:59

How to use the REPT function to repeat things

New dynamic array functions in Excel

Dynamic Array Formulas

3:38

New dynamic array functions in Excel

How to filter chart data with a table filter

3:16

How to filter chart data with a table filter

How to select arguments with the formula tip window

1:56

How to select arguments with the formula tip window

How to build a 100% stacked area chart

3:26

How to build a 100% stacked area chart

Using Format Cells to apply font settings in Excel

2:36

Using Format Cells to apply font settings in Excel

How to find all matches at once in Excel

2:43

How to find all matches at once in Excel

How to use percentage formatting in Excel

3:03

How to use percentage formatting in Excel

How to build a simple dynamic chart

3:56

How to build a simple dynamic chart

How to use HLOOKUP

2:20

How to use HLOOKUP

How to copy and resize charts

2:13

How to copy and resize charts

How to use the CHOOSE function

3:41

How to use the CHOOSE function

How to make a self-contained pivot table

2:44

How to make a self-contained pivot table

How to use pivot table slicer styles

3:17

How to use pivot table slicer styles

SORT and SORTBY with multiple columns

Dynamic Array Formulas

3:02

SORT and SORTBY with multiple columns

Introduction to structured references

3:34

Introduction to structured references

How to plot survey data in a bar chart

3:42

How to plot survey data in a bar chart

How to revise a conditional formatting rule

Conditional Formatting

2:56

How to revise a conditional formatting rule

How Excel stores dates and times

2:44

How Excel stores dates and times

How to use text formatting in Excel

2:43

How to use text formatting in Excel

How Excel plots dates on a chart axis

3:04

How Excel plots dates on a chart axis

How to join text with numbers

3:09

How to join text with numbers

How to use table slicer options

3:06

How to use table slicer options

Don't hard code values that may change

3:09

Don't hard code values that may change

How to enter numbers as text in Excel

2:29

How to enter numbers as text in Excel

Introduction to Booleans

Dynamic Array Formulas

3:22

Introduction to Booleans

How to build a simple summary table

3:01

How to build a simple summary table

How to create a named range

3:04

How to create a named range

What's a relative reference?

2:38

What's a relative reference?

How to select visible cells only

2:33

How to select visible cells only

How to highlight rows with conditional formatting

Conditional Formatting

2:53

How to highlight rows with conditional formatting

Create a dynamic reference to a worksheet

3:28

Create a dynamic reference to a worksheet

How to work with times

2:55

How to work with times

How to use special formatting in Excel

2:58

How to use special formatting in Excel

How to sort an Excel Table

3:19

How to sort an Excel Table

How to hide and unhide columns and rows in Excel

2:31

How to hide and unhide columns and rows in Excel

How to group a pivot table by date

2:35

How to group a pivot table by date

Excel Table Options

4:06

Excel Table Options

Ways to create a chart

3:14

Ways to create a chart

How to apply a named range to an existing formula

3:00

How to apply a named range to an existing formula

Shortcuts for paste special

Excel Shortcuts

4:05

Shortcuts for paste special

How to highlight duplicates in a list

2:33

How to highlight duplicates in a list

How to create a pivot chart

2:28

How to create a pivot chart

How to modify a calculated field in a pivot table

2:16

How to modify a calculated field in a pivot table

Two-way lookup with INDEX and MATCH approximate

Conditional Formatting

3:08

Two-way lookup with INDEX and MATCH approximate

How to use exponents in a formula

2:13

How to use exponents in a formula

How to filter a pivot chart

2:11

How to filter a pivot chart

How to use VLOOKUP for wildcard matches

3:24

How to use VLOOKUP for wildcard matches

How to build a 100% stacked column chart

2:48

How to build a 100% stacked column chart

Shortcuts to hide/unhide rows and columns

Excel Shortcuts

2:53

Shortcuts to hide/unhide rows and columns

How to do in-place changes with paste special

2:36

How to do in-place changes with paste special

Shortcuts for Excel dialog boxes (Win)

Excel Shortcuts

3:08

Shortcuts for Excel dialog boxes (Win)

Create a dynamic reference to a named range

2:32

Create a dynamic reference to a named range

Formulas to query a table

3:49

Formulas to query a table

How to highlight top and bottom values

Conditional Formatting

2:45

How to highlight top and bottom values

How to use function arguments

3:08

How to use function arguments

How to use text orientation in Excel

3:08

How to use text orientation in Excel

How to convert formulas to values

2:14

How to convert formulas to values

Shortcuts to enter data

Excel Shortcuts

3:33

Shortcuts to enter data

How to look things up with INDEX and MATCH

2:48

How to look things up with INDEX and MATCH

Boolean operations in array formulas

Dynamic Array Formulas

3:14

Boolean operations in array formulas

Excel shortcuts on a Mac

Excel Shortcuts

3:22

Excel shortcuts on a Mac

How to use currency formatting in Excel

2:51

How to use currency formatting in Excel

How to add a slicer to a table

3:16

How to add a slicer to a table

Two-way summary with dynamic arrays

Dynamic Array Formulas

3:37

Two-way summary with dynamic arrays

How to use Pivot table slicer options

2:59

How to use Pivot table slicer options

How to highlight exact match lookups

Conditional Formatting

4:05

How to highlight exact match lookups

Shortcut recipe: remove specific rows

Excel Shortcuts

2:58

Shortcut recipe: remove specific rows

What is an Excel Table

3:08

What is an Excel Table

How to use division in a formula

2:06

How to use division in a formula

How to move a pivot table style to another file

1:52

How to move a pivot table style to another file

How to create a dynamic named range with OFFSET

3:39

How to create a dynamic named range with OFFSET

How to apply a border to cells in Excel

3:11

How to apply a border to cells in Excel

How to set up a running total in a table

3:44

How to set up a running total in a table

How to count unique values

Dynamic Array Formulas

3:22

How to count unique values

Shortcuts for file commands

Excel Shortcuts

2:14

Shortcuts for file commands

How to filter a pivot table by rows or columns

2:33

How to filter a pivot table by rows or columns

How to use subtraction in a formula

1:51

How to use subtraction in a formula

How to find missing values with COUNTIF

2:35

How to find missing values with COUNTIF

How to use the COUNTIFS function

3:07

How to use the COUNTIFS function

An introduction to chart axes

3:23

An introduction to chart axes

How to use table slicer styles

2:53

How to use table slicer styles

How to apply horizontal alignment in Excel

2:39

How to apply horizontal alignment in Excel

How to add unique count to a pivot table

3:27

How to add unique count to a pivot table

Basic SORTBY function example

Dynamic Array Formulas

2:48

Basic SORTBY function example

How to insert and delete cells in Excel

3:15

How to insert and delete cells in Excel

How to build a bar chart

3:23

How to build a bar chart

How to group a pivot table by age range

2:47

How to group a pivot table by age range

How to clean text with CLEAN and TRIM

2:22

How to clean text with CLEAN and TRIM

How to apply conditional formatting with a formula

Conditional Formatting

2:41

How to apply conditional formatting with a formula

How to change the chart type

2:04

How to change the chart type

How to use operators in formulas

3:21

How to use operators in formulas

How to calculate an average value

2:31

How to calculate an average value

How to create and apply a chart template

2:12

How to create and apply a chart template

How to enter a formula with cell references

2:28

How to enter a formula with cell references

Simplified formula example 401k Match

3:43

Simplified formula example 401k Match

How to rearrange fields in a pivot table

2:27

How to rearrange fields in a pivot table

How to use relative references - example 1

2:28

How to use relative references - example 1

How to convert Booleans to numbers

Dynamic Array Formulas

3:08

How to convert Booleans to numbers

How to quick sort using one column in Excel

2:36

How to quick sort using one column in Excel

How to customize a value axis

3:08

How to customize a value axis

Excel Ribbon shortcuts

Excel Shortcuts

3:02

Excel Ribbon shortcuts

How to use color scales with conditional formatting

Conditional Formatting

2:58

How to use color scales with conditional formatting

How to remove existing borders and fills in Excel

2:09

How to remove existing borders and fills in Excel

How to work with pivot chart options

3:46

How to work with pivot chart options

How to change row heights in Excel

2:29

How to change row heights in Excel

How to trap errors in formulas

3:17

How to trap errors in formulas

How to apply font formatting to a chart

2:55

How to apply font formatting to a chart

How to filter a pivot table by value

2:32

How to filter a pivot table by value

How to calculate due dates with WORKDAY

3:30

How to calculate due dates with WORKDAY

How to use the fill handle to enter data in Excel

2:09

How to use the fill handle to enter data in Excel

Shortcuts for selecting cells

Excel Shortcuts

2:27

Shortcuts for selecting cells

How to copy chart formatting

2:20

How to copy chart formatting

How to use VLOOKUP for approximate matches

2:53

How to use VLOOKUP for approximate matches

How to add a totals row to a Table

2:44

How to add a totals row to a Table

How to apply bold, italic, underlining styles in Excel

2:38

How to apply bold, italic, underlining styles in Excel

How to get nth values with SMALL and LARGE

4:01

How to get nth values with SMALL and LARGE

How Excel Table ranges work

2:56

How Excel Table ranges work

What are Dynamic Array formulas?

Dynamic Array Formulas

3:14

What are Dynamic Array formulas?

How to join values with the ampersand

2:54

How to join values with the ampersand

How to add fields to a pivot table

2:25

How to add fields to a pivot table

Ways to filter data in a chart

3:29

Ways to filter data in a chart

Pivot Table Terminology

2:56

Pivot Table Terminology

How to move data in Excel

2:44

How to move data in Excel

Working with table rows and columns

3:28

Working with table rows and columns

How to add and remove chart elements

2:40

How to add and remove chart elements

How to create a custom date format

2:54

How to create a custom date format

Intro to Boolean Logic

3:33

Intro to Boolean Logic

How to use the SUMIFS function

3:46

How to use the SUMIFS function

How to calculate the number of days between dates

3:05

How to calculate the number of days between dates

How to use pivot table layouts

3:05

How to use pivot table layouts

How to find and replace formatted values in Excel

2:51

How to find and replace formatted values in Excel

How to use fill, justify, and distributed in Excel

3:04

How to use fill, justify, and distributed in Excel

How to enter custom patterns with the fill handle in Excel

1:50

How to enter custom patterns with the fill handle in Excel

How to set formula error checking options

2:38

How to set formula error checking options

How to build a radar chart

3:02

How to build a radar chart

How to customize a category axis

3:17

How to customize a category axis

How to refresh data in a pivot table

2:41

How to refresh data in a pivot table

How to extract a first name with a helper column

3:06

How to extract a first name with a helper column

TEXTSPLIT with multiple delimiters

Dynamic Array Formulas

3:58

TEXTSPLIT with multiple delimiters

How to sort a pivot table with a custom list

2:24

How to sort a pivot table with a custom list

Basic Pivot Chart configuration

2:55

Basic Pivot Chart configuration

How to use Shrink to fit in Excel

2:42

How to use Shrink to fit in Excel

$How to use fraction formatting in Excel$

3:16

How to use fraction formatting in Excel

How to join cell values with CONCATENATE

3:03

How to join cell values with CONCATENATE

How to use a mixed reference to create a running total

2:09

How to use a mixed reference to create a running total

2:56

Chart icon controls

How to create a xy scatter chart

2:29

How to create a xy scatter chart

How to change the pivot chart type

2:10

How to change the pivot chart type

How to use VLOOKUP with a table

3:46

How to use VLOOKUP with a table

What is conditional formatting?

Conditional Formatting

2:33

What is conditional formatting?

How to generate random values

3:39

How to generate random values

FILTER function basic example

Dynamic Array Formulas

2:44

FILTER function basic example

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