Updated Aug 15, 2018
Version 2.0Blake T Walsh
Former Employee
Joined July 19, 2016
Excel Blog
Subscribe to the Excel Blog to get the latest product announcements and updates
Why is working with tables, with column header annotation, inconsistent when counting columns.
When "receiving" column-number for certain table column header you are relative to sheet-start, column A, but when "using" the column-number you are relative to the first column in the table ???
Trust me I got confused when I Use excel on MAC, the working is different as compare to windows, function keys are different so it make me confuse all the time. https://www.youlearnexcel.com/check-mark/ has different working style.
Simmonrm , if in brief, all new functionality is always introduced in Office365 and could never appear in Excel 2019, if only in Excel 2021 or so.
Is there a difference in Excel capabilities between Office 365 and the buying the Office 2019?
On the PC side, multithreading is optional. It is controlled in File menu > Options command > Advanced option > Formulas section. It seems to me that on the PC it defaulted to single threaded. Please confirm that multithreading is default in Mac.
My favorite "feature" is actually a mixed set of relatively new features:
"Get & Transform" > Tables > PivotTables > PivotCharts > Dashboards
I first "found" PivotTables, that lead me "backward" to Tables and "Get & Transform" and "forward" to PivotCharts and Dashboards.