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 use VLOOKUP
What's a relative reference?
Conditional formatting based on a different cell
How to use pivot table layouts
How to add a secondary axis to a chart
How to create a mixed reference
How to change case with UPPER LOWER and PROPER
How to filter a pivot table to show top values
How to show top or bottom n results
Don't hard code values that may change
Shortcut recipe: delete blank rows
Anatomy of an Excel Table
How to pick names out of a hat with Excel
How to set up a running total in a table
Formulas to query a table
How to check line length with conditional formatting
Why VLOOKUP is better than nested IFs
How to create zebra stripes with conditional formatting
Array formulas with AND and OR logic
Basic SORT function example
FILTER data between two dates
How to create 3D references
How to build a combo chart
Complex formula example 401k Match
How to add slicers to a pivot table
How to make an exact copy of a formula
New dynamic array functions in Excel
How to use drag and drop in Excel
Basic SORT function example
The UNIQUE function
Introduction to structured references
Shortcuts for Excel Tables
How to refresh data in a pivot table
How to trace a formula error
How to concatenate with line breaks
How to get nth values with SMALL and LARGE
How to build a simple dynamic chart
Use a throwaway chart to sanity check data
If this OR that
FILTER function with two criteria
The IF function
How to apply conditional formatting with a formula
