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.
How to select visible cells only
Two-way lookup with INDEX and MATCH approximate
How to use VLOOKUP to merge tables
How to create a basic chart
Shade groups of rows with conditional formatting
How to create an Excel Table
What is an array formula?
Pivot Table Example - IMDB Movie data
Why you should use a table for your pivot table
How to highlight rows with conditional formatting
How to create a mixed reference
How to build a column chart
The IF function
How to add a slicer to a table
How to group a pivot table by age range
How to clone a pivot table
How to build a simple summary table
How to quickly remove rows that have empty values
Filter with dynamic dropdown list
Shortcut recipe: delete blank rows
How to test conditional formatting with dummy formula
What is a pivot table?
How to use pivot table layouts
New dynamic array functions in Excel
The UNIQUE function
Shortcuts for paste special
How to concatenate with line breaks
FILTER function with two criteria
How to filter a pivot table to show top values
How to use data labels
How to highlight approximate match lookups
A tour of the Excel Ribbon
How to customize a value axis
SORT and SORTBY with multiple columns
Excel formula error codes
Dynamic min and max data labels
How to replace nested IFs with VLOOKUP
SORT and SORTBY with multiple columns
How to undo and redo changes in Excel
Dynamic arrays are native
How to calculate and highlight expiration dates
How to build a 100% stacked column chart