Power Pivot is one I encounter on the regular, you can't even use it on Excel for Mac, Windows or Bust
CFO was/is an excel wiz, so he would whip up crazy Rube Goldbergs with Power Pivot (And Power Query), that couldn't be modified by mac users (They can open the files, but they can't interact with it, not even changing filters
PowerQuery is another one, also not available outside of Excel for Windows, not Mac or Web
A lot of it is stuff that should be handled by SQL more properly, but the data people usually can't keep up with the Excel wiz
CFO was/is an excel wiz, so he would whip up crazy Rube Goldbergs with Power Pivot (And Power Query), that couldn't be modified by mac users (They can open the files, but they can't interact with it, not even changing filters
PowerQuery is another one, also not available outside of Excel for Windows, not Mac or Web
A lot of it is stuff that should be handled by SQL more properly, but the data people usually can't keep up with the Excel wiz