notbadjuju
Jan 24
1.1K
31K
43
32.7%
Excel modeling shortcuts you NEED to know for investment banking and private equity. My go-to shortcuts from 5+ years on Wall Street! 1. ‘Alt + W + V + G’ removes gridlines — this should always be your first step when opening a new file or tab! 2. ‘Alt + I + S’ inserts a new tab. ‘Alt + I + C’ inserts a new column. ‘Alt + I + R’ inserts a new row. 3. ‘F2’ opens a cell so you can edit values, formulas, and more. 4. ‘Ctrl + `’ lets you view formulas/inputs in each cell — ideal for auditing and finding errors. 5. ‘Ctrl + Pg Up/Down’ navigates between tabs without clicking. 6. ‘Alt + H’ opens the Home ribbon, packed with essential formatting functions. 7. ‘Alt + H + F + C’ changes font colors; well-made models use color-coding for easy reference and organization. 8. ‘Alt + H + C + P’ copies the file path to your clipboard for easy saving. 9. ‘Ctrl + S’ saves your file — do this regularly to avoid losing work to Excel crashes!
notbadjuju
Jan 24
1.1K
31K
43
32.7%
Cost:
Manual Stats:
Include in groups:
Products:
