Excel is great, it is still Microsoft’s best product, (in contrast to Word which is an abomination).
However I am very disappointed with Microsoft’s lack of investment in Excel, over the past 10 years it has hardly improved. eg the VBA code editor is appalling, like a relic from the 1980’s (constrast VS Code).
I use tables extensively (they are quite nice) problem is they require extensive use of Index/Match which becomes tedious to set up and is very slow, so manual update soon becomes obligatory. MS should incorporate some of the Power BI linking (think Foreign Keys) capability to overcome this big problem. Would be nice if they added SQL,instead of always making up their own query language language (eg M). Sumifs Countifs functions offer powerful and essential capability that could also be better done with SQL syntax. Excel is very error prone so Unique row constraints on tables or sheets would be handy. The formula editor is also archaic and could be easily improved dramatically.
Yes - Excel is Fun - what an awesome YouTube channel, that guy’s enthusiasm for Excel is extraordinary.