Work through these lessons in order to build advanced excel skills.
XLOOKUP, INDEX/MATCH, dynamic arrays, advanced PivotTables, and your first macro.