Все публикации

0:03:49

How to chart sunrise and sunset times

0:03:27

How to add unique count to a pivot table

0:03:09

How to rank with a pivot table

0:03:44

How to create a running total in a table

0:03:46

How to use VLOOKUP with an Excel Table

0:03:35

How to use SUMIFS with an Excel Table

0:03:49

Formulas to query a table

0:03:35

Introduction to structured references

0:02:51

Use a throwaway chart to sanity check data

0:02:42

How to use data labels in a chart

0:03:15

Dynamic min and max data labels in a chart

0:03:22

How to build a column chart in Excel

0:03:37

How to chart generations with floating bars

0:03:49

How to randomly assign people to teams

0:04:22

Excel formula error codes and fixes

0:03:57

How to build a simple dynamic chart

0:03:41

How to use the CHOOSE function

0:03:39

How to generate random values

0:02:44

How to copy a pivot table without the data

0:02:52

How to group a pivot table manually

0:03:31

Calculate due dates with the WORKDAY function

0:03:16

Build friendly messages with concatenation

0:03:42

How to plot survey data in a bar chart

0:03:01

Shade groups of rows with conditional formatting