Featured Videos

Excel Development in Practice

Videos demonstrating how we use Excel 365, Power Query, automation, and modern Excel development techniques to build business solutions.

ChatGPT in Excel 365

Building with the ChatGPT Excel Add-In

See the ChatGPT Excel 365 Add-In used to build an Excel Table, create a Pivot Table, and write M code.

Checkboxes in Excel

Modern Excel Controls

A demonstration of native Excel checkboxes and how they can be incorporated into modern Excel solutions.

Self-Referencing Power Query

External Data Without VBA

See a self-referencing Power Query approach that works with external data without relying on VBA.

Excel Table as a Form and Database

Self-Referencing Query / REA Form

A practical demonstration of using an Excel Table as both a data-entry form and part of a growing database process with Power Query.

More Excel Videos

Browse more Excel demonstrations, techniques, and examples from Excel and Access, LLC.

Microsoft Excel Functions and Formulas part 1 (Dennis Taylor) for the CPE Coalition

Microsoft Functions and Formulas Part Two for the CPE Coalition by DennisTaylor

How to use the Excel Tables Part One

How to use MS Excel Tables via VBA

Pivot Tables Part 1 by Dennis Taylor for the CPE Coalition, by Excel and Access, LLC

Pivot Tables Part 2

Excel Formulas and Functions - Webinar

How to use Microsoft Excel Formulas And Functions CPA Academy - Part One

How to use MS Excel Formulas And Functions for CPAs at the CPA Academy

Dennis Taylor Training for Peninsula Insurance - Formulas and Functions

How to use Microsoft Excel Pivot Tables - Part One Dennis Taylor 08222014 3

Dennis Taylor Pivot Tables Webinar Part Two

How to use MS Excel 2013 Pivot Tables

Dennis Taylor's latest Microsoft Excel Formulas and Funcions for the CPA Academy

How to use Microsoft Access

Visit our channel

Modern Excel Development

Power Query. Data Model. Dynamic Arrays. Pivot Tables. Automation.

Contact Excel and Access, LLC →