FormulaCamp
Completed
Curriculum

The FormulaCamp curriculum

16 tracks from the basics to automation: theory, auto-checked tasks, quizzes and projects. Start with the first track or pick yours by level.

Paths by profession

Excel for accountants, HR, finance, sales and more, plus interview prep: the lessons that matter for your job, in the right order. All paths

Learning path

Accounting & Bookkeeping

Excel for accountants and bookkeepers: reconcile ledgers, clean bank exports, build payroll and P&L sheets, and audit your own work.

29 lessons · about 8 h0 / 29
Learning path

Finance & FP&A

Excel for finance and FP&A: budgets, variance reports, scenarios, NPV and IRR, unit economics and a clean three-sheet financial model.

28 lessons · about 9 h0 / 28
Learning path

HR & People Ops

Excel for HR: headcount and turnover reports, tenure and leave calculations, clean employee lists, payroll sheets and protected workbooks.

27 lessons · about 7.1 h0 / 27
Learning path

Sales & Marketing Ops

Excel for sales and marketing ops: clean CRM exports, build pipeline and campaign reports, track CAC and conversion, and ship a sales dashboard.

26 lessons · about 7.8 h0 / 26
Learning path

Data Analyst

Excel for data analysts: clean raw data, join tables with XLOOKUP, use PivotTables, Power Query and DAX, and back your findings with statistics.

29 lessons · about 9.2 h0 / 29
Learning path

Operations & Supply Chain

Excel for operations and supply chain: inventory and order tracking, delivery dates, ABC/XYZ analysis, production planning with Solver and dashboards.

29 lessons · about 8.6 h0 / 29
Learning path

Students & First Job

Excel for students and first-time employees: the skills every office job expects, from formulas and charts to PivotTables, in a short, practical path.

25 lessons · about 6.3 h0 / 25
Learning path

Excel Interview Prep

Excel interview questions and test prep: practice the VLOOKUP, SUMIFS, IF, PivotTable, data cleaning and chart tasks employers ask, with worked lessons.

29 lessons · about 7.3 h0 / 29

Looking for tasks only? Browse all practice exercises →

1. Beginner

Track 1

Excel Fundamentals

The interface, workbooks and worksheets, cells and ranges, entering data, AutoFill, and file formats.

Available0 / 9

9 free lessons

Track 2

Formatting and Presentation

Number and date formats, fonts, fills, borders, conditional formatting, and polished reports.

Available0 / 11

11 free lessons

Track 3

Formula Basics

How formulas work, operators, relative, absolute and mixed references, links between sheets, and errors.

Available0 / 14

14 free lessons

2. Confident User

Track 4

Excel Functions

The essential functions for math, statistics, logic, text, dates and time, taught with real-world examples.

Available0 / 25

9 free lessons

Track 5

Advanced Formulas

VLOOKUP, INDEX+MATCH, XLOOKUP, dynamic arrays, FILTER, UNIQUE, LET, and LAMBDA.

Available0 / 20

7 free lessons

Track 6

Data Management and Cleaning

Sorting, filters, duplicates, Text to Columns, data validation, dependent lists, and cleaning up text, numbers and dates from CSV files.

Available0 / 10

4 free lessons

Track 7

Charts and Dashboards

Column, line, pie, doughnut, scatter and combo charts, choosing the right chart type, and building a KPI dashboard.

Available0 / 6

2 free lessons

Track 8

PivotTables

PivotTables: rows, columns, values, aggregates, and cross-tab reports.

Available0 / 6

2 free lessons

3. Analyst

Track 9

Power Query

ETL without formulas: load, clean and combine data, and write M code.

Available0 / 8

2 free lessons

Track 10

Power Pivot and DAX

Data models, relationships, the star schema, DAX measures, filter context, and time intelligence.

Available0 / 8

2 free lessons

Track 11

Finance and Business Analytics

Loans, deposits, NPV/IRR, Goal Seek, budgets, payroll, and sales reports.

Available0 / 16

1 free lesson

Track 12

Statistics and Data Analysis

Mean, median, spread, ranks, correlation, and linear forecasting.

Available0 / 11

1 free lesson

4. Expert

Track 13

VBA and Macros

Recording macros, the VBA editor, Range and Worksheet objects, loops, events, and forms.

Available0 / 7

2 free lessons

Track 14

Office Scripts and Power Automate

Automate Excel in the cloud with TypeScript and Power Automate flows.

Available0 / 6

2 free lessons

Track 15

Python in Excel and AI

The PY function, pandas, charts, Copilot, and how to check AI answers.

Available0 / 6

2 free lessons

Track 16

Professional Excel Engineering

Workbook architecture, protection, formula auditing, collaboration, and optimization.

Available0 / 7

2 free lessons