Becoming a god at Excel
I'm gonna be straight up. I'm not too good with Excel right now. How did you guys become Gods at Excel, and what would you recommend for me to do to get better?
I'm gonna be straight up. I'm not too good with Excel right now. How did you guys become Gods at Excel, and what would you recommend for me to do to get better?
Career Resources
It’s super cliche but it’s the truth, don’t use a mouse ever. When I summered at the bank I’m at now the analyst I was helping took my mouse from my computer and told me to build a model. I thought he was a douche, but looking back it was one of the best things to happen in my career.
Before anyone asks I looked up the shortcuts on my phone because I didn’t know how to switch applications Without a mouse lol.
Been told this one a lot, and I can definitely see how it helps. Will keep practicing without a mouse for sure. Thanks!
not knowing alt tab from a young age is a foreign concept to me
guess not growing up with a windows machine is a zoomer thing?
Also due to the popularity of MacOS at a young age, there's really not anything like alt-tab in that OS.
Lol been there bro. Can relate to the phone shortcut lookups.
What is with these idiotic hardo statements about not using mouse? Are you retarded? Obviously some shortucts are necessary, but trying hard to not use mouse is beyond stupid.
Modelling is about being creative, yet simple in presenting a given result, not showing off what useless shortcuts you know. Simple, easy to follow formulas. Proper formatting. Pasteability. Accuracy.
How much time do you save by using a key shortuct instead of clicking on a ribbon? Miliseconds? Grow up and go off instagram finmemes, It is really ridiculous.
I do not think it inaccurate to say that a first year Analyst (i.e. someone who might spend literally an entire work day on a model) might save an hour or more over that work day by using keyboard shortcuts instead of a mouse. When you can only afford four hours of sleep a day, an extra hour is a godsend.
Also, back when I started out a lot of the BSDs had cut their teeth building models using pen and paper or Lotus 1-2-3... now there are probably a ton of MDs who came up through the pipeline having gone through their Analyst and Associate days churning models in Excel. Do you really wanna be the guy walking someone through a model and slowly clicking through Excel tabs while your MD or Partner is tapping their feet waiting?
my associate once sat me down and showed me the magic of the new world the alt key brought in ppt and excel; I think most people whove actually worked the job will tell you that every single second 100% adds up. and this not about a model due tomorrow morning and you have the day to do it. it’s adding a new set of assumptions for a new output for the latest cut of the strategic advisory deck, its putting together a new ebitda bridge analysis for a management presentation that needs to go to print press asap, it’s trying to pump out analysis so you can leave at a decent time on friday night.
if any shortcuts are so long, you might need ur mouse, put it in quick access, cuz it’ll always take more time to use it.
Bump
Similar to the idea of unplugging your mouse, getting better at modeling is all about building habits. just a few thoughts:
Appreciate the advice, thank you!
Cannot emphasize the importance of simple formulas enough. A lot of analysts come into this role with the misconception that complicated formulas somehow imply that the model will be better. In truth, it makes internal auditing, and buyer/reader auditing a nightmare, and is much more error-prone than taking the simple route. Don't be afraid to add one or two additional rows and break your formulas up - your VP/Associates will appreciate it and it will help improve the "correctness"/accuracy of your model overall.
If you get the chance, sit next to people who master it and are willing to share how to improve. Best to improving is through actual project work. Both helped me a lot. Other than this: try recreating models, understanding how and why they were built. The broad logic (assumption, process, outputs), the formulas, the "shortcuts". Good thing is that you have real inputs and a guide/solution (there is not "one" solution and beware, each project is different and tweaks may had been needed). To get better at excel: excercising shortcuts and formulae is key. Next step, how to make your work/formulas simpler. Simplicity is beauty and may reduce errors. As mentioned accuracy trump's speed and is actually true speed, as you will spend less time finding and correcting mistakes.
Appreciate it! Gonna practice recreating models without a mouse and hopefully ground the speed factor. Feel like that's my biggest hindrance right now. Thanks for the advice!
Absolutely. It makes a big difference in speed and you'll find out it is also more comfortable, as you don't need to take out your eyes from the screen and refocus. There are many pages with lists of shortcuts. Learn first the basic, like navigation, etc. You can make a habit at the beginning to learn two or three each day (or five a week or so) and use them proactively. There are tons of videos Nd tutorials on formulas. I would learn first the basic. For that it is good what your colleagues have used on other models. No need at this point to learn all possible esoteric functions, which you'll never get to use. Most importantly is however to learn to find the logic of models, how they are built, purposes, limits. One thing is to play keyboard well, but piano mastery entails feeling the melody and ultimately composing your own creations. Not saying excel is piano, is just a bad analogy. Don't worry, it's all about practice. Once you are a god of excel remember: "see one, do one, teach one"
Ahhh and remember what the other said: attention to detail, meaningful notes/sources/references and check your work not wice but three times. Your MD will pick your mistakes on first sight or latest when he pulls out his old hp 19b
+1 SB. This! Knowing all the shortcuts does not mean being good at Excel. Being able to construct a good flowing model that is easy to check for errors is the key.
Personally, I keep a portfolio of models I've seen throughout my career. I see how other people have modeled certain challenges and then basically borrow those ideas. My current model is essentially a hybrid of maybe 7 different models where I've seen someone come up with a good solution to a specific problem.
My suggestion is to try to get your hands on as many professional models as possible and see how everything runs and try to identify which methods are better than others.
Any chance you're willing to send that model portfolio over? I am new to modeling and expect to face a steep learning curve in PE soon. :D
I’d also love to see some of the models you’ve deemed worth saving if you’re able to share
Very look forwary to it.
this would be cool to check out and happy to improve it as well
Unplug the mouse. Remove the F1 key. Practice, practice, practice.
Why do you recommend removing the F1 key?
It opens the help window in excel which you can't get out of without a mouse
^That. And you use the F2 key a lot for auditing formulas, so if you accidentally hit the damn F1 key, it wastes valuable time waiting for the help window to open, grabbing the mouse, closing it, and resuming your work.
As everybody said - no mouse, master shortcuts and formulas.
Consider customizing your ribbon or shortcuts once you realize you work with certain formulas more than others, but do that relatively early to avoid breaking habits.
I was in S&T and then moved to a more senior role in PE - with no excel skills... I grabbed existing models and re-did them. One guy had complex, but models that were always RIGHT. So you get into their brain trying to recreate everything. When you stall, you look at how they are doing the formulas (as little as possible) Then some models were really shit, so you redo them but better.
Always ask people about how to do something simpler. I asked my analyst how to do a format painter from non-adjacent cells once - it was very straight forward with keyboard shortcuts but it wasn't straightforward at the time. Every formula you don't undertand in a model you just google it to understand how the formula works and you understand it.
Redoing existing models is the best way to learn. I became really good at the stuff in less than six months. I had to learn fast cause it was assumed I knew how to model
I also want to add - modelling for interviews and modelling for work are two entirely different things. I had learned how to model for interviews, that's pretty straight forward as they don't expect you to do everything perfectly in the limited amount of time you have - so it's more about how you set everything up that matters
In addition to the advice given so far - shadowing someone else when they build a model from scratch is massive. Take frantic notes, and make sure to give him praise to whoever their direct report is. The latter is huge, as it'll make them a lot more receptive to future asks you have.
Even esoteric shortcuts add up to meaningful efficiency gains. A couple to get you started that will help you find other shortcuts is (1) alt then you can follow the guide at the top to get to your selection without the mouse and (2) shift + f10 in place of right clicking a cell/s
I'll add color coding (computation, hardcode, link) and the other best practices, eg don't merge cells which makes it more difficult to navigate a tab (center across selection instead)
any pre-built macro that provides custom short cuts for formatting are incredibly helpful. I can't use excel right now with out it.
Something like TTS Turbo, although this isn't available anymore.
TTS Link
Damn, sucks that they stopped. I've been using the TTS Macros for years... not sure what I'll do if/when they become outdated
I used Macabacus in IB and now in corporate finance. It probably has the same exact functionality.
https://macabacus.com/
Use the quick access toolbar, customize it to make it your own
WSP crashcourse in excel is a godsend. Make flashcards of the shortcuts.
use the + sign on the numpad with your right ring finger to start formulas instead of using the = sign in between - and backspace it's much faster and you're less likely to hit a wrong key
There is only one way. Hours and hours of practice.
One of the best things that helped me was taking an excel class at my university. You don't have to pay an ungodly sum to attend them either. I know some of these excel classes can be $1,000 USD plus... However, if you can get into one of these programs through your university, or a personal connection at a discounted rate - I would highly recommend attending. Not trying to plug, but Wallstreet Prep and Train the Street will do promotionals at business schools for reduced rates.
Most of the classes through 'Wallstreet Prep' or 'Training the Street' are taught by former bankers, they will give you insight into on the job best practices for your models and focusing your attention on the essentials.
Are there any specific courses you guys would recommend to strengthen skills? Also, I'm using a MacBook currently. Do you guys think that's fine, or should I invest in a different laptop (any recommendations?).
Also, even though I'm not OP, just want to thank everybody for their insight. This thread was extremely helpful!
You should get a PC. There are some people who would disagree, but they're incorrect.
To add what has already been suggested, I would Google and print out a page that has common shortcuts on it and keep it at your desk. Assuming that you're working/studying from home right now, so take that opportunity to repeat the shortcuts verbally as you do them - it just makes the memorization process quicker and they'll become second-nature to you.
Thanks for the advice! Would you have any recommendations for a PC to get by any chance?
At some point being a god at Excel means ditching it and using python
Practice makes perfect. Checkout Exceljet website and Tiger Spreadsheet Solutions on Youtube.
PLEASE use the quick access toolbar. Customize the shortcuts you use most to save yourself keystrokes. It doesn’t seem like much, but they add up on certain projects and will make you leave the office earlier.
Biggest thing I learned from the senior analysts during my intern stint aside from shortcuts and formatting was creating files that are essentially "unbreakable". This goes a long way to save yourself time the next time you need to update it and makes life way easier on the people checking your work if they can see that it has been built correctly. Although it will take more time to think of how you can create dynamic formulas the first time around, it will help tremendously in the future when it comes to elminating stupid computational mistakes that could have been avoided with a better formula (ex. dynamic match formulas, limiting hardcodes and always referencing the same cell when hardcodes are necessary). Try and build a simple backup (ex. PV chart) in the most efficient way possible and then go into the legacy backup your bank uses and try and understand the differences between the formulas you used vs the ones that it has. Like everyone has already said, practice makes perfect and its a long journey hahaha. Hope this helps!
Use Arixcel, Operis OAK. Those auditing add-in make you a semi-god in excel .
What do they do?
Basically excel-addin with one-shop solutions. Every problems in modeling you suppose difficult has been thoroughly handled by excel professionals.
.
A few tips:
Disable your F1 key using macros
Don't daisy chain if you can help it (creating formulas in multiple tabs where results are dependant on other formulas)
Est unde consequatur sit quis ea enim necessitatibus. Amet fuga et ratione ducimus accusamus. Explicabo natus corporis alias iusto. Ipsa omnis accusantium sit nostrum. Cum et non officia temporibus labore aspernatur consequatur. Minima iste voluptatem magni ea praesentium.
Ea animi rerum laboriosam fuga placeat aliquam. Dignissimos et harum culpa alias rerum dolorum. Ut quae voluptatem voluptatem.
Voluptas similique repudiandae est eum voluptates. Omnis autem est exercitationem vel ullam ab. Nesciunt voluptates unde similique hic minus doloremque architecto. Ut eaque quisquam a quia quia enim delectus. Ut possimus ad maxime omnis quidem aut.
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...
Voluptatibus velit porro molestiae voluptas ut. Voluptas non rerum aut expedita. Voluptatem ratione culpa nostrum nisi dolorem officiis aut. Qui a aliquid velit voluptatibus et ad. Alias earum quia facere ut dolores commodi animi.
Accusamus est qui perferendis quidem consequatur. Architecto non soluta consequuntur ut aut quos animi. Fugit tempora nemo praesentium praesentium et quia laborum.
Consequatur aliquid est dolor rerum at nostrum velit quae. Amet ut ipsam ratione excepturi dolor qui. Rerum consectetur nemo nemo tempora repellat. Ea nihil et voluptas iste eum sapiente aut.
Sit laudantium laboriosam nulla qui repellendus dolor voluptas libero. Eaque qui atque nobis fugiat ex numquam tenetur. Sed aut quidem sit itaque quae reiciendis non quo.
Praesentium rem reiciendis blanditiis ullam. A cum molestiae labore voluptatem hic magni. Adipisci natus illum quas temporibus alias nisi.
Sit in ab nesciunt et voluptas. Officia consequatur rerum consequatur aut molestias. Voluptate deleniti molestiae excepturi facilis non quia. Culpa enim velit veritatis quia id.