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 chart generations with floating bars
How to use CHAR and CODE functions
How to check line length with conditional formatting
How to get nth values with SMALL and LARGE
How to concatenate with line breaks
How to rank with a pivot table
How to change case with UPPER LOWER and PROPER
Why you should use a table for your pivot table
How to count items in a filtered list
FILTER data between two dates
How to create 3D references
How to build a search box with conditional formatting
How to copy a pivot table without the data
What is a pivot table?
How to use the COUNTIF function
Shortcut recipe: delete blank rows
How to plot survey data in a bar chart
Shortcuts for Excel Tables
Two-way summary with dynamic arrays
How to use VLOOKUP for approximate matches
How to build a simple dynamic chart
How to enter custom patterns with the fill handle in Excel
How to build all-in-one formulas
How to generate random values
How to use VLOOKUP with a table
Shortcuts to hide/unhide rows and columns
How to perform a random sort
How to add a secondary axis to a chart
Why VLOOKUP is better than nested IFs
How to use VLOOKUP
SORT and SORTBY with multiple columns
A tour of the Excel interface
How to filter a pivot table to show top values
What's a relative reference?
How to build a 100% stacked column chart
Basic XLOOKUP example
FILTER function basic example
How to refresh data in a pivot table
Array formulas with AND and OR logic
FILTER function basic example
Charts and custom number formats
How to check and debug a formula with F9
