Top 10 Excel new features of 2010's

Описание: As the decade ends I recap my top 10 Excel features of the 2010s. We cover functions, Power Query, Power Pivot, Dynamic Arrays, and some forgotten greats!

For this video, I am scratching the surface of these features but you can explore them in more detail here:
Ideas with numerical variables:    • Excel's AI feature for numerical variables...  
Ideas with categorical variables:    • Analyze data in Excel #1: AI to get detail...  
Slicers with stats charts:    • Slicer dependent statistical charts in Excel  
Dashboards with slicers:    • Interactive dashboard in Excel  
Table relationships:    • Excel table relationships  
Flash fill:    • Combine & Split columns with Excel's AI-en...  
TEXTJOIN:    • TEXTJOIN, CONCAT &, TEXTJOINIF  
Stock & Geo data types:    • Excel 365's stock & geo data types  
In cell charts & sparklines:    • In cell heat maps, bars & line charts + gr...  
Waterfall charts:    • Waterfall charts in Excel & PowerPoint