Make Excel do the heavy lifting
From formulas and pivot tables to automated dashboards and VBA macros — this is the practical, jargon-free Excel training that actually sticks, built for people who have real work to do.

"I built this course around one rule: show you a real example first, explain why it works second — because that's the order your brain actually learns."
— Tracy Burke

What you'll learn
What you'll be able to do
- Build complex nested formulas (IF, VLOOKUP, INDEX/MATCH) with total confidence
- Design dynamic pivot tables and pivot charts to summarize thousands of rows in seconds
- Create professional, interactive dashboards that update automatically with new data
- Automate repetitive tasks using macros and an introduction to Excel VBA
- Clean and transform messy real-world data using Power Query
- Apply data-validation rules, conditional formatting, and named ranges to eliminate errors
How it works
A school that adapts to you
This isn't a set of static videos. Every lesson is generated live and tuned to where you actually are.
We learn your level
A quick placement check tailors your starting point so you're never bored or lost.
Lessons adapt as you go
Each lesson is written for your pace and your goal, adjusting as your skills grow.
Your AI coach keeps you moving
Checkpoints, feedback, and gentle nudges turn progress into a real result.
The curriculum
What's inside your school
6 modules · 28 lessons

Excel Foundations & Smart Navigation
Build the essential habits, terminology, and workspace skills that every advanced technique in this course depends on.
- 1.1The Excel Interface & Workbook EssentialsIncluded
- 1.2Data Entry Best Practices & Cell FormattingIncluded
- 1.3Named Ranges & Structured TablesIncluded
- 1.4Data Validation & Dropdown ControlsIncluded
Formulas & Functions Mastery
Progress from basic arithmetic to powerful nested formulas that look up, test, and calculate across large datasets.
- 2.1Formula Logic & Absolute vs. Relative ReferencesIncluded
- 2.2Core Functions: SUM, AVERAGE, COUNT, and Text FunctionsIncluded
- 2.3Logical Functions: IF, AND, OR, and Nested IFsIncluded
- 2.4Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUPIncluded
- 2.5Advanced Lookups: INDEX, MATCH, and Nested CombinationsIncluded
Data Cleaning & Transformation with Power Query
Import, reshape, and clean messy real-world data from multiple sources without writing a single formula.
- 3.1Introduction to Power Query & the Query EditorIncluded
- 3.2Cleaning Messy Data: Removing Errors, Duplicates & BlanksIncluded
- 3.3Splitting, Merging & Reshaping ColumnsIncluded
- 3.4Combining Multiple Sources with Append & MergeIncluded
- 3.5Refreshable Queries & Loading Clean Data to ExcelIncluded
Pivot Tables, Pivot Charts & Data Analysis
Summarize, group, and visualize thousands of rows of data instantly using Excel's most powerful analysis tools.
- 4.1Building Your First Pivot TableIncluded
- 4.2Grouping, Filtering & SlicersIncluded
- 4.3Calculated Fields, Value Summaries & Show Values AsIncluded
- 4.4Pivot Charts & Conditional Formatting on Pivot DataIncluded
Professional Dashboards & Data Visualization
Design clean, interactive dashboards that update automatically and communicate insights at a glance.
- 5.1Dashboard Planning & Layout PrinciplesIncluded
- 5.2Building Dynamic Charts Linked to Live DataIncluded
- 5.3Conditional Formatting for Visual StorytellingIncluded
- 5.4Linking Slicers & Timelines Across Multiple Pivot TablesIncluded
- 5.5Polishing & Protecting Your Dashboard for SharingIncluded
Automation with Macros & Excel VBA
Record and write code to automate repetitive tasks, saving hours of manual work every week.
- 6.1Recording Your First MacroIncluded
- 6.2Introduction to the VBA Editor & Code StructureIncluded
- 6.3Writing Basic VBA: Variables, Loops & ConditionalsIncluded
- 6.4Automating Common Workflows: Formatting, Copying & ReportingIncluded
- 6.5Assigning Macros to Buttons & Sharing Macro-Enabled WorkbooksIncluded
Who it's for
Is this you?
The overworked analyst
You're already living in spreadsheets — this course makes you the fastest, most trusted person in the room.
The admin drowning in repetitive tasks
Macros and Power Query will automate the manual work that's eating your afternoons, for good.
The student building marketable skills
Walk into any job interview able to demonstrate pivot tables, dashboards, and VBA — and actually mean it.
The manager who needs better reports
Learn to build dynamic dashboards that update automatically so your team always has the numbers they need.
The self-taught user filling in the gaps
You've picked things up as you go — this course gives you the coherent foundation that ties it all together.
The small business owner wearing every hat
Budget tracking, inventory, sales summaries — do it all yourself, accurately, without hiring a specialist.
Questions
Frequently asked
Your teacher
A note from your teacher
Tracy Burke
If you're reading this, there's a good chance you already spend a meaningful chunk of your day inside Excel — and an equally good chance that a lot of that time is more painful than it needs to be. You're re-entering the same data. You're copy-pasting between sheets. You're double-checking formulas that you're not entirely sure you trust. You've Googled "VLOOKUP not working" more times than you'd like to admit.
I know that feeling well. It's not a skill gap, exactly — it's more like a confidence gap. You know Excel can do more. You've seen a colleague whip up something in ten minutes that would have taken you two hours. You just haven't had someone sit down next to you and show you how, step by step, with examples that actually look like your real work.
That's exactly what Excel Unlocked is. I built this course around a single principle: practical examples always come before theory. You'll see a real-world scenario — a sales report, a messy data import, a reporting dashboard someone needs by Friday — and then we'll talk about why the tool works the way it does. That sequence matters. It means you're learning in context, not memorizing syntax in a vacuum.
We cover the full picture, from solid foundations like named ranges and data validation (the unglamorous stuff that makes everything else work) all the way through Power Query, pivot tables, professional dashboards, and your first real automation with macros and VBA. Nothing is skipped, nothing is hand-waved, and I promise you we keep it moving — because nobody needs a twenty-minute lecture about cell formatting.
By the time you finish, you won't just know more Excel features. You'll think about data differently. You'll open a messy spreadsheet and see the path through it. You'll build something and trust it. That shift — from uncertain to confident, from slow to genuinely fast — is what this course is actually about.
Come on in. Your spreadsheets are waiting.
— Tracy Burke
Start your journey today
Get instant access — learn at your own pace with an AI coach in your corner.
$39/mo
Recurring billing · cancel anytime
Enrolling a child? Sign up as a parent — you'll add your student right here after.
Secure checkout · Instant access
- 6 modules, 28 lessons
- AI-adaptive lessons tuned to your level
- Quizzes & checkpoints to lock in progress
- Your own AI learning coach
- Learn on any device, at your pace
- Full access for as long as you're subscribed