What's the street using these days?

Excel 2007 or 2010?

thanks in advance.

Investment Banking Interview Course

  • 7,548 questions across 469 investment banks. Crowdsourced from over 500,000 members.
  • Technical, behavioral, networking, case videos, templates. All included.
  • Most comprehensive IB interview course in the world.

Comments (26)

Feb 20, 2012

We use 2007 at my bank (BB)

Feb 20, 2012

2003, stick to what you know i suppose.

Feb 21, 2012
Oreos:

2003, stick to what you know i suppose.

Holla... had the choice to upgrade to 07 and said no thanks... not nearly as user friendly

Feb 20, 2012

We also use 2007

Feb 20, 2012
Learn More

7,548 questions across 469 investment banks. The WSO Investment Banking Interview Prep Course has everything you'll ever need to start your career on Wall Street. Technical, Behavioral and Networking Courses + 2 Bonus Modules. Learn more.

Feb 20, 2012

most places i know of are using 2007. I have 2010 in my laptop and it's pretty much the same thing as 2007. I loved the 2003 version, so I installed the boost feature (from Wall Street Prep) which basically embeds the 2003 menu into 2007. It's awesome - and free.

Feb 20, 2012

algo shops will be using 2010, vba has some pretty significant changes to it.

Learn More

7,548 questions across 469 investment banks. The WSO Investment Banking Interview Prep Course has everything you'll ever need to start your career on Wall Street. Technical, Behavioral and Networking Courses + 2 Bonus Modules. Learn more.

Feb 20, 2012

Most places still use 2007 mainly because most of the third-party software hasn't been upgraded to work with 2010.

Feb 20, 2012

i am going to cry if the spot im starting at is using 2003

Feb 20, 2012

Shortcuts in 2007 blow, but its a lot faster than 2003. I still prefer 2003.

Feb 20, 2012

Thanks for letting me know guys. I was asking this in the context of starting as a banking analyst.

Feb 20, 2012

Boutique IB - 2010

Feb 21, 2012

Switched from 2003 to 2007 recently, although a lot of my colleagues were on 2007 for a while. I still prefer 2003. What's 2010 like?

Feb 21, 2012

Large foreign bank: Excel 2003 but the rumor is that my bank is jumping to 2010.

Feb 21, 2012

BB IBD. 2007. I wonder when we're going to switch to 2010... Maybe when Office 15 hits the shelves?

Feb 21, 2012

2003 but making the switch to 2010 soon. Its going to be a rough few weeks getting used to it.

If I had asked people what they wanted, they would have said faster horses - Henry Ford

Feb 21, 2012

in the process of switching from 03-07 from what i heard. hopefully 07 soon.

Feb 21, 2012

Work at a large European BB bank that uses 2007. Last time I used 2003 was at my boutique internship last summer, and it was agonising. Functionality is so poor, felt like bashing my head against a wall every time I used it.

You know you've been working too hard when you stop dreaming about bottles of champagne and hordes of naked women, and start dreaming about conditional formatting and circular references.

Feb 21, 2012

Used 2003, then 2007, then 2010, now back to 2003.

2010 is the same as 2007 in most ways but fixes bugs. By bugs, I mean weird shit like easy division calcs that just give you the wrong number for no reason. After getting used to 2010, it is really great and I could build some nice things.

One of the most notable differences for me was saying goodbye to if(iserror()=true BS in 2007+.

Feb 21, 2012
sk8247365:

Used 2003, then 2007, then 2010, now back to 2003.

2010 is the same as 2007 in most ways but fixes bugs. By bugs, I mean weird shit like easy division calcs that just give you the wrong number for no reason. After getting used to 2010, it is really great and I could build some nice things.

One of the most notable differences for me was saying goodbye to if(iserror()=true BS in 2007+.

Why did you pull a Benjamin Button? 2007 isn't that bad.

Feb 21, 2012
Leonidas:
sk8247365:

Used 2003, then 2007, then 2010, now back to 2003.

2010 is the same as 2007 in most ways but fixes bugs. By bugs, I mean weird shit like easy division calcs that just give you the wrong number for no reason. After getting used to 2010, it is really great and I could build some nice things.

One of the most notable differences for me was saying goodbye to if(iserror()=true BS in 2007+.

Why did you pull a Benjamin Button? 2007 isn't that bad.

2007 sucks compared to 2003... if you can combine the user friendliness and compatibility with the speed of 2010, then that's the winner. 2007 wasn't designed for professional users to do modeling with... it's designed for people who are unfamiliar with Excel's layout as it has been since inception and was an attempt to group things by categories, but the shortcuts suck and it's layout is not ideal for what finance professionals do.

Feb 20, 2012

aren't most shortcuts in 2003 still compatible with 2007? that made the transition really smooth for me. I still do alt o e not that ctrl 1 shit,

Feb 21, 2012
esbanker:

aren't most shortcuts in 2003 still compatible with 2007? that made the transition really smooth for me. I still do alt o e not that ctrl 1 shit,

That illustrates a perfect point... alt + o + e takes two hands, whereas ctrl + 1 only takes one

Feb 14, 2013

so it seems like i should learn 2010 then right, if i were to do a WSP course?

Feb 25, 2013