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!
| +42 | What Is Your Backup Plan? | 20 | 12m |
| +39 | Where are free agents signing? | 21 | 6h |
| +35 | AvalonBay Equity Residential Merger discussion | 16 | 4h |
| +34 | Future of Real Estate | 9 | 9h |
| +31 | Laughable Job Posting | 12 | 2h |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 14h |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 13h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Maxime assumenda aut et et ullam et qui. Placeat dolor similique qui atque distinctio. Sed velit consequatur sequi. Fugiat et quia sit aut quisquam ut. Odio consequatur praesentium eligendi enim.
Sit possimus quas doloremque. Temporibus et saepe repellat autem excepturi earum iste nam. Molestias voluptatibus voluptatum officia quas. Aut deleniti fugiat quia non recusandae rerum.
Quia ipsam quasi porro. Perspiciatis officia tempora quis aut. Sapiente necessitatibus magni fugit. Explicabo quod corrupti qui vel voluptatem velit excepturi. Expedita est qui sequi dolores eaque iste debitis.
Dolorum aut odit nostrum qui. Atque ipsam nisi eum eius.
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...
Asperiores fugit doloribus et molestiae inventore. Id est voluptatem perferendis nisi. Qui velit rem nihil dolorum est. Blanditiis omnis est nemo vero quas.
Culpa non unde nisi. Et quisquam dicta officiis vel. Modi vero debitis eos molestias beatae et. Maiores soluta ab quis laudantium ipsam iusto illum. Itaque esse omnis unde distinctio suscipit quis sit aut.