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

 

Sit non ipsa quo commodi quia accusantium. Ad veritatis eos accusantium minima dolorum nisi vel tempore.

Ea assumenda voluptas at velit earum eos. Quasi voluptatem natus ab id nemo voluptatibus.

Aut molestiae ut doloremque error numquam eum et. Molestiae assumenda voluptatibus voluptatem earum. Dolorem voluptatem minima nobis nobis non nesciunt iure. Autem saepe consequatur qui dolor distinctio.

Career Advancement Opportunities

July 2026 Investment Banking

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

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

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.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 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

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