I’m looking to train some people in Calc, who are Excel users. I would like to know a) which settings in Calc to use to be most like Excel, and B) what other differences there are.
For a) I see Formula to use Excel formula syntax. Is there anything else?
For b) I see Differences in Use between Calc and Excel - Apache OpenOffice Wiki which seems out of date.
EDIT: some additional details–
This is for USA users who have many personal xlsx files they would like to start using in Calc. They do not use macros/VBA, or highly advanced features. I understand the UI is different, and that recent, Excel 2016+ functions may not work. I am looking for differences they should know about, or settings to use to ease compatibility.