3. October 2022 Zach Edwards

How to… Use INDEX and MATCH

19. August 2022 Zach Edwards

Micro How to VBA… Convert Numbers to their Alphanumeric Value

31. March 20227. July 2022 Zach Edwards

How to… Consolidate Quarterly or Monthly Data Using Power Query

25. January 20221. April 2022 Zach Edwards

Lightweight DND 5th Edition Item Tracker (Excel)

26. October 20211. April 2022 Zach Edwards

Lightweight Excel DND Dice Roller

6. October 2021 Zach Edwards

Micro How to… Format Data as a Table

11. March 20211. April 2022 Zach Edwards

Lightweight Excel DND Character Sheet

11. July 201822. June 2021 Zach Edwards

Quick Steps to Make Effective Data Visualisations

5. June 201822. June 2021 Zach Edwards

HOW TO… Excel: Create a hierarchical series of drop down boxes

4. June 201822. June 2021 Zach Edwards

HOW TO… VBA: Compare VBA Combo Box Values with Their Lists