Excel Unlocked
Log in

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.

28 lessonsAI-adaptiveCancel anytimeLearn anywhere
Excel Unlocked

"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

1

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
2

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
3

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
4

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
5

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
6

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

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