Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our accelerated video training.
Tip: How to use a slicer for multiple pivot tables
In this video, we look at how to configure a slicer to control more than one pivot table at once. This technique is often used when building dashboards.
Run time: 2:29
Tip: What's a slicer and how to add one to a pivot table
In this video, we look how slicers filter data in a pivot table and how to easily add a slicer to a pivot table.
Run time: 3:16
Tip: Pivot tables and movie data
A simple example of how you can use pivot tables to analyze all kinds of data, not just sales data. We look at the top 250 movies from IMDB from 2014.
Run time: 2:28
Tip: What's up with Pivot Table Layouts?
Puzzled by Pivot Table layouts? Wonder what the differences and tradeoffs are in each layout? This video is for you!
Run time: 3:05
Tip: How to calculate expiration dates
How to generate an expiration date in the future, how to calculate "days remaining", and how to highlight rows that are expired or expiring soon with conditional formatting.
Run time: 3:54
Tip: How to rank values with the RANK function
The RANK function gives you a way to rank values with a simple function that will dynamically calculate rank. If any value changes, you'll get a new rank automatically.
Run time: 2:59
Tip: How to use the CODE and CHAR functions
A short introduction to the CODE and CHAR functions, two geeky (but surprisingly useful) functions that help you manipulate text in Excel.
Run time: 3:04
Tip: 23 formula tips to save you time today
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list...
Run time: 11:16
Tip: How to trace formula relationships
In this video, we look at how to quickly find formulas and trace relationships, using the concept of precedents and dependents. A great way to quickly understand an unfamiliar worksheet.
Run time: 3:13
Tip: How to do a two-way lookup with INDEX and MATCH
In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions...
Run time: 3:17
Tip: How to look things up with INDEX
In this video, we look at how to configure INDEX to fetch a value by row and column. This is half of the INDEX/MATCH equation.
Run time: 2:48
Tip: How to use the MATCH Function for exact matches
In this video, we look at how the MATCH function can find the position of an item in a list. Once you have a position, you can use it to get related values with INDEX.
Run time: 3:23
Tip: How to use VLOOKUP for approximate matches
In this video, we look at how to configure VLOOKUP to look up values based on an approximate match. This is good for things like tax rates, postage, grades, and commissions.
Run time: 2:52
Tip: How to use VLOOKUP
In this video, learn how to use VLOOKUP to build a simple form to extract employee information from a table, in about 3 minutes.
Run time: 3:10
Tip: How to clean text with TRIM and CLEAN
When you bring data into Excel you sometimes end up with extra spaces and line breaks. This short video shows you how to clean things up with TRIM and CLEAN.
Run time: 2:35

Pages

You guys really have helped me grow with my excel and overall Microsoft suite confidence. I'm considered the excel guru at work now and have shown tons of people your site. -Matthew
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course