50 Ultimate Excel Tips and Tricks for 2020: Excel learning resource
50 Ultimate Excel Tips and Tricks for 2020
Extracted from saved YouTube search results - titled "50 Ultimate Tips and Tricks for", filed under Shortcuts Productivity. It's a video from Sele Training — use it to practice Navigation shortcuts and Selection and editing shortcuts.
What to practice while watching
- Navigation shortcuts
- Selection and editing shortcuts
- Quick Access Toolbar
Recommended learning path
Start by watching the lesson once without pausing, then reopen Excel and rebuild the example with your own small dataset. Save one clean practice workbook before moving to the next topic.
Source details
- Channel: Sele Training
- Format: video
- Level: Beginner
- Topic: Shortcuts & Productivity
- Listing source: saved YouTube search capture, filed by topic
Go deeper with this skill
Save time by making common Excel actions faster without sacrificing accuracy. For this article, the goal is to practice: Extracted from saved YouTube search results - titled "50 Ultimate Tips and Tricks for", filed under Shortcuts Productivity. It's a video from Sele Training — use it to practice Navigation shortcuts and Selection and editing shortcuts.
Practice workbook setup
Open a practice workbook with at least one data table, formulas, and a report area.
Practice workflow
- Pick five shortcuts that match work you do every week.
- Practice each shortcut in a real workflow, not in isolation.
- Combine navigation, selection, and formatting shortcuts into one repeated routine.
- Write the shortcuts on a small reference sheet until they become muscle memory.
Quality checks
- Speed improvements do not create accidental edits.
- You can undo or review the result after each shortcut-heavy action.
- The shortcut works in your Excel version and operating system.
Common mistakes
- Trying to memorize too many shortcuts at once.
- Using shortcuts faster than you can verify the selected range.
- Assuming Windows and Mac shortcuts are identical.
Next actions
- Choose one weekly task and time it before and after practicing shortcuts.
- Build a personal top-10 shortcut list by workflow, not alphabetically.
Formula focus: even if this workflow is not formula-heavy, add one check cell that confirms the final output still matches the source data.
