facebook pixel
These Excel shortcuts saved me 10+ hours a week when I was working in Investment Banking. 1. Ctrl + Page Up / Page Down: Move between worksheets instantly without touching your mouse. 2. Ctrl + Arrow Keys: Jump across large datasets instantly without scrolling. 3. Ctrl + Shift + Arrow Keys: Select entire ranges of data in one move. 4. F4: Toggle absolute and mixed references when building formulas. 5. F7: Run spell check across the worksheet. 6. Ctrl + [: Jump straight to the cell driving a number. 7. Ctrl + ]: Jump to cells that depend on the selected value. 8. Ctrl + 1: Open Format Cells and adjust number formatting. 9. Alt + =: AutoSum selected ranges quickly. 10. Ctrl + Shift + L: Turn filters on or off for a dataset. Learning shortcuts like these won’t make you a great banker by itself, but they will make you much faster in Excel. #excelshortcuts #exceltips #investmentbanking #financialmodeling #wallstreet

 23.2k

 413

 5

 23.2k

    Suggested Credits
    Tags, Events, and Projects