Excel Keyboard Shortcuts 2
TOC
EXCELJET
Productivity
How to move around big lists fast (win)
Use the fill handle to enter data with patterns
How to use drag and drop to move things around
Is the format painter worth your time? Yes.
How to select cells with your keyboard
How to quickly fill in missing data - part 2
Pivot Tables
How to group a pivot table by day of week
Use a table for your next pivot table
How to sort a pivot table with a custom list
How to make a self-contained pivot table
How to group a pivot table by age range
What is a pivot table?
How to quickly create a pivot table
How to clone a pivot table
Lists
How to quickly remove blank rows (win)
How to quickly remove blank rows (mac)
How to quickly remove rows with empty values (Mac)
How to quickly remove rows with empty values (Win)
How to display the number of items in a filtered list
How to select visible cells only
Formulas
How to use concatenation to clarify assumptions
How to use VLOOKUP instead of nested IF statements
How to check and debug a formula with F9
How to evaluate complex formulas
How to make a nested IF formula easier to read
How to pick names out of a hat with Excel
Why VLOOKUP is better than nested IFs
Clever concatenation with line breaks
How to quickly fill in missing data
How to build a complex formula step by step
How to make an exact copy of a formula
How to create a mixed reference
How to create a 3D formula reference
How to change case with formulas
How to use the IF function
IF this OR that
How to clean text with TRIM and CLEAN
How to look things up with INDEX
How to do a two-way lookup with INDEX and MATCH
Conditional Formatting
How to highlight rows with conditional formatting
How to use conditional formatting to check line length
How to find and highlight formulas
How to build a search box with conditional formatting
Video
Tips
These tips come from our
library of bite-sized training videos.