Notes

Mastering XLOOKUP in Microsoft Excel (The Spell That Finally Fixed Everything)

Mastering XLOOKUP in Microsoft Excel When Spreadsheets Fight Back Excel wizards begged for it for years: A[…]

Mastering FILTER in Microsoft Excel (Summoning Multiple Results with One Spell)

Mastering FILTER in Microsoft Excel When Spreadsheets Fight Back You finally manage to look up a value[…]

Mastering SORT & UNIQUE In Microsoft Excel: Taming Chaos and Finding the Gems

Mastering SORT & UNIQUE in Microsoft Excel When Spreadsheets Fight Back Messy data. Duplicate entries. Rows that[…]

Mastering SEQUENCE & RANDARRAY in Microsoft Excel: Generating Magic Numbers for Dynamic Reports

Mastering SEQUENCE & RANDARRAY in Microsoft Excel When Spreadsheets Fight Back Sometimes, you just need numbers: A[…]