# Excel Training videos

These videos come from our Excel video training.

### How to find and highlight formulas

In this video tip, we show you three ways to find formulas in a worksheet, including a tricky way to use conditional formatting and a named formula to highlight formulas.
Run time: 3:56

### How to select visible cells only

In this video, we'll show how to select visible cells only. This is useful when you've hidden rows or columns and want to work only with cells that are actually visible.
Run time: 2:35

### How to display the number of items in a filtered list

In this video, we show you how to add a message at the top of a filtered list that displays total and visible items in the list.
Run time: 3:15

### How to use concatenation to clarify assumptions

In this video, we show you how to use concatenation and the TEXT function to clarify assumptions in a breakeven model. You can use the same approach to highlight assumptions in any model.
Run time: 3:00

### How to use conditional formatting to check line length

A short video that shows you how to use conditional formatting with the LEN function to highlight text that is too long.
Run time: 3:11

### Use the fill handle to enter data with patterns

In this short video, we show you how to use the fill handle to enter data that follows predictable patterns, like dates and numbers.
Run time: 2:05

### What is a pivot table?

What is a Pivot Table anyway? This short video answers the question by using a pivot table to analyze chocolate sales in several different ways. Learn what a pivot table is in less than 3...
Run time: 2:44

### How to make a self-contained pivot table

Each pivot table has a pivot cache, which is a true copy of the source data. In today's video tip, we look at how the pivot cache works, and how it allows you to remove the source data...
Run time: 2:30

### How to quickly create a pivot table

In this video, we show you how to create a pivot table fast.
Run time: 2:56

### How to sort a pivot table with a custom list

Pivot tables can be sorted in several ways - by rows, by columns, and by value. In today’s Exceljet tip, we show you how to sort a pivot table with a custom list.
Run time: 2:24

### Use a table for your next pivot table

If you're building a pivot table from data in an Excel worksheet, you should be using a table for the source data. In this short video, we show you how to use a table as the data...
Run time: 3:13

### How to group a pivot table by day of week

In this Exceljet video tip, we show you how to group a pivot table by day of week. We also show you how to calculate a true day name (like Sunday) using a helper table and the VLOOKUP...
Run time: 3:39

### How to highlight rows with conditional formatting

In this Exceljet tip, we show you how to highlight entire rows in a list using conditional formatting with a formula. This is a handy way to visually expose information you are interested...
Run time: 2:53

### How to quickly remove rows with empty values (Win)

In this tip, we look at a cool way to remove rows from a big list or table that contain empty values.
Run time: 2:29

### How to quickly remove rows with empty values (Mac)

In this tip, we look at a cool way to remove rows from a big list or table that contain empty values.
Run time: 2:17