Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our Excel video training.
Tip: How to combine functions in a formula
Combining functions is a core skill you *must* have in order to move beyond the basics in Excel. In this video, we show how to split, manipulate, and reassemble values using multiple...
Run time: 2:53
Tip: Perfect conditional formatting with dummy formulas
Conditional formatting with formulas can be tricky because you can't see what happens to the formula when the rule is applied. Dummy formulas let you visualize how formulas will behave...
Run time: 3:28
Tip: Paste Special Shortcuts
Despite the boring name, Paste Special is actually a gateway into a hidden world of powerful features. This video shows how to access Paste Special features using keyboard shortcuts.
Run time: 4:05
Tip: How to find missing values with COUNTIF
In this video, we use COUNTIF to compare lists and count values that belong to both lists. We also "flip" the formula to count values in one list that are missing on the other.
Run time: 2:35
Tip: How to make a nested IF formula
Nesting is a powerful tool, but once you combine more than a couple IFs, the logic can start to look like spaghetti quickly :) The trick is to keep things organized. In this video, Dave...
Run time: 3:15
Tip: Don't hard code assumptions into your formulas
One of the biggest mistakes you can make is to hard code assumptions into your formulas. Instead, if a value might change, put it in a cell and refer to it with a reference, as explained in...
Run time: 3:09
Tip: Excel shortcuts on the Mac - key differences
In this video, we look at 5 key differences between Excel shortcuts on Mac and shortcuts in Windows Excel. If you use Excel on a Mac, be sure to check this out.
Run time: 3:22
Tip: How to drive the ribbon with your keyboard
Why is the Excel ribbon cool? Because it gives you a way to use nearly every feature in Excel without touching the mouse. Watch this video to learn how.
Run time: 3:02
Tip:  Shortcuts for Excel Tables
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Run time: 3:16
Tip: Shortcuts to enter data in Excel
Did you know you can use shortcuts to control the direction Excel moves when you press Enter? In this video, learn a boatload of shortcuts for entering data in Excel.
Run time: 3:33
Tip: Shortcuts to hide/unhide rows and columns
In this video, we look at the shortcuts you can use to hide and unhide both columns and rows. These are very handy for hiding data you don't need to see, and just a taste of Excel...
Run time: 2:53
Tip: How to get the Nth largest or smallest
In this video, we look at how to use the SMALL and LARGE functions to get the nth value from a data set. You can use these functions to get the top 3 test scores, top 5 fastest times, and...
Run time: 4:01
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

Pages