Excel Practice Files

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