28. November 202228. November 2022 Zach E.

Doing the Basics: Worksheets

27. November 202228. November 2022 Zach E.

Doing the Basics: Workbooks

3. October 2022 Zach E.

How to… Use INDEX and MATCH

19. August 2022 Zach E.

Micro How to VBA… Convert Numbers to their Alphanumeric Value

31. March 20227. July 2022 Zach E.

How to… Consolidate Quarterly or Monthly Data Using Power Query

6. October 2021 Zach E.

Micro How to… Format Data as a Table

7. January 201822. June 2021 Zach E.

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

7. January 201822. June 2021 Zach E.

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

4. January 201822. June 2021 Zach E.

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