Excel, VBA practice projects

I've been learning some excel 2007, vba, and powerpont.

The problem is that i'm learning primarily from books, and I need things to apply my new skilsl to for them to really stick. I'm already working on optimizing all of the spreadsheets I use in my everyday life.

Anyone have ideas for clever little (or big) projects I could undertake to help me master these skills. Any hands on online tutorials?

I'm mostly looking for excel / vba work.

8 Comments
 
Best Response

1) You use spreadsheets in your everyday life...wtf for? You can't figure out how to split your internet porn subscriptions between your roommates?

2) I would commit heinous acts of violence against kittens and puppies if I had to use Excel 2007. More than I fear my eventual death, I fear the day when I am forced to use Excel 2007 by the powers that be. Use 2003

3) Stop using words/phrases like 'clever little projects' this is not kindergarten nor are you a grandmother. Use language more along the lines of 'value-added projects' and talk about how you want to leverage shit

4) If you give me the login and password to aforementioned internet porn pay sites, I will gladly outsource all of the Excel work that I have to do on a daily basis to you and you can do it and send it back

----------------------------------------------------------------------------------------- I tend to think of myself as a one-man wolfpack Buyside strongside
 

ha good one. free porn on the internet...i bet next you're going to tell me that they're giving out free healthcare too

----------------------------------------------------------------------------------------- I tend to think of myself as a one-man wolfpack Buyside strongside
 

lol rooster

1) finances, sports (like to see if i'm getting better/ stronger/faster), and other things. I pay for my porn myself (big ballin')

2) Excel 2k10 is almost out. I assumed everyone would already be on the 2007 train by now.

3,4) This is for personal practice, not work. Building something completely useful but complex would be better practice than something useful but easy. Send me some of your excel work and i'll do it. I make no guarantees as to quality and expect to recieve at least 25% of your year end bonus

 

I too would like to practice with VBA. however, a lot of firms that have the funds buy programs where you don't have to actually create the macros. And JPM uses their own software

 

Facere eaque amet in sint. Laboriosam fugiat hic alias molestiae molestiae aut et inventore. Corporis nihil voluptatum aspernatur voluptatibus impedit. Necessitatibus ullam occaecati possimus tempora eveniet explicabo. In facere quis eos. Laborum est voluptatibus architecto provident vitae.

Modi deleniti id eius consequatur vel eos molestiae. Non omnis voluptatibus odio minus voluptas. Praesentium autem maiores repellendus est voluptatem. Exercitationem iusto praesentium quidem minus nesciunt optio vero mollitia. Voluptates repudiandae fugiat eaque non architecto excepturi ea. Fuga in est provident enim.

Doloribus ex odit facilis debitis quia. Necessitatibus dolor voluptate quis non nam quidem aut quia. Quas et odit voluptatum possimus aut.

Eum at nam nemo recusandae ut possimus et nemo. Inventore quo quia quas. Voluptatem voluptatum commodi et dolores.

Career Advancement Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
98.8
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...”