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 filter a pivot table to show top values
How to create a mixed reference
How to add a slicer to a table
Shade groups of rows with conditional formatting
Pivot Table Example - IMDB Movie data
How to set up a running total in a table
What is an array formula?
How to clone a pivot table
Introduction to structured references
How to group a pivot table manually
How to step through complex formulas using evaluate
Why you should use a table for your pivot table
How to replace nested IFs with VLOOKUP
How to create a complex formula step by step
Two-way lookup with INDEX and MATCH approximate
New dynamic array functions in Excel
Don't hard code values that may change
Basic XLOOKUP example
How to build a search box with conditional formatting
Simplified formula example 401k Match
How to build a 100% stacked column chart
How to highlight rows with conditional formatting
How to perform a random sort
Spilling and the spill range
How to pick names out of a hat with Excel
How to count unique values
How to generate random dates
What is an Excel Table
How to use the SUMIF function
How to use pivot table layouts
How to generate random times
How to rank values with the RANK function
How to use VLOOKUP with a table
Use a throwaway chart to sanity check data
Unique values with criteria
Dynamic min and max data labels
How to concatenate with line breaks
How to see arrays in formulas
How to find missing values with COUNTIF
How to create a multi level axis
How to navigate a workbook
Conditional formatting based on a different cell
