# Excel Training videos

These videos come from our Excel video training.

### How to chart sunrise and sunset times

In this video, we'll look at how to chart average daylight hours for each month of the year, using sunrise and sunset data. This is a good example of a floating bar technique using a...
Run time: 3:49

### How to add unique count to a pivot table

In this video, we'll look at how to get a unique count in a pivot table. Pivot tables are excellent tools for counting and summing data, but you might struggle to get a unique or...
Run time: 3:25

### How to rank with a pivot table

Pivot Tables make it incredibly easy to analyze data quickly without formulas. In the example, we use a pivot table to summarize product sales by product, then assign a rank to each product...
Run time: 3:15

### How to create a running total in a Table

Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with...
Run time: 3:32

### How to use VLOOKUP with an Excel Table

This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name...
Run time: 3:40

### How to use SUMIFS with a table

In the video, we build one set of SUMIFS formulas with a table, and one set without. This makes it really easy to see the nice benefits you get when you combine tables and formulas.
Run time: 3:40

### How to query a table with formulas

Because tables support structured references, you can learn a lot about a table with basic formulas. In this video, we run through about a dozen examples. It's a nice demo of how...
Run time: 3:49

### Introduction to Structured References and Tables

In this video gives a brief introduction to structured references. Structured references is just a fancy name for formulas that use table names instead of normal cell references. This...
Run time: 3:35

### Use a throwaway chart to sanity check data

In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick, messy chart is a great way to "sanity check" unfamiliar...
Run time: 2:51

### How to use data labels in a chart

Excel charts have a flexible system to display values called "data labels". Data labels are a classic example a "simple" Excel feature with a huge range of options just...
Run time: 2:42

### Dynamic min and max with data labels

The data labels in Excel charts are flexible and powerful. While you can easily use them to display values from source data, you can also display values from other cells. The video below...
Run time: 3:14

### How to build a column chart

The video below shows how to make a basic column chart in Excel, and how you can use custom number formats with data labels to quickly streamline a chart. If you're not sure which...
Run time: 3:21

### How to chart generations with floating bars

In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special...
Run time: 3:37

### How to randomly assign people to teams

In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper...
Run time: 3:49

### Excel formula errors and fixes

In this video, we show examples of the 8 Excel formula errors you're likely to run into, and simple steps you can take to fix them. We look at #NAME?, #DIV/0!, #NUM!, #NULL!, #NA, #...
Run time: 4:22