Excel Hour Practice Files

Download GROUPBY, PIVOTBY, and COPILOT File for 8-26-25 Session

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

Formats, Shortcuts, and AI Excel Tools

Download Xlookup Excel File
Dynamic Array Formulas Part 2
Dynamic Arrays Revisited
Download Formatting, Shortcuts & AI File for 8-12-25 Session

Miscellaneous Practice Files

Download Dynamic Text Functions

Newsletter Practice Files

Download CHOOSECOLS practice file from 1-8-25 Newsletter