training that actually sticks
From quick wins to full team upskilling — real hands-on training that fits how you already work.
Training Programs
We offer many pre-scripted, instructor led training courses covering all aspects of Excel and Excel automation from basic navigation and formulas to advanced VBA programming techniques and the Excel object model. Have a need for a more customized course? Give us a list of topics and we'll pull the applicable parts from our libraries of courseware and build the rest.
Whether you want the most basic high-level Excel essentials, or you want to automate Excel to handle complex data transformations, we can help. Tips and tricks, functions and formulas, Excel Tables, PivotTables, complex formulas, array formulas, VBA, Power Query, and more.
And we'll discuss how Agentic AI can be used wherever it is appropriate, which is pretty much everywhere.
Tailored Corporate Training
Team sessions built around your workflows and data so everyone leaves able to apply their new knowledge Monday morning.
VBA Wizardry
Go beyond recorded macros. Learn to read, write, and debug VBA with AI as your assistant programmer.
Automation Masterclasses
Multiple segments on leveraging the most out of VBA and getting Excel to do everything but wash the dishes.
Commonly Requested Course Segments
| Course | Description | Duration | Prerequisites |
|---|---|---|---|
| Introduction to Excel | Our foundational course covering workbook basics, navigation, formatting, formulas, charts, Tables, PivotTables, and a taste of VBA. Recommended before any other course. | 8 hours | None |
| Dynamic Arrays | Covers Excel's modern array functions — FILTER, UNIQUE, SORT, XLOOKUP, LET, LAMBDA — and how to combine them for results that used to require dozens of helper columns. | 8 hours | Experience with Formulas and Functions |
| Excel Tips & Tricks | Our most popular course. Thirty plus years of hard-won tips, shortcuts, and techniques packed into one session. | 2–4 hours | Some Excel experience |
| Excel Tables | Best practices for structured referencing, formula columns, sorting, filtering, and pulling external data with Power Query. We wrote the book on this one. | 4 hours | Basic Excel skills |
| Excel PivotTables and Slicers | Create and manipulate PivotTables with dynamic slicers for powerful, interactive slicing and dicing of larger data sets. | 4 hours | Basic Excel skills |
| Excel Charting | Transform data into charts and graphs using Excel's built-in chart types — and learn which ones to avoid. | 4 hours | Experience using lists or tables and some experience with formulas. |
| Advanced Excel Charting | Handle data gaps, trend lines, unsupported chart types, multi-chart dashboards, and much more. | 4 hours | Excel Charting |
| Introduction to Excel VBA | Use the macro recorder and Excel object model to automate repetitive tasks, write user-defined functions, and follow coding best practices. | 4 hours | Medium Excel skill level |
| Advanced Excel VBA Part 1 | Work with core Excel objects such as workbooks, worksheets, ranges, charts, Tables, and PivotTables to automate virtually anything. | 4 hours | Introduction to Excel VBA |
| Advanced Excel VBA Part 2 | Explore shapes, classes, user forms, and Add-Ins, and build a user-defined function that returns an array of values. | 4 hours | Advanced Excel VBA Part 1 |
| Advanced Excel VBA Part 3 | Windows SDK calls, web scraping, registry access, and automating other Office applications. Many things few Excel developers know how to do. | 4 hours | Advanced Excel VBA Part 2 |
| Leveraging AI | Use AI to build formulas, generate VBA and Office Script code, and apply the rules and testing practices that make AI output trustworthy. | 4 hours | Basic Excel skills |
Pricing
We'll keep this simple. $2,000 each full or partial day, plus $50 per student with a minimum of 10 students.
Instructor-led virtual training is $250 per hour for up to 50 students with a minimum of four hours.
All instructor-led training is offered both on-site and off-site. When bringing us on-site more than 30 miles from home, we ask that you also cover traveling and lodging expenses — and some burgers.
Let's Talk Training
Tell us where your team is stuck or where they want to go and we'll put together a training plan that fits your needs.