Mac Excel Vs. Window Excel

What are the major differences in the 2 products (mac vs windows for excel)? Is it possible to run regression on mac? I want to use it for financial modeling, running regression, finding correlations and other finance/trading related business. Suggestions and thoughts? Would like to hear from someone with experience with both.

 
Best Response

You clearly haven't searched, since I feel like I've answered this question 100 times.

There is absolutely no comparison - you cannot use Mac Excel for any serious financial analysis. All the keyboard shortcuts are either different or non-existent, there is no VBA support, no support for most plugins (TTS macros, FactSet, etc), and the menus are terribly inefficient.

I love my Mac (typing on it right now) and use it for everything else. But when it comes to real work (Excel and PPT), it's gotta be PC, no debate.

- Capt K - "Prestige is like a powerful magnet that warps even your beliefs about what you enjoy. If you want to make ambitious people waste their time on errands, bait the hook with prestige." - Paul Graham
 

The workaround is to install Parallels on your Mac and run Windows in a virtual machine with actual MS Excel on it.

You're gonna want a pretty high specced mac for it though.

It runs fine for me at the moment (15" MBP i7 2.2Ghz, 8gb ram, 240gb SSD.. you get the jist..).

However, on my older 13" Macbook (Core2duo) it couldn't run very smoothly without lagging.

Its also a more expensive alternative though - compared to purchasing a windows laptop just to run MS Office.

The only thing I'm missing is page up/page down keys. Apart from that, all keyboard shortcuts and addins work fine.

But coming back to the issue of Mac office vs Windows office - Mac office, unfortunately has nothing on Windows.

 

Excel for Mac seems really unusable, from my experience. At least from the perspective of someone familiar with Excel on windows, but also I think there are shortcuts and stuff that are missing. For anything serious and finance-related, I think you just need to bite the bullet and get a PC (I also prefer Macs for personal use though)

 

Think about it.. It wouldn't make any commercial sense for MS to develop a version of excel for mac that is anywhere even close to the windows counterpart. Despite a product line numbering in the thousands, over a third of MS's revenue still comes directly from office, and you can bet a whole lot more comes indirectly from the fact there is no other alternative that natively runs MS office for windows. you think 90% of businesses use windows because it's a fantastic product? My employer still runs XP, a system which is over 10 years old and has been superseded TWICE. MS's only real competitive advantage is office, and in particular excel. they would be completely crazy to piss that away by giving mac users even a whiff of an alternative.

As others have said, no possible way to use Mac Excel properly for any kind of financial analysis. I can't even make it through my finance classes at school with Mac Excel. It was a struggle towards the end of the semester, my MBP is getting old (three years now) and is too slow for any VMWare or Parallels.

Getting a MacBook Air for Christmas, throwing Windows 7 and Office on there so I don't have to spend my life in the lab at school when I have to do Excel.

I don't have any problems with Mac Word, don't use Mac Outlook, but Windows Excel and PPT shit on the Mac versions.

MM IB -> Corporate Development -> Strategic Finance
 

yeah, I would recommend working on excel on a PC if your eventual goal is to get in the industry.. if you do not/cannot buy a windows computer right now but have a mac consider getting vmware fusion which basically lets your run a virtual windows machine as an application on your mac.. it's pretty neat.

macbook is good but if I were in the market today I would go for a surface.

 

Excel for mac is just not the same. Have a mac and used "numbers" and the Microsoft "Excel" but you are faster with a Windows computer. In the industry, you need to know how to use excel on a windows computer. It would be a waste of time to get used to the different shortcuts and the unpractical handling.

 

Absolutely, 100%, no questions asked use a PC. I am an avid Apple and Mac user in my personal life, but it is almost impossible to use excel on a Mac compared to a PC. They are surprisingly different.

 

Aperiam nostrum doloribus quo dolorem nihil quidem modi consequatur. Sit qui in voluptates vero dolorem. Omnis deleniti odio molestiae sunt. Accusamus harum molestias voluptatem ducimus.

Consectetur ipsa voluptas explicabo vel suscipit illum facere. Eum quia et veritatis labore velit dolores.

Voluptas a numquam ipsam iste neque. Totam doloribus ut porro est. Esse aperiam accusamus sed officia animi quo temporibus. Tenetur nostrum sint non deserunt mollitia tempore nesciunt corporis.

Commercial Real Estate Developer

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.8
10
Linda Abraham's picture
Linda Abraham
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...”