Skip to main content
Login
Cart
Exceljet
Quick, clean, and to the point
Training
Videos
Functions
Formulas
Shortcuts
Blog
Excel Training Videos
Some videos from our
online training
– quick, clean, and to the point.
Complex formula example 401k Match
How to drill down into a pivot table
How to add a slicer to a table
How to generate random text values
Anatomy of an Excel Table
How to perform a random sort
How to use the format painter
How to step through complex formulas using Evaluate
How to use the CHOOSE function
FILTER data between two dates
How to build a combo chart
How to create a multi level axis
How to replace nested IFs with VLOOKUP
Shortcuts to hide/unhide rows and columns
How to build a 100% stacked column chart
How to group a pivot table manually
How to make an exact copy of a formula
How to select visible cells only
Array formulas with AND and OR logic
The UNIQUE function
Charts and custom number formats
Shade groups of rows with conditional formatting
How to highlight exact match lookups
Two-way summary with dynamic arrays
Shortcuts for Excel Tables
How to enter custom patterns with the fill handle in Excel
How to use CHAR and CODE functions
FILTER data between two dates
How to pick names out of a hat with Excel
How to get nth values with SMALL and LARGE
FILTER function with two criteria
How to create a basic Excel chart
How to apply conditional formatting with a formula
How to add slicers to a pivot table
How to create zebra stripes with conditional formatting
Pivot Table Example - IMDB Movie data
Basic XLOOKUP approximate match
How to test conditional formatting with dummy formula
Dynamic arrays are native
How to check line length with conditional formatting
SORT and SORTBY with multiple columns
Conditional formatting based on a different cell
