Excel Hour Practice Files
Excel Hour: Use NA () Function in Graphs
Excel Hour: CHOOSECOLS and GROUPBY Function
Excel Hour: Lookup Methods
Excel Hour: Power Query
Excel Hour: Dynamic Arrays
Excel Hour: Pivot Tables
Excel Hour: Sequence Function
Excel Hour: New Features in Excel
Excel Hour: Using the #N/A Function in Excel to Improve Graphs
Excel Hour: Microsoft Excel Tables
Building a Fully Dynamic Financial Model
All About The Unique Function in Excel
New Excel Feature: The Navigation Pane
Xlookup: How to Write a Nested Xlookup
Dynamic Arrays Part 2
Dynamic Arrays Revised
GROUPBY, PIVOTBY, and COPILOT Function
Graphs Tips and Tricks (Tables, Dynamic Arrays, and the NA Function
GROUPBY, PIVOTBY, BYCOL and BYROW