Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our Excel video training.
Tip: How to build all-in-one formulas
This video shows you how to build a more complex formula using helper formulas, then bring them all together in a single, all-in-one formula at the end.
Run time: 3:45
Tip: How to use the SUMIF function
The SUMIF function sums numbers conditionally: sales of red sweaters, revenue from Texas, hours billed on project X. See how it works in this short video.
Run time: 3:43
Tip: How to use the COUNTIF function
The COUNTIF function is incredibly useful when you want to count things like overdue invoices, employees in Engineering, or orders over $100. Learn how to use it in this short video.
Run time: 3:02
Tip: How to trace a formula error in Excel
Sometimes, you open a spreadsheet and see errors everywhere! Fortunately, Excel contains a cool tool that can automatically trace errors, and pinpoint the exact source.
Run time: 2:29
Tip: How to compare two lists and highlight differences
In this video, we look at how to compare two lists using conditional formatting. This is a great way to visually highlight different or missing items in a list.
Run time: 2:27
Tip: How to create zebra stripes with conditional formatting
In this video, we look at how to use conditional formatting, with a formula, to shade every other row in a table. This is sometimes called "zebra striping", and it's a cool...
Run time: 3:29
Tip: How to make conditional formatting variable
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer...
Run time: 2:42
Tip: How to apply conditional formatting with a formula
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to make more powerful conditional formatting rules.
Run time: 2:41
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

Pages

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
Video training for Excel Tables