Top 5 Excel keyboard shortcuts
Podcast: Play in new window | Download
Subscribe: Spotify | TuneIn | RSS
What are your favorite Excel keyboard shortcuts? I talk about my top 5 and why I think they are useful for all analysts. The key takeaway is to stop using your mouse or trackpad on your laptop, and commit to learning these keyboard shortcuts to be more efficient and productive in Excel. My #1 Excel keyboard shortcut may surprise you since it basically goes against what I talk about in episode 1 :).
I wrote a few articles on the KeyCuts blog about keyboard shortcuts. One of the more popular ones is this one about the top 5 keyboard shortcuts in Mac Excel. A lot of people think you can only use keyboard shortcuts on the PC, but fear not–they also exist on the Mac!
In the 2nd half of the episode, I talk about some episodes from other podcasts I found interesting:
- The Changelog: Episode 205 – A protocol for dying
- The Tim Ferriss Show: Episode 353 – Patrick Collison, CEO of Stripe
- The Changelog: Episode 331 – GitHub Actions is the next big thing
- The Pylon Show: Episode 36
Trackbacks/Pingbacks
[…] able to find a few topics to build additional Excel classes about. A perennial favorite of mine, keyboard shortcuts were high on the list. Creating charts was also a big topics since most of his now students work at […]
[…] enter the data onto the slide. It was super manual work. One benefit was I got really good at using keyboard shortcuts to filter a list of data. I didn’t realize that a PivotTable could easily automate my report. […]
[…] and automations to make repetitive and tedious tasks less onerous. You could also argue that Excel shortcuts are a result of analysts being lazy and not wanting to use their mouse to do mundane formatting […]