Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our accelerated video training.
Tip: IF this OR that
In this video we look at how to combine the IF function with the OR and AND functions to test more than one condition at the same time.
Run time: 3:02
Tip: How to use the IF function
The IF function is very versatile. You can use it whenever you need to test a condition and take an action based on the result. You can even combine multiple IF statements to check multiple...
Run time: 3:08
Tip: How to change case with formulas
If you want to change case in Excel, you'll need to use the UPPER, LOWER, or PROPER functions. Together with other functions they give you the tools to transform case.
Run time: 2:59
Tip: How to create a 3D formula reference
With 3D referencing you build a reference that refers to a range of worksheets. It's an elegant way way to analyze a large number of identical worksheets with simple formulas.
Run time: 3:10
Tip: How to create a mixed reference
A mixed reference is part relative, and part absolute. Mixed references are useful when you want only part of a cell reference to change when you copy a formula.
Run time: 2:34
Tip: How to make an exact copy of a formula
Normally, when you copy a formula in Excel, relative cell references automatically change. But sometimes, you want to make an exact copy of a formula, and you don't want the references...
Run time: 2:58
Tip: How to build a complex formula step by step
Some formulas you see in Excel can be extraordinarily complex. But all complex formulas are built from simple steps. In this video, we built a more complex formula step by step.
Run time: 3:09
Tip: How to clone a pivot table
Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to quickly base one pivot table on another.
Run time: 3:11
Tip: How to group a pivot table by age range
In this video we look at how to group sample voting data into 10 year buckets, using a pivot table.
Run time: 2:47
Tip: How to quickly fill in missing data - part 2
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
Run time: 2:56
Tip: How to quickly fill in missing data
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
Run time: 3:24
Tip: How to select cells with your keyboard
Excel Pros use keyboard shortcuts to power though big worksheets with blazing speed. In this video, we look at some key shortcuts for selecting cells.
Run time: 2:09
Tip: Clever concatenation with line breaks
In this video, we show you how to join different values together in one cell with line breaks. We also demo a clever way to add spaces, commas without double quotes.
Run time: 3:17
Tip: Why VLOOKUP is better than nested IFs
In this video, we look at a few reasons why VLOOKUP is a better option than nested IF statements, when you need to assign a commission rate (or a grade) based on an arbitrary value.
Run time: 2:58
Tip: How to pick names out of a hat with Excel
In this video, we look at how to simulate a drawing and pick winners in a contest with Excel, using the RAND and RANK functions together.
Run time: 3:10

Pages

Excellent tutorial, saved me hours of work, well done.
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