Office 10 was the last real version
After that it started getting dumbed down.
A few years ago I worked on a power consumption model for the modem section for models coming out in a few years.
The most difficult part was modelling efficiency of DC-DC converters because of the number of factors and non linearity which meant curve fitting in sub bands across several dimensions, took a minute to run the spreadsheet set per output power level.
Outlook 2016 is bad enough but the Excel online doesn't even allow you to reference on sheet from another within the workbook unless you use a named value.