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

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