03:31

How to add a slicer to an Excel table

02:53

How to use named ranges with Excel tables

03:24

Data validation with an Excel table

03:24

Conditional formatting formula in an Excel table

03:35

How to use INDEX and MATCH with an Excel table

03:51

How to copy and lock structured references in an Excel table

03:08

Excel structured references inside a table

03:48

Excel structured reference syntax examples

03:09

How to remove duplicates from an Excel table

02:59

How to add a totals row to an Excel Table

03:33

How to sort an Excel Table

03:43

How to use Excel Table filters

03:09

How Excel Table ranges work

03:42

Working with table rows and columns in Excel

03:03

How to use Calculated Columns in Excel

04:21

Excel Table Options

03:22

How to remove an Excel Table

02:57

Anatomy of an Excel Table

03:22

How to create an Excel Table

03:30

What is an Excel Table?

03:49

How to chart sunrise and sunset times

03:27

How to add unique count to a pivot table

03:09

How to rank with a pivot table

03:44

How to create a running total in a table

03:46

How to use VLOOKUP with an Excel Table

03:35

How to use SUMIFS with an Excel Table

03:49

Formulas to query a table

03:35

Introduction to structured references

02:51

Use a throwaway chart to sanity check data

02:42

How to use data labels in a chart

03:15

Dynamic min and max data labels in a chart

03:23

How to build a column chart in Excel

03:37

How to chart generations with floating bars

03:49

How to randomly assign people to teams

04:22

Excel formula error codes and fixes

03:57

How to build a simple dynamic chart

03:41

How to use the CHOOSE function

03:39

How to generate random values

02:44

How to copy a pivot table without the data

02:52

How to group a pivot table manually

03:31

Calculate due dates with the WORKDAY function

03:16

Build friendly messages with concatenation

03:42

How to plot survey data in a bar chart

03:01

Shade groups of rows with conditional formatting

01:47

Shortcut Recipe Remove Blank Rows

03:55

How to highlight approximate match lookups

12:22

30+ Excel Shortcuts in 12 minutes

03:08

Two-way lookup with INDEX and MATCH approximate

04:05

How to highlight exact match lookups

03:44

Simplified formula example 401k Match

03:18

Complex formula example - 401k Match

03:33

How to use boolean logic in Excel formulas

03:02

How to build a simple summary table

02:46

How to combine functions in a formula

03:28

How to test conditional formatting with dummy formulas

04:06

Paste Special Shortcuts

02:36

How to find missing values with COUNTIF

03:16

How to create a formula with nested IFs

03:11

How to group a pivot table by day of week

03:10

Don't hard code values that may change