Spain, 308 goals and 6.8 million fans. Turn the 2026 World Cup into a dark, pitch-green Excel dashboard using XLOOKUP, FILTER, LET, GROUPBY, LAMBDA and the spill operator. Full workbook included.

Most people use PivotTables but few use them well. These high-impact tricks cover custom sorting, calculated fields, grouping, and more — with a free European snacks dataset to practice on.

Excel users often seek efficient ways to retrieve data from large spreadsheets. Two powerful functions that stand out in this pursuit are...