31. March 20227. July 2022 Zach Edwards

How to… Consolidate Quarterly or Monthly Data Using Power Query

6. October 2021 Zach Edwards

Micro How to… Format Data as a Table

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

4. March 201822. June 2021 Zach Edwards

HOW TO… Excel: Create a Dynamic Data Range for a Chart

25. February 201822. June 2021 Zach Edwards

HOW TO… Excel: Create an Automatically Updating Chart

7. January 201822. June 2021 Zach Edwards

HOW TO… Excel: Using Index and Match to Create Dynamic Data Tables

7. January 201822. June 2021 Zach Edwards

HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table

4. January 201822. June 2021 Zach Edwards

HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes