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 perform a random sort
How to use VLOOKUP with a table
How to generate random text values
How to find and highlight formulas
What is conditional formatting?
How to trace formula relationships
How to fill in missing data with a simple formula
How to create a complex formula step by step
How to create an Excel Table
Filter with dynamic dropdown list
How to drill down into a pivot table
How to create a basic Excel chart
Complex formula example 401k Match
How to highlight exact match lookups
How to do a two-way lookup with INDEX and MATCH
How to rank values with the RANK function
How to use a slicer with multiple pivot tables
How to build all-in-one formulas
Excel formula error codes
How to quickly remove rows that have empty values
Pivot Table Example - IMDB Movie data
Array formulas with AND and OR logic
How to look things up with INDEX
How to calculate and highlight expiration dates
How to perform a random sort
What is an array?
How to add unique count to a pivot table
How to count unique values
Dynamic min and max data labels
How to use the SUMIF function
A tour of the Excel interface
How to use the MATCH Function for exact matches
Excel shortcuts on a Mac
How to clone a pivot table
How to generate random times
How to see arrays in formulas
Conditional formatting based on a different cell
How to generate random values
How to undo and redo changes in Excel
SORT and SORTBY with multiple columns
How to get nth values with SMALL and LARGE
How to use drag and drop in Excel