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 rank values with the RANK function
How to trace formula relationships
How to fill in missing data with a simple formula
Excel Ribbon shortcuts
How to use data bars with conditional formatting
Simplified formula example 401k Match
A tour of the Excel Ribbon
FILTER function basic example
SORT and SORTBY with multiple columns
How to create an Excel Table
How to step through complex formulas using Evaluate
How to create a complex formula step by step
How to highlight exact match lookups
How to clean text with CLEAN and TRIM
How to perform a random sort
How to combine functions in a formula
How to add unique count to a pivot table
How to quickly create a pivot table
How to generate random text values
How to replace nested IFs with VLOOKUP
How to build a search box with conditional formatting
Shortcuts to hide/unhide rows and columns
How to compare two lists and highlight differences
FILTER function with two criteria
Basic SORT function example
How to see arrays in formulas
Excel shortcuts on a Mac
Basic XLOOKUP approximate match
How to create zebra stripes with conditional formatting
Why you should use a table for your pivot table
Basic SORTBY function example
How to refresh data in a pivot table
How to fill in missing data part 2
Introduction to structured references
How to use the format painter
How to make a nested IF formula easier to read
How to build a simple summary table
FILTER data between two dates
Shortcut recipe: delete blank rows
How to concatenate with line breaks
How to use VLOOKUP
How to chart generations with floating bars
