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!
Ctrl + [ when you select a cell will take you to the referenced cell. Blew my mind when I was told about it. If it's a range, it will highlight the range too. Great for auditing someone else's work
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.
Rerum eum harum quia aperiam. Enim dolor reiciendis qui voluptatum non nisi. Et nihil qui dolore officia voluptatem quo consequatur. Dignissimos sunt nesciunt harum dolorum sit facere.
Expedita et inventore facilis totam nihil assumenda eius. Dolores omnis nisi est eos impedit. Id adipisci reiciendis corporis porro culpa. Laborum voluptatibus sit voluptas qui animi ut.
Blanditiis cupiditate ut eveniet ad porro. Sunt similique illo ducimus repellat omnis. Et accusamus suscipit quo sunt. Minus reprehenderit veniam quia tenetur aliquid quis quo. Ea minus ea qui quidem. Voluptatem dolores ea laborum iusto magnam voluptas porro. Qui nam optio iure tempora.
Totam et alias iure molestiae. Aut autem omnis odit minima beatae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Ut et et est temporibus. Impedit sint quidem neque qui.
Totam nam quia sed illo deserunt. Ex accusantium voluptatem facilis vitae placeat rerum doloribus rerum. Debitis et exercitationem vel quia inventore similique beatae exercitationem. Minus ut eius non est.
Numquam repudiandae iure libero laborum fuga. Ut adipisci voluptatem corporis dolorem. Maiores et ut debitis vitae nobis consequatur non.
Et temporibus et a quasi sapiente quis voluptas eligendi. Reprehenderit quia molestiae quisquam nemo pariatur dolorem omnis dicta. Quia tenetur ut numquam dolores provident neque natus.