THE TIPS PACK
Drill the 15 shortcuts until they stick — plus fourteen more Excel files. Free, instant, yours to keep.
What’s in the pack
Free, instant, and yours to keep.
No spam, ever. Unsubscribe with one click.
One practical Excel tip a week.
Watch the 10-minute video or use the list below. The practice file is in the free pack above.
You don’t need to memorise every shortcut, just these. They cover the things you do all day: selecting, moving around, formatting and writing formulas. On a Mac, use Cmd in place of Ctrl for most of them.
Type one example of what you want, such as the city name from a City PIN column, then press Ctrl+E. Excel spots the pattern and fills the rest.
Click any cell in your data and press Ctrl+Shift+L to add filter arrows to every header. Press it again to remove them.
Click inside the data, press Ctrl+T (or Ctrl+L), check My table has headers and press Enter.
Opens the Format Cells box for number formats, alignment, borders and fill, without hunting through the ribbon.
Selects every connected cell around the active cell. Safer and faster than dragging across thousands of rows.
Ctrl+Shift+Down selects from the current cell to the last filled cell in the column. Ctrl+Shift+Right does the same across a row.
Ctrl+Down jumps to the bottom of the data without selecting anything. Ctrl+Up takes you back to the top, Ctrl+Right to the far right.
While typing a formula, click a cell and press F4 to add dollar signs ($D$4) so it doesn’t move when you copy the formula. Press again to cycle through the other locking options.
Puts the cursor at the end of the cell’s contents, so you can add to it instead of typing over it.
Move to the next or previous worksheet tab without the mouse.
Select a range starting with the cell to copy. Ctrl+R fills it to the right, Ctrl+D fills it down. Works for text and formulas.
Click the empty cell under a column of numbers and press Alt+= to write the SUM formula. Press Enter.
Opens Paste Special, so you can paste only values, formulas, formats or comments, for example results without the formulas behind them.
In the formula bar, select part of a formula (such as a MAX inside a VLOOKUP) and press F9 to see its result. Press Ctrl+Z to get the formula back.
Type First quarter, press Alt+Enter, then type Revenue. You get a two-line header without widening the column.
YOUR NEXT STEP
None of these takes more than a minute to learn, and each one pays for itself the first time you need it. That’s the whole category — small things nobody teaches you, that quietly decide whether Excel is a chore or a tool. The course is a hundred more of them, taught the same way.
30-day money-back guarantee, handled by Udemy. No forms, no questions.
★★★★★ Join 80,000+ students
Andreas Exadaktylos · Microsoft-certified Excel instructor · mellontraining.com
WATCHING ON YOUTUBE?
11 step-by-step courses on Excel, Power BI, Python and AI, all on Udemy with lifetime access.
