excel vs numbers

UKBeast

macrumors 6502a
Original poster
Jan 21, 2010
542
26
Turkey
I am using excel in my office windows laptop ,at home i have mba 2018.

I want to use my order list files, price lists and other spreadsheets in my mba, i am doing extensive pro spreadsheets but compability is important.

is excel buggy and slow on mac os

should choose numbers over excel
 

Kraizelburg

macrumors 6502
Nov 10, 2018
262
76
Spain
If you are doing extensive pro spreadsheets then the only way to go is Excel, numbers is just too basic, its ok for occasional use but I wouldn't use for pro spreadsheets.
I have excel 2019 in my MBA and I don't find it buggy. Probably is more polish in windows but it's OK
 

superscape

macrumors 6502a
Feb 12, 2008
926
216
East Riding of Yorkshire, UK
Yup, I'd agree with that.

Much as I'd like to be able to recommend Numbers - if you're doing doing the heavy stuff and compatibility is the problem then I'm afraid it's Excel all the way.

If anyone who knows me personally is reading this then, yes, you did read that right. I did just recommend Excel.
 

Gator1pk

macrumors member
Sep 28, 2013
53
24
Fort Lauderdale
I use Excel 2011 in my MBPr 15”.
As an advanced Excel user, I’m an accountant, Excel is the only one to use. Numbers is awful.
 

johannnn

macrumors 65816
Nov 20, 2009
1,431
794
Sweden
So often when I do spreadsheets, I have to google the formulas. Remember, there is ZERO information about Numbers on google. That alone is a good reason to use Excel. Good luck using Index or Vlookups in Numbers. Actually, Numbers doesn’t even support stuff like Pivot table.

TLDR: Numbers is faster and more Mac-like, but sucks for anything complicated.
 

sracer

macrumors G3
Apr 9, 2010
8,398
8,792
Prescott Valley, AZ
I use Excel 2011 in my MBPr 15”.
As an advanced Excel user, I’m an accountant, Excel is the only one to use. Numbers is awful.
thumpsup.gif

I'm in Institutional Research and I prefer Excel 2011 on my macOS systems over the newer versions... but when I don't need the power (or compatibility) of Excel, I do enjoy using Numbers.
 

mj_

macrumors 6502a
May 18, 2017
572
289
Austin, TX
Excel is a fully-loaded crew cabin long bed lifted Ford F150 Diesel truck that can do pretty much anything.
Numbers is a Matchbox Ford Fiesta that is nice to look at but otherwise mostly useless.

If you are serious about compatibility and do extensive pro spreadsheets Excel is really the only way to go. LibreOffice Cald is a close second but even that doesn't get anywhere near Excel's genius and capabilities, especially now that Microsoft has started introducing AI features, and it is nowhere near compatible and uses its own formula syntax and semantics.
 

viggen61

macrumors 6502
Jul 24, 2002
432
6
New Jersey
Excel is great on MacOS. 99% of what is supported on Windows is supported on Mac. You just need to be sure the versions are similar, since MS's versioning hasn't always been consistent between Win & Mac. I just move the files between platforms seamlessly.

You will need to deal with eccentricities of each platform, particularly in formatting, but that's pretty minor stuff.

I really wanted to like Numbers, but I feel like banging my head against the desk almost every time I use it.

I've been using Google Sheets a bit lately, and it's kinda in-between Numbers and Excel.
 

appleofmyibook

macrumors regular
May 31, 2016
106
177
So often when I do spreadsheets, I have to google the formulas. Remember, there is ZERO information about Numbers on google. That alone is a good reason to use Excel. Good luck using Index or Vlookups in Numbers. Actually, Numbers doesn’t even support stuff like Pivot table.

TLDR: Numbers is faster and more Mac-like, but sucks for anything complicated.
This is exactly my issue with Numbers. I think Pages is better than Word and I think Keynote is about 1 million times better than PowerPoint so I really want to be able to use Numbers but I can’t find anything on Google. It’s all for either Excel or Sheets. It sucks.
 

James Craner

macrumors 68000
Sep 13, 2002
1,708
170
Bristol, UK
As an accountant that has been using Spreadsheets for over 30 years, and having used both Numbers and Excel. I can say that Numbers is great for simple tables and for producing spreadsheet based reports due to its flexible multiple tables with text and charts on the same page approach, but for a powerful Pro level spreadsheet, Excel is streets ahead of Numbers. Mac Excel used to be behind the Windows version mainly due to lack of multi threaded support, but this has been added in the latest version of Mac Excel (Office 365).
 
  • Like
Reactions: sracer