Рет қаралды 23,474
⬇️Excel tips and tricks throughout this extended tutorial⬇️
Dynamic Array Functions: UNIQUE, SORT, FILTER
Tables
Flagging hidden rows using AGGREGATE
Formatting Slicers
Named Ranges
The AA Toolbar can be downloaded free from here accessanalytic.com.au/free-excel-stuff/free-excel-templates/
A copy of the file I used
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EiKfH7Kx4uJEsrtA_g3INWAB_o6pndfZFCMswwX16lTEdA?e=nKUzax
Follow me
wyn.bio.link/
Buy my book:
pbi.guide/