Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our accelerated video training.
Tip: How to make a nested IF formula easier to read
By their nature, nested IF formulas are hard to read. In this video, we show you how to easily make a nested IF formula more readable, by adding line breaks.
Run time: 3:10
Tip: How to evaluate complex formulas
In this video, we look at how to use Evaluate Formula to solve complex formulas one step at a time. It's a great way to understand how Excel solves a formula.
Run time: 3:18
Tip: How to check and debug a formula with F9
In this brief video, we look at how to debug a formula using the F9 key. If you work with formulas a lot, this is one of the most useful skills you can learn.
Run time: 3:10
Tip: Is the format painter worth your time? Yes.
A quick video overview of the Format Painter, which transfers formatting to one group of cells to another with a single click.
Run time: 3:13
Tip: How to build a search box to highlight data
In this video, we use conditional formatting to create an interactive search box to highlight data. This is a nice alternative to filtering, because the information you're looking is...
Run time: 3:35
Tip: How to use drag and drop to move things around
Did you know you can use drag and drop in Excel? It's true. Drag and drop is an alternative to copy and paste, and it can be really handy (and fun) in certain situations.
Run time: 1:51
Tip: How to use VLOOKUP instead of nested IFs
In this short video, we look at how to replace a typical nested IF formula with a VLOOKUP formula. Compared to nested IF statements, VLOOKUP is simpler and more transparent.You can change...
Run time: 3:57
Tip: 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
Tip: 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
Tip: 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
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

Pages

Your SUBSTITUTE formula for cleaning up phone numbers works perfectly, and saves a TON of time - thank you so much! - Janet
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