My productive Excel keyboard shortcuts
Let's be friends:
📸 My Instagram - / andrewtoh93
More shortcuts here for you
0:00 Introduction to Excel keyboard shortcuts
0:32 Why bother?
1:40 My OFP framework to speed up my work
3:58 My favourite keyboard shortcuts - Navigation
--- 5:42 Ctrl + Arrow keys to go to the end of a range of values
--- 6:44 Ctrl + Page Down/Up to switch tabs
--- 7:20 Ctrl + Space a column of numbers for quick data analysis
--- 7:54 Alt + AT to enable table filters
--- 8:41 Alt + Down Arrow, E and Spacebar to use table filters
9:58 My favourite keyboard shortcuts - Editing Data
--- 10:10 Ctrl Shift "+" to add a new column
--- 10:35 F2 to edit cell values or formula
--- 11:22 Ctrl + D to copy down a cell formula
12:11 Write an Index-Match formula using keyboard shortcuts
13:53 Find the unique number of values in a column
15:10 Should we still use the mouse?
18:07 How I started using keyboard shortcuts
Index Match formula: https://exceljet.net/index-and-match
Use the Windows Keyboard Shortcut Alt + Underline: https://www.lifewire.com/windows-keyb...
Carnac software to show keys onscreen: https://blogs.articulate.com/rapid-el...
Where I got these HDB datasets: https://data.gov.sg/dataset/resale-fl...
More HDB Property Information (with max floor): https://data.gov.sg/dataset/hdb-prope...
About public housing in Singapore: https://en.wikipedia.org/wiki/Public_...