5. January 202327. January 2023 Zach E.

Analysing Data in Excel: Flu Vaccinations

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

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

5. June 201822. June 2021 Zach E.

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

4. June 201822. June 2021 Zach E.

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

4. March 201822. June 2021 Zach E.

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

25. February 201822. June 2021 Zach E.

HOW TO… Excel: Create an Automatically Updating Chart