I use excel for my daily work. I have no idea what Power Query is. I have never used a pivot table. I use xlookup maybe once a year. My co-workers immediately zone out when I try to explain that function to them. Most of them use + - * / sum and maybe an average from time to time. They think I’m a hacker because I wrote a custom function for a calculation I frequently need.
From my experience with people in offices I’m pretty sure I’m on the tech savvier side of the user base and the vast majority of users will never actually see the difference in functionality between excel and calc.
Power Query is the biggest one. It used to be pivottables and formulae like xlookup as well, but Calc seems to have caught up to them nowadays.
I use excel for my daily work. I have no idea what Power Query is. I have never used a pivot table. I use xlookup maybe once a year. My co-workers immediately zone out when I try to explain that function to them. Most of them use + - * / sum and maybe an average from time to time. They think I’m a hacker because I wrote a custom function for a calculation I frequently need.
From my experience with people in offices I’m pretty sure I’m on the tech savvier side of the user base and the vast majority of users will never actually see the difference in functionality between excel and calc.