# Excel tips: formulas

These videos come from our Excel video training.

### 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

### 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

### 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 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

### How to build a simple dynamic chart

In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart...
Run time: 3:56

### How to use the CHOOSE function

In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated...
Run time: 3:41

### How to generate random values

In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and...
Run time: 3:39

### Calculate due dates with the WORKDAY function

This video show how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. You can use WORKDAY to calculate intelligent ship dates, delivery dates, and completion dates that...
Run time: 3:40

### How to plot survey data in a bar chart

In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for...
Run time: 3:42

### Shade groups of rows with conditional formatting

In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows,...
Run time: 3:01

### How to highlight approximate match lookups

In this video we show how to highlight approximate match lookups with conditional formatting and the LOOKUP function. Highlighting approximate matches is tricky, because you must replicate...
Run time: 3:55

### Two-way lookup with INDEX and MATCH approximate

In this video, we'll look at how to build a two-way lookup with INDEX and MATCH, using approximate matching. This is a classic solution for non-exact lookups like income tax, shipping...
Run time: 3:10