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 refresh data in a pivot table
How to quickly remove rows that have empty values
How to perform a random sort
How to drill down into a pivot table
FILTER data between two dates
How to get nth values with SMALL and LARGE
How to combine functions in a formula
If this OR that
How to create a basic chart
How to build a search box with conditional formatting
Basic XLOOKUP approximate match
How to enter custom patterns with the fill handle in Excel
How to group a pivot table by age range
Why you should use a table for your pivot table
How to use data labels
How to perform a random sort
Two-way lookup with INDEX and MATCH approximate
How to count items in a filtered list
The IF function
How to check and debug a formula with F9
Excel Ribbon shortcuts
How to create zebra stripes with conditional formatting
How to use the SUMIF function
How to make an exact copy of a formula
Charts and custom number formats
SORT and SORTBY with multiple columns
How to add unique count to a pivot table
How to add a secondary axis to a chart
Don't hard code values that may change
How to use data bars with conditional formatting
How to find missing values with COUNTIF
How to navigate a workbook
How to concatenate with line breaks
How to set up a running total in a table
30 Excel Shortcuts in 12 minutes
Basic SORTBY function example
Basic SORTBY function example
How to create a complex formula step by step
How to fill in missing data with a simple formula
SORT and SORTBY with multiple columns
How to use the COUNTIF function
How to trace a formula error
