5 ms·

I heard excel guys say peak Excel was 2010. Where there any genuinely useful features Outlook 2016 had over 2010?

1970-01-01 4mo ago
Mostly memory management and 64-bit support finally being on-par with the 32-bit versions, but it's hard to argue the nuance overall.
- deburo 4mo ago
  The switch to hardware-accelerated rendering was poor. It's still causing issues today. Is it the graphic drivers' fault or their poor implementation? Who knows, but they also disabled the switch that allowed to turn it off, which is just classic Microsoft being annoying.
airstrike 4mo ago
I'm an Excel guy and 2013 was an improvement over 2010 with very little to dislike.
j16sdiz 4mo ago
XLOOKUP was introduced in 2019. I thought it was a great update
Yossarrian22 4mo ago
You can take LET and LAMBDA from my cold dead hands
Someone1234 4mo ago
I wouldn't trust an "Excel guy" who said that, they aren't staying current/using new functionality. Just off the top of my head: IFNA, FORMULATEXT, DAYS, CONCAT, IFS, SWITCH, XLOOKUP/XMATCH, FILTER, UNIQUE, LET, TEXTBEFORE/TEXTAFTER, LAMBDA, et al. But my favorite improvement is the "don't intentionally corrupt CSVs" options found in Settings -> Data -> Automatic Data Conversion (hint: Disable everything). Only took them 30-years to add that. Absolutely absurd these are enabled by default still. Excel is one of Microsoft's best pieces of software and one of the very few they haven't turned into slop YET. Still don't understand why we don't have local-only Python to replace VBA at all license levels (i.e. non-cloud).
- nhinck2 4mo ago
  > Automatic Data Conversion (hint: Disable everything). It still butchers long strings of digits if they are more than around 12 and less than around 15 digits long, its very annoying still. Also textjoin and textsplit and the whole spill functionality.
- jandrese 4mo ago
  I gave up on Excel for working with CSV years ago, but it sounds like I need to go back and try again. It used to drive me crazy how the import function was all "just fuck my shit up, Fam" every time. Reminds me of the old joke about it: How is Microsoft Excel like an Incel? Both think everything is a date.
- NetMageSCW 4mo ago
  Not to mention native array formula handling.
deleted 4mo ago
[deleted]
NetMageSCW 4mo ago
Those guys aren’t using Excel very much.

1970-01-01 4mo ago

Mostly memory management and 64-bit support finally being on-par with the 32-bit versions, but it's hard to argue the nuance overall.

deburo 4mo ago
The switch to hardware-accelerated rendering was poor. It's still causing issues today. Is it the graphic drivers' fault or their poor implementation? Who knows, but they also disabled the switch that allowed to turn it off, which is just classic Microsoft being annoying.

airstrike 4mo ago

I'm an Excel guy and 2013 was an improvement over 2010 with very little to dislike.

j16sdiz 4mo ago

XLOOKUP was introduced in 2019. I thought it was a great update

Yossarrian22 4mo ago

You can take LET and LAMBDA from my cold dead hands

Someone1234 4mo ago

I wouldn't trust an "Excel guy" who said that, they aren't staying current/using new functionality. Just off the top of my head: IFNA, FORMULATEXT, DAYS, CONCAT, IFS, SWITCH, XLOOKUP/XMATCH, FILTER, UNIQUE, LET, TEXTBEFORE/TEXTAFTER, LAMBDA, et al. But my favorite improvement is the "don't intentionally corrupt CSVs" options found in Settings -> Data -> Automatic Data Conversion (hint: Disable everything). Only took them 30-years to add that. Absolutely absurd these are enabled by default still. Excel is one of Microsoft's best pieces of software and one of the very few they haven't turned into slop YET. Still don't understand why we don't have local-only Python to replace VBA at all license levels (i.e. non-cloud).

nhinck2 4mo ago
> Automatic Data Conversion (hint: Disable everything). It still butchers long strings of digits if they are more than around 12 and less than around 15 digits long, its very annoying still. Also textjoin and textsplit and the whole spill functionality.
jandrese 4mo ago
I gave up on Excel for working with CSV years ago, but it sounds like I need to go back and try again. It used to drive me crazy how the import function was all "just fuck my shit up, Fam" every time. Reminds me of the old joke about it: How is Microsoft Excel like an Incel? Both think everything is a date.
NetMageSCW 4mo ago
Not to mention native array formula handling.

deleted 4mo ago

[deleted]

NetMageSCW 4mo ago

Those guys aren’t using Excel very much.