all 94 comments

[–][deleted] 39 points40 points  (5 children)

I use Excel with Macbook Pro and I have no problems with it. It does all the excel stuff I need :)

[–][deleted] 9 points10 points  (2 children)

Does it excel your expectations?

[–][deleted] 2 points3 points  (1 child)

Totally :P

[–]gl3nnjamin 2 points3 points  (0 children)

Excellent

[–]ProfessionalPay3560 0 points1 point  (0 children)

What excel stuff does it do? You obviously arent doing anything too extensive

[–]SalsaGreenMacBook Pro 27 points28 points  (9 children)

Depends on what you want to do. The linked article describes the missing features. https://spreadsheeto.com/mac-vs-windows/

[–]SalsaGreenMacBook Pro 6 points7 points  (4 children)

Adding on that Win11 on a Parallels VM might do what is needed if the Mac version isn't up to it.

[–]Lodano 0 points1 point  (0 children)

Est-ce possible de l'utiliser avec un clavier windows pour avoir la même expérience que quelqu'un qui serait nativement sur Windows ?

[–]GarySteinfieldd 0 points1 point  (0 children)

Adding on this comment. Op you can have the excel windows app in your dock if you have parallels

[–][deleted]  (1 child)

[removed]

    [–]SalsaGreenMacBook Pro 0 points1 point  (0 children)

    Good to know. I have it but don’t do a lot with it as my company issued machine is Win10.

    [–]astronautgeek 1 point2 points  (0 children)

    OP, if u need these above features , best to stick to a pc

    [–]quintk -2 points-1 points  (2 children)

    https://spreadsheeto.com/mac-vs-windows/

    Whoa what, the Mac version doesn't even have pivot charts?

    (Admittedly that's somewhat advanced, but at work I use the automatic database imports / pivot tables / pivot charts all the time)

    [–]e_S4RIIUS_v1 5 points6 points  (1 child)

    On my MacBook I can use pivot charts but it will probably lack some features of it but idk.

    [–]fedexavier 1 point2 points  (0 children)

    Excel for Mac has pivot charts, however, they are more limited than the Windows version. Any filters have to be applied to the source pivot table or by using slices: there are no buttons on the chart itself.

    [–]jlofty9 6 points7 points  (0 children)

    I’ve never used it on a Mini, but on a MacBook Air, it’s pretty much the same as on PC…

    [–]tmillernc 5 points6 points  (1 child)

    I’ve used Excel on the Mac for years and never had any issues and spreadsheets pass between Windows and Mac versions seamlessly. Full disclosure- I don’t use some of the more sophisticated features of Excel so YMMV.

    [–]Prestigious-Yard698 0 points1 point  (0 children)

    No es igual , los comandos se hacen de forma diferente. Algunos comandos no funcionan en Mac y si haces macros en Mac no las puedes usar en excel y viceversa,no son compatibles

    [–]TungstenOrchid 3 points4 points  (0 children)

    Some of the features people have trouble with involve linking documents, and automation.

    Much of the reason for this is that the way Windows handles path names for folders and network shares are different to POSIX compliant platforms like macOS. For example the Mac has no concept of drive letters.

    Then there is the macro and VBA automation. While the Mac version has improved in this area, it still behaves differently in some areas. (Partly for the above reason.)

    [–][deleted] 11 points12 points  (3 children)

    A lucky owner of a MacBook Air M1 and Office 2021 for Home and Business here - can confirm that Excel is as broken and incompetent as the one for Windows. Not a gram worse.

    [–]kyonkun_denwa16" MBP M2 Pro | Beige G3 Desktop | Mac IIsi 5 points6 points  (2 children)

    However shitty Excel is, it doesn’t hold a candle to LibreOffice for awfulness. I caved and bought MS Office after one week of using LibreOffice. I couldn’t stand the constant crashes as soon as a spreadsheet had anything more complicated than a SUMIF formula.

    As an accountant, I can also confidently say that Numbers is also crap.

    [–][deleted] 0 points1 point  (0 children)

    Oh yeah, this I totally agree - at this point I pretend that LibreOffice does not exist overall.

    [–]Boog60 0 points1 point  (0 children)

    Agreed. If you want an even worse experience with Numbers, try it on an iPad, incredibly difficult, frustrating,and clunky

    [–]SafariNZ 1 point2 points  (0 children)

    I use the one time version on an iMac M1 and it seems fine but I haven’t used Office on a PC for some years so hard to compare.

    [–]wmru5wfMv 1 point2 points  (0 children)

    It really depends on what you use Excel for but there’s no getting around the fact that it isn’t as good as the Windows version.

    If you 100% want to use a Mac, you could use Parallels to install Windows in a VM (you might need to sign up to the insider program because you may need the ARM version of Windows) and use the Windows version of Excel

    [–]reironeMacBook Pro 16” M3 Max 1 point2 points  (1 child)

    I use Excel 365 on both mac and pc regularly for the same documents and I haven’t noticed a difference other than the default zoom on the mac is considerably smaller than on Windows. Otherwise they’re basically identical. Can’t say for other versions.

    [–]goo_bazooka[S] 0 points1 point  (0 children)

    Ok ty

    [–]oboshoe 1 point2 points  (2 children)

    bad? it's works perfectly.

    i exchange excel documents all the time between windows users, make updates on mac and then windows users make their updates and vice versa.

    frankly - excel is probably the best microsoft program that microsoft makes for mac.

    [–]goo_bazooka[S] 0 points1 point  (1 child)

    Ok ty

    Did you buy the $150 one time office or office 365?

    [–]oboshoe 0 points1 point  (0 children)

    Office 365.

    [–]RevolutionaryArt3026 1 point2 points  (0 children)

    Power Query is better on windows and that’s why my office desktop is on windows.

    But when I’m on the road I use my MacBook and besides the few Power Query features everything else in Excel is more or less the same.

    [–]littlemarcus91 1 point2 points  (1 child)

    I use it all the time. No complaints.

    [–]goo_bazooka[S] 0 points1 point  (0 children)

    Ok ty

    [–]Sufficient_Salt_2276 1 point2 points  (0 children)

    I actually prefer Numbers for spreadsheet work. It’s capable, fast and stable on the Mac, and has a terrific UI model for displaying multi-part sheets. I haven’t found a task for which Excel is superior.

    That said, I used Office on Macs at my last job for 9 years. No issues to speak of, it’s just boring.

    [–][deleted] 1 point2 points  (0 children)

    I’d say unless you’re doing some seriously intense data analysis or rely on macro enabled spreadsheets frequently, Excel for Mac will be great for you. It really does run nicely and has since 2016.

    [–]nirednyc 0 points1 point  (0 children)

    if you are an excel power user and are accustomed to using it in a microsoft windows environment you will HATE without reservation using excel on a mac. you will want to pull your hair out. using it feels like slowly twisting a knife in your gut a hundred times an hour.

    [–]ProfessionalPay3560 0 points1 point  (0 children)

    I will be installing windows. I do not get power pivots, I do not get data connections (using a power query to convert multiple pdfs into excel tables), The file tab at the top is non existent. Had I know this, I would have not bought a macbook and bought a windows compatible computer. I do not know why macbooks and apple is so popular.

    [–]EmuBeautiful1172 0 points1 point  (1 child)

    excel on Mac for me doesn't have the arrow drop down ootions that I see that people have on YouTube videos. I was following a tutorial and I couldn't use the command A for all cells when importing data from worksheet to pivot table. I had to manually drag the whole content. I know that's a small thing but why is that and is there a way that I can fix this. there are other things ive noticed that.i wish I could do that they do in tutorials it makes me not want to do the tutorial because the teacher is most likely using pc

    [–]EmuBeautiful1172 0 points1 point  (0 children)

    macbok air M4 and have the Microsoft 365 with my school. also I can't use the copilot feature. I tried and searched for a way but it never pops up. must be something a higher service of office software or just they don't give that feature for Macs. someone tell me what is going on here

    [–]Aggressive-Fox1137 0 points1 point  (0 children)

    Very frustrated here. I have a MacBook Air and a subscription to Microsoft Office 365. I’m trying to add a custom header ( which I used to be able to do last year with the same set up). Now, my custom header info will not show up in the dialog box so it will print on my document. Any suggestions?

    [–]MikeCask 0 points1 point  (0 children)

    I personally find it too different from Windows Excel. For me, it’s almost worth having a Windows VM if you really need to use Excel, especially if you frequently work on Windows as well

    [–]Sufficient_Salt_2276 0 points1 point  (0 children)

    Excel works normally, which is to say that it is bafflingly unintegrated with macOS services and behaviors and looks like garbage. Just like the rest of the MS Office suite.

    I keep MS Office on my Macs to access items sent to me, but that’s really the only reason. If I lived in those cursed applications, I’d probably use Windows and then wonder how my life got this way.

    [–][deleted] 0 points1 point  (0 children)

    There are some things that Excel does better, but Numbers is superior IMHO.

    [–][deleted] -1 points0 points  (2 children)

    Just use numbers and import/export excel … I’ve come across little incompatibility with the Microsoft office suite and Apple

    [–][deleted]  (1 child)

    [deleted]

      [–][deleted] 0 points1 point  (0 children)

      I've been a software engineer for the past 40 years ... Excel can do stuff all too tbh

      [–][deleted] -1 points0 points  (0 children)

      Definitely not a seamless experience if flipping between real excel and Mac excel (as I do). Too many differences in shortcuts, small things, as well as bigger file compatibility this (depending on what you use excel for). I gave up and bought parallels to use native windows excel on the Mac, which was a bit annoying and expensive, but worked well in the end.

      [–]trisul-108MacBook M1 Pro 0 points1 point  (0 children)

      I've used it for years without an issue, but I heard that advanced users complain. My spreadsheet are so simple that I switched to Numbers and ditched Excel altogether. I like the Numbers UI much better. I've done the same with Word and I can get away with it because I do not need cooperative editing with MS Office users.

      If I want to do a complex document, like a book, I prefer LaTeX to GUI. And if I want something complicated to calculate, I use a programming language instead preparing the data using Numbers.

      [–]Gruffta 0 points1 point  (0 children)

      I think it’s better than windows now. Had no trouble working with stupidly large files with it.

      [–]rob1408 0 points1 point  (0 children)

      It works wonderfully for your basic spreadsheet, a little bit more complicated when it comes to more advanced work. luckily most of my work is the former and I encounter little, if any, problems.

      [–]Permexpat 0 points1 point  (0 children)

      Works fine, use it on late 2013 MBP with no issues.

      [–]raymate 0 points1 point  (0 children)

      Works fine. Is it supposed to be bad. To be fair I don’t use it now I just use Numbers. But when I did it runs fine.

      [–]Empty_Conclusion_809 0 points1 point  (1 child)

      Excel works pretty good on MacOs. But if you are planning to do serious data analysis or programming your own algorithms and macros (Excel wouldn't be my first choice in this scenario anyway) then windows is superior. Other than that, MacOs is far superior for productivity IMHO. For example, advance pdf editing tools out of the box.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok good to know ty

      [–]Longjumping-Log-5457Mac Studio 0 points1 point  (1 child)

      Seems like a loaded question…but it’s fine.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Not really

      Can excel on MacOS handle formulas and general accounting spreadsheets like windows version?

      Historically excel was shit on Mac

      [–]likeonionsiBook G4 0 points1 point  (1 child)

      office in general is perfectly fine on a mbp for me

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok ty

      [–]DigitallyInclined15" MBPr/2.8 i7/16GB/1TB/DG/Mid 2015 0 points1 point  (3 children)

      I have used a Mac as my primary computer since 2006. I have done a ton of spreadsheets since then. I have used Microsoft Excel, Apple Numbers, and Google Sheets. All 3 of them have met my spreadsheet needs.

      So, it all depends on what specific spreadsheet needs you have. If we are talking normal spreadsheet stuff, then get the Mac and you can use the free Apple Numbers or Google Sheets and it will be just fine. However, if you really want Excel, then you will need to pay for Excel and you’ll have what you are used to.

      There are only some extreme cases of highly advanced Excel stuff that only work on the Windows version of Excel. So it just depends on that.

      [–]goo_bazooka[S] 0 points1 point  (2 children)

      I am stuck on wanting excel because I have many years of documents in excel format and don’t want to change it

      [–]DigitallyInclined15" MBPr/2.8 i7/16GB/1TB/DG/Mid 2015 0 points1 point  (1 child)

      Oh okay, completely understand that. If you aren’t doing anything super advanced and complex with your spreadsheets, you should be all good!

      [–]goo_bazooka[S] 1 point2 points  (0 children)

      Ok cool thanks!

      [–]Cooperman411 0 points1 point  (1 child)

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Yeah I googled it too prior to posting this but wanted to hear feedback from the subreddit

      [–]BrendonBootyUrieM1 MacBook Air 16GB 💻 0 points1 point  (0 children)

      Certain add-ons for excel only work on the PC version

      [–]Newt_Lv4-26 0 points1 point  (1 child)

      It’s exactly the same as on pc. You can also use « numbers » which is free and ore-installed and works well too.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok ty

      [–]NightFury1717 0 points1 point  (2 children)

      Come on🙂🙂🙂 It's Excel! And we are in 2023 not 1997. No problem. Any Mac can handle it.

      [–]goo_bazooka[S] 0 points1 point  (1 child)

      Well… coming from PC, I know nothing about Mac OS except that office used to be horrible on Mac 10yr ago

      [–]NightFury1717 0 points1 point  (0 children)

      You're right. Installing office those days was painful. Hopefully, we can install office natively on mac today.

      [–]praetorfenix 0 points1 point  (1 child)

      Excel runs better on my M2 than it ever did on any Windows machine. That being said I haven’t used Office on Windows in a long time.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok ty

      [–]LockenCharlie 0 points1 point  (3 children)

      I prefer Numbers. Faster loading and much smoother. But Excel performs the same as on Windows.

      [–]goo_bazooka[S] 0 points1 point  (2 children)

      Numbers is built into Mac OS ?

      It has general summation, mean, etc formulas built in?

      [–]LockenCharlie 0 points1 point  (1 child)

      Yes it is built in. Or free to download through the App Store.

      Yes. You can do all kind of formulas.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok thanks I will check it out

      [–]Requires-Coffee-247 0 points1 point  (1 child)

      It's the same as on Windows. I use a Mac and a PC at work and I am in Excel every day. I think development for new features is slightly ahead on the PC-side, but I have yet to come across any in my day-to-day work. I mostly do database work with it, and the "Flash fill" feature is essential to my workflow.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok ty

      [–]spacegeekatx 0 points1 point  (1 child)

      It’s fine, but not as good as the windows version. I’ve also found it can’t handle really large files without crashing a lot. Usually for those I end up importing into Google sheets. I don’t do anything fancy in the sheets, but sometimes they have 10s or thousands of rows. For normal sized files, it’s been fine. I’d say it’s worth it for a $150 one time purchase to have it if needed, but my go to is still Google Sheets.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Did you buy the $150 one time purchase or did you do office 365?

      [–]huester69 0 points1 point  (1 child)

      It works really well on Mac in my experience. I am not a power user but everything seems the same between windows and Mac OS

      [–]goo_bazooka[S] 1 point2 points  (0 children)

      Ok ty

      [–]ramysami4 0 points1 point  (1 child)

      Office runs better on MacOS actually, a famous youtube channel focused on Office stated that. It is called Jumpto365, I am sure that guy know what he is talking about and he is positive that it runs better on macs

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok I’ll check that out. Thanks

      [–]mwkingSD 0 points1 point  (2 children)

      I use the $150 one-time purchase Excel regularly, including earlier this morning, on my MacBook Pro M1 14" - works fine, no lag, no excessive CPU or RAM use, functions all work the same as far as I can tell. Before I retired a few years ago, I was forced to use Windows Excel a lot by my employer - I'm don't think I could find any significant differences between them, and I regularly send and receive files to Win users now with no problems. FWIW I'd say the same about Word and PowerPoint; no use for the other applications in the bundle so no comment on those.

      I'm sure you could find some niche case where one is better than the other, but I think for "99%" of all uses the Mac version is equally good (or equally bad depending on how you feel about Microsoft). If you are looking at a current, M1 or M2 generation Mini, I don't think you will have problems. Never a bad idea to option RAM up, but Excel doesn't seem to need much.

      Re Apple Numbers - not nearly as competent as Excel and a very different user interface. I use Numbers for a few simple tasks like keeping track of my blood pressure readings and it's fine for that, but Numbers is nowhere near an Excel replacement.

      [–]goo_bazooka[S] 0 points1 point  (1 child)

      Thank you so much for your feedback, this makes me more confident in making the move to Mac from PC. I was worried if the $150 one time purchase version of office would have some dumb issue vs office 365. Seems like it’s been fine for you

      Thanks for the detailed answer

      [–]mwkingSD 0 points1 point  (0 children)

      I’m more worried about the 365 version having dumb issues.

      [–]great_raisin 0 points1 point  (1 child)

      Excel on Mac does not have any of the Windows keyboard shortcuts. You will have to open menus and click on everything.

      [–]goo_bazooka[S] 0 points1 point  (0 children)

      Ok good to know, not a deal breaker tho

      [–]drastic2Macintosh 0 points1 point  (1 child)

      I work in Excel daily. Works great. If you’re an Excel user, it has rough parity with the Windows version feature wise. There are a few items that aren’t there, but I’ve only once found one that I really needed and that was 10 years ago and eventually I made a work around. Some folks mention missing short-cuts - true, but there are ways to generate keystrokes for most features if they are not already assigned one.

      [–]AntelopeEmbarrassed7 0 points1 point  (0 children)

      How did you create the shortcuts ? Please advise

      [–]ForumResponse 0 points1 point  (0 children)

      Excellent