How to get better at excel/ppt?
Title says it all. Just hit the desk as an AN1 but I’m finding myself reach for the mouse more than I’d like to. My fellow analysts are shortcut gods & im just wondering if anyone has any tips on how to get there.
Title says it all. Just hit the desk as an AN1 but I’m finding myself reach for the mouse more than I’d like to. My fellow analysts are shortcut gods & im just wondering if anyone has any tips on how to get there.
| +379 | Evercore Intern Seizure | 56 | 1h |
| +74 | JPM M&A is Gone??? Purely Coverage Banking??? | 33 | 1h |
| +62 | Is DCM actually underrated ? | 26 | 23m |
| +53 | How do I understand vs. just memorizing? | 9 | 2h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +47 | Are all Tech / TMT groups sweaty? | 38 | 1d |
| +42 | Associate & Above IB exits | 16 | 4d |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 8h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
| +24 | Thoughts on PEI Global Partners? | 4 | 2d |
Career Resources
Follow
Pm me
Following
Following
Once you know which shortcuts you need to know just actively practice with them even if it means looking them up mid work stream. It's the only way to learn and it doesnt take long. Eventually it will become fun to pick up a new shortcut here or there when you have to do something new like crop an object to a shape or combine multiple objects into one in PPT. I used to play a lot of real time strategy games where shortcuts are key to being a good player and so I always enjoyed that aspect of this job.
Make sure you’re using your Quick Access Toolbar. I believe Wall Street Prep has a PPT one free for download. Customize an Excel one for yourself (I recommend having font color, fill color, borders, paste special, font, font size to start).
Using a mouse sometimes is necessary/not really as bad as people say. Just try to use shortcuts more and you’ll be ok. Just takes repetition.
Not sure how worth it is, but I did the following for a few months leading up to my analyst program
1. Go to this site https://www.10xebitda.com/investment-banking-presentations/
2. Start remaking the PDFs in PPT from scratch
3. Google incremental ways to do things faster whether it is using the QAT (I also recommend WSP PPT course), memorizing shortcuts, etc.
4. Keep practicing; it is 100% about getting reps in
^ for PPT specifically; for Excel, I just did WSP course and recreated Macabacus models
That’s pretty normal, just start using hot keys more. It will take you longer at first, but overtime you’ll continue to become faster and faster. Then in 2-6 months of using those hot keys you’ll be just like those other analysts you’re describing. I felt the same way when I started, but now I’m pretty quick. It’s all about repetitions.
Most helpful thing for me was to try to random things in excel and focus on never touching the mouse. Build a budgeting spreadsheet, make a schedule, grocery list, dividing up venmos from the weekend. When you do these things just keep trying to add different and extremely unnecessary functionalities. Over time this became very useful for me in my training.
Following
Back when I was learning it helped me to pick 2-3 new shortcuts every week, sticky note them to my monitor, and focus on using them every time I needed to. Most of your work is covered by a relatively small number of shortcuts so after six weeks you'll have progressed pretty quickly.
I know this sounds dumb, but just hit the Alt button and follow the letters. Eventually you will remember what comes after “Alt”
There is a ton of info on WSO and online in general.
But a few things I found helpful…
What ppt shortcuts do you guys use most
Dolor dicta qui aliquid fugit. Quas nesciunt facilis eveniet quia iste rem dolorem. Porro laborum quaerat cum voluptatem quo. Earum est hic veniam sint maxime quaerat similique non.
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...