Showing posts with label Microsoft Excel. Show all posts
Showing posts with label Microsoft Excel. Show all posts

Wednesday, October 7, 2026

Excel Speedrunner — Build Muscle Memory for Lightning-Fast Spreadsheets

====================== Excel & Power BI Shortcut Dojo

Shortcut Dojo

Master 65+ Excel, VBA & Power BI hotkeys

Learning Module

Set 1 of 13 (Shortcuts 1 - 5)

Overall Mastery Level 1 / 13
Step 1: Study 5 Shortcuts

Memorize these 5 shortcuts before testing your physical keyboard muscle memory:

Filtering by: All Shortcuts

Speedrunner Quiz Challenge

Test your hotkey recognition and speed against 65+ Excel, VBA, and Power BI shortcuts. Answer correctly to build up your streak!

Personal Best Streak 0
Shortcut Pool 65 Hotkeys
Shortcut updated!
===================== X Shortcut Dojo App Guide & Workflow 1. Guided Drill 2. Cheatsheet 3. Quiz GUIDED DRILL MODE 1 Study 5 Cards Memorize batch of 5 hotkeys 2 Physical Key Test Press real keys (e.g. Ctrl+Shift+0) 💡 "Show Hint" Clicked? • Marks key as "Not Learned" • Re-queues to back of set until solved Level Mastery Progress Master all 5 → Unlocks next set CHEATSHEET LIBRARY 🔍 Live Search Hotkeys... All (65) ★ Favs General Unhide selected columns Ctrl + Shift + 0 Save current workbook Ctrl + S • Click ★ star to bookmark • Copy button copies key string SPEEDRUNNER QUIZ Multiple Choice Mode Select correct combo for: "Freeze Panes" Alt + W + F Ctrl + F4 Alt + A + T Shift + F11 Gamified HUD Engine • Score tracking (+10 per hit) • Win streak counter • Best streak persistent high score

Tuesday, August 26, 2025

Filter Data Based on Active Cell Value - An illustration

Filter Data Based on Active Cell Value Press Shift + F10 → E → V. Press Shift + F10 → E → V. Press Shift + F10 → E → V. Filter Data Based on Active Cell Value Filter Data Based on Active Cell Value Filter Data Based on Active Cell Value Supposed data Supposed data Supposed data You can instantly filter your data based on the value of the cell you have selected—no need to set up a separate filter first You can instantly filter your data based on the value of the ... You can instantly filter your data based on the value of the cell you have selected—no need to set up a separate filter first illustration Patreon and LinkedIn links LinkedIn Profile /usmanzafarparacha /usmanzafarparacha /usmanzafarparacha LinkedIn Patreon profile /uzparacha /uzparacha /uzparacha Patreon Usman Zafar Paracha 1 Usman Zafar Paracha Usman Zafar Paracha It gives It gives It gives Usman Zafar Paracha 2 Usman Zafar Paracha Usman Zafar Paracha Usman Zafar Paracha 3 Usman Zafar Paracha Usman Zafar Paracha Click the cell containing the value you want to filter by (the active cell), e.g., IT Click the cell containing the value you want to filter by (th... Click the cell containing the value you want to filter by (the active cell), e.g., IT Excel will filter the table to show only the rows where Department = IT Excel will filter the table to show only the rows where Depar... Excel will filter the table to show only the rows where Department = IT This is an easy way to filter data without manually setting filter dropdowns! This is an easy way to filter data without manually setting f... This is an easy way to filter data without manually setting filter dropdowns! Excel example data Excel example data IT Selecting the active cell Selecting the active cell Selecting the active cell Excel example data filtered