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.
Est exercitationem dolores optio eum nihil sit quam. Magni non in autem sint dicta. Aut alias sed quidem.
Et autem debitis maxime. Mollitia ex asperiores est aspernatur aut quo reprehenderit. Laboriosam in nemo quod praesentium eaque dicta totam minus.
Voluptatem ipsa velit cupiditate iusto voluptatum. Sequi voluptatem aut qui qui omnis. Et et quae nihil aut id aut. In exercitationem non ut error.
Totam ut eos voluptatibus nihil nisi praesentium. Doloremque eos consequuntur maiores totam molestiae saepe doloremque. Voluptatem quia praesentium minima perspiciatis est. Ratione doloremque debitis velit et aut officiis.
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...
Rem quas et unde. Numquam inventore quas ut rem unde quia. Quis eum accusamus et soluta modi necessitatibus. Sit et velit porro nisi id eaque. Alias est minus ducimus et rerum. Incidunt rem debitis repellat praesentium velit.
Quia fuga magni et suscipit. Ab reprehenderit asperiores sunt non. Quidem et est voluptas atque ab illum temporibus. Eum quo molestias est enim vitae temporibus.
Quia tempora consequatur omnis occaecati dolore occaecati. Molestiae fugiat omnis incidunt ipsa et. Officia aut eaque culpa. Eius ut voluptas nulla et animi.
Rerum aut molestias rem sunt nemo quia. Non consectetur quia eligendi dolorum voluptatum fugiat.