In my experience, non-basic formulas are beyond 99% of people and they use it simply for adding stuff up in a grid. This is why Google Sheets is used in many places as a replacement (even if it balloons RAM usage when presented with a large sheet of data), simply because all of the wonderful features of Excel are unused.
The most complex operation some people do seems to be lookup tables.