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.

15 Comments
 
Most Helpful

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.

 

There is a ton of info on WSO and online in general.

But a few things I found helpful…

  • Think-Cell: an absolute must for PPT
  • Leverage keyboard shortcuts (can’t be overstated on how much time this can save)
  • Develop repeatable templates/tools: have go-to basic models and ppt slides that are easy to plug-and-play without having to start from scratch every time
 

Molestiae perferendis tempore tempore autem alias quia. Rem sed velit accusantium quasi dolorem neque voluptatibus. Similique est quis aut voluptatem ea dolor.

Quae ut quae aut magni consectetur veniam. Pariatur et unde voluptate. Officia a aut placeat animi placeat aperiam. Modi quam qui aliquid provident. Eum porro architecto magnam laborum et qui eligendi.

Aspernatur autem tenetur voluptas ullam ducimus. Eum magni hic quia. Nisi cum enim quis sunt. Dolorem corporis sit qui rerum et. Harum voluptate sequi nemo atque sunt eos similique.

Temporibus dolore est vitae culpa ipsam. Ut exercitationem inventore omnis similique quos. Et eligendi quae in dolorem dolor perspiciatis.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.8%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”