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:22

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

03:23

Excel shortcuts on the Mac - key differences

03:03

How to drive the ribbon with your keyboard

03:17

Shortcuts for Excel Tables

03:33

Shortcuts to enter data in Excel

02:53

Shortcuts to hide/unhide rows and columns

05:09

How to learn more Excel Shortcuts

12:10

The power of Excel shortcut recipes

21:46

30+ Popular Excel shortcuts

04:02

How to get nth values with SMALL and LARGE

09:19

23 formula tips to save you time today

08:22

How to build a complex formula (or not)

11:04

How to build logical formulas

16:18

5 ways to use VLOOKUP

03:44

How to build all in one formulas

03:43

How to use the SUMIF function

03:03

How to use the COUNTIF function

02:29

How to trace a formula error in Excel

02:29

Compare two lists and highlight differences

03:30

How to create zebra stripes with conditional formatting

02:43

Conditional formatting with one variable input