Useful Shortcuts

Based on the most helpful WSO content, here are some useful shortcuts that can be super handy but might be a bit lengthy or prone to errors if not practiced:

1. Excel:

   • Alt + E + S: Paste Special. This sequence can be a bit long and if you hit the wrong key in the sequence, you might end up doing something completely different.
   • Ctrl + Shift + %: Percentage formatting. It's a three-key combo that needs to be pressed simultaneously, which can be tricky at times.
   • Alt + H + O + I: Auto fit column width. This one is a sequence of keys that needs to be pressed in order, and missing one can lead to confusion.

2. PowerPoint (PPT):

   • Alt + 4 + E: This is a shortcut mentioned for adding an email button to the quick access toolbar in PowerPoint. It's not a default shortcut, so it requires customization and remembering the sequence can be challenging.

3. Financial Modeling Software (e.g., FactSet, CapIQ):

   • Custom Excel Plugin Shortcuts: These can vary depending on the plugin (e.g., FactSet, CapIQ, Macabacus, Turbo) and require setting up. They can be long and specific to the functions you customize.

Remember, the key to mastering these shortcuts is consistent practice. The more you use them, the more they'll become second nature, and the less likely you'll be to get them wrong. Keep in mind that some shortcuts may require customization and may not be default shortcuts in Excel or PowerPoint.

Sources: Common Hotkeys - What do you use?, Favorite Excel Shortcut(s)?, Tips to crank out work really fast, How to be the Best Analyst, Q&A: Consistent Top Bucket IB Analyst