Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our Excel video training.
Tip: 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
Tip: 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
Tip: 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
Tip: 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
Tip: 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
Tip: How to quickly create a pivot table
In this video, we show you how to create a pivot table fast.
Run time: 2:56
Tip: 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
Tip: 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
Tip: 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
Tip: 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
Tip: 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
Tip: 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
Tip: How to quickly remove blank rows (mac)
A really fast way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Run time: 2:15
Tip: How to quickly remove blank rows (win)
A cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Run time: 2:17
Tip: How to move around big lists fast
A handy shortcut for hopping around large lists or tables. Much faster than scrolling.
Run time: 2:37

Pages