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.
FILTER function basic example
How to quickly remove rows that have empty values
Shade groups of rows with conditional formatting
How to use pivot table layouts
How to generate random values
Excel formula error codes
How to replace nested IFs with VLOOKUP
How to step through complex formulas using Evaluate
Anatomy of an Excel Table
Basic SORT function example
How to create a formula with nested IFs
The UNIQUE function
How to build a simple dynamic chart
How to calculate and highlight expiration dates
SORT and SORTBY with multiple columns
How to fill in missing data part 2
How to refresh data in a pivot table
How to count unique values
How to create a multi level axis
How to build a simple summary table
Basic XLOOKUP example
How to generate random text values
Two-way lookup with INDEX and MATCH approximate
Use a throwaway chart to sanity check data
How to navigate a workbook
What is a pivot table?
How to enter custom patterns with the fill handle in Excel
How to create 3D references
How to build a combo chart
How to use VLOOKUP to merge tables
Conditional formatting based on a different cell
How to perform a random sort
How to use VLOOKUP
What is conditional formatting?
List duplicate values with FILTER
How to check and debug a formula with F9
How to rank values with the RANK function
How to use SUMIFS with an Excel Table
How to use the CHOOSE function
Basic SORTBY function example
How to add slicers to a pivot table
How to chart sunrise and sunset
