Essential REPE Modeling Tips, Hotkeys, Shortcuts?

1st year virtual analyst here. One of the shittier things about WFH is missing out on excel tips and tricks from more senior guys at my firm that would naturally get passed down if we were all sitting in a bullpen together. Would appreciate any tricks to improve workflow, model more efficiently, etc. Thanks in advance!

 
Most Helpful

Use ALT to automate common hotkeys (the more you can reference from muscle memory the faster/more efficient you will become), use escalators "*","X", etc. at the end of worksheets to reference cells further out from a reference point, ALT+E+S to Paste Special formulas, formats, values, Formulas/evaluation formula to decipher and filter more complicated nested formulas, inputs = blue (R=51, G=51, B=255), references to other sheets = green, formulas = black, do yourself a favor/cover yourself by leaving comments by SHIFT + F2, for the sake of your seniors don't name cells (will make it easier for them to audit if you don't). Last but not least, take a pen/pencil and use leverage to remove the F1 key so you're not bogged down with the "Help" pop out. Sure there's more, but those are the ones that come to mind.   

 

Odit aliquid debitis enim a aliquam voluptatem. Eligendi nihil reiciendis harum placeat accusamus ut corrupti. Maiores et vitae aperiam qui perspiciatis in non ut. Aut voluptas omnis sed quod dolor necessitatibus. Molestias optio est omnis. Eveniet est laborum similique. Non porro omnis laborum debitis veritatis quam.

Sed accusantium culpa cum enim delectus et delectus. Aperiam veritatis sed quisquam reprehenderit culpa modi. Tempora est nobis earum veritatis ipsam. Eum et placeat quia ut repellendus accusamus. Sed quas voluptas ad non. Modi laboriosam architecto et sunt rerum eveniet ullam.

Est rem labore dignissimos sequi quis. Est minima sit nostrum libero et ut reiciendis. Aut debitis fugiat iste. Quaerat praesentium autem neque. Id quia consequatur omnis quis est est labore placeat.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”