Excel Hour Practice Files

Download Practice File for Session on 1-13-2026

Excel Hour: Use NA () Function in Graphs

Download Excel NA() with Graphs Practice File

Excel Hour: CHOOSECOLS and GROUPBY Function

Download Excel CHOOSECOLS and GROUPY Functions file

Excel Hour: Lookup Methods

Download Excel Lookup Methods File

Excel Hour: Power Query

Download Excel Power Query File

Excel Hour: Dynamic Arrays

Download Excel Dynamic Arrays File

Excel Hour: Pivot Tables

Download Excel Pivot Tables File

Excel Hour: Sequence Function

Download Excel Sequence Function File

Excel Hour: New Features in Excel

Download New Features In Excel File

Excel Hour: Using the #N/A Function in Excel to Improve Graphs

Download Using the #N/A Function in Excel

Excel Hour: Microsoft Excel Tables

Download Microsoft Excel Tables File

Building a Fully Dynamic Financial Model

Download Fully Dynamic Financial Model (Hay Brothers)

All About The Unique Function in Excel

Download Unique Excel File

New Excel Feature: The Navigation Pane

Download Navigation Pane File

Xlookup: How to Write a Nested Xlookup

Dynamic Arrays Part 2

Dynamic Arrays Revised

GROUPBY, PIVOTBY, and COPILOT Function

Download Xlookup Excel File
Dynamic Array Formulas Part 2
Dynamic Arrays Revisited
Download GROUPBY, PIVOTBY, and COPILOT File

Miscellaneous Practice Files

Download Dynamic Text Functions

Newsletter Practice Files

Download CHOOSECOLS practice file from 1-8-25 Newsletter