Full Syllabus
Each lesson takes just a few minutes: you read an idea, practice with challenges that are graded instantly, and Barty, your AI tutor, explains anything you don't understand. Times are estimates and depend on your pace.
💡We recommend going step by step: each lesson builds on the previous one, so you learn better. If you want to reinforce a specific topic, you can start any unit or lesson.
1Level Basic · 12 lessons · ≈ 2 h
Excel from Scratch
+
Level Basic · 12 lessons · ≈ 2 h
Excel from Scratch
Master the essentials: cells, formulas, formats, and tables.
By the end: You will build organized spreadsheets with basic formulas and no errors.
Unit 1
⏱ ≈ 26 minFirst Steps
- 1.The Excel InterfaceStart ›
- 2.Cells, Rows, and ColumnsStart ›
- 3.Data TypesStart ›
- 4.Number and Date FormatsStart ›
Unit 2
⏱ ≈ 28 minFormulas
- 5.Formulas and OperatorsStart ›
- 6.SUM, AVERAGE, MIN, and MAXStart ›
- 7.Relative and Absolute ReferencesStart ›
- 8.Common Errors and How to Fix ThemStart ›
Unit 3
⏱ ≈ 28 minOrganizing
- 9.Sort and FilterStart ›
- 10.Excel TablesStart ›
- 11.Conditional FormattingStart ›
- 12.Print and ShareStart ›
2Level Intermediate · 12 lessons · ≈ 2 h
Functions and Analysis
+
Level Intermediate · 12 lessons · ≈ 2 h
Functions and Analysis
Use the functions your job calls for and analyze data quickly.
By the end: You will solve office tasks with logical and lookup functions.
Unit 3
⏱ ≈ 28 minText and Dates
- 9.Text functionsStart ›
- 10.Date FunctionsStart ›
- 11.Clean Up DataStart ›
- 12.Charts That CommunicateStart ›
3Level Advanced · 12 lessons · ≈ 2 h
Professional Data Analysis
+
Level Advanced · 12 lessons · ≈ 2 h
Professional Data Analysis
PivotTables, Power Query, and models to analyze thousands of data points.
By the end: You will automate the preparation and analysis of large datasets.
Unit 1
⏱ ≈ 28 minPivotTables
- 1.Create Pivot TablesStart ›
- 2.Calculated fieldsStart ›
- 3.Slicers and TimelinesStart ›
- 4.PivotChartsStart ›
Unit 2
⏱ ≈ 28 minPower Query
- 5.Import Data from Multiple SourcesStart ›
- 6.Transform and CleanStart ›
- 7.Append and Merge QueriesStart ›
- 8.Update with One ClickStart ›
Unit 3
⏱ ≈ 29 minModels
- 9.Data Model and RelationshipsStart ›
- 10.Introduction to DAXStart ›
- 11.Scenarios and Goal SeekStart ›
- 12.Dynamic Array FunctionsStart ›
4Level Expert · 12 lessons · ≈ 2 h
Dashboards and Automation
+
Level Expert · 12 lessons · ≈ 2 h
Dashboards and Automation
Build professional dashboards and automate repetitive tasks.
By the end: You will deliver professional-grade dashboards and automations.
Unit 1
⏱ ≈ 28 minDashboards
- 1.Dashboard DesignStart ›
- 2.KPIs and VisualizationStart ›
- 3.Interactivity with ControlsStart ›
- 4.Telling Stories with DataStart ›
Unit 2
⏱ ≈ 28 minAutomation
- 5.Recording macrosStart ›
- 6.Introduction to VBAStart ›
- 7.Automate ReportsStart ›
- 8.Excel with AIStart ›
Unit 3
⏱ ≈ 30 minBeyond the Basics
- 9.Power BI for Excel UsersStart ›
- 10.Good Practices and AuditingStart ›
- 11.Reusable TemplatesStart ›
- 12.Excel as a Professional ServiceStart ›
5Level Crack · 4 lessons · ≈ 76 min
Excel Crack
+
Level Crack · 4 lessons · ≈ 76 min
Excel Crack
Master the tricks that separate the advanced user from the expert everyone turns to.
By the end: You'll solve in minutes what takes others days.
Unit 1
⏱ ≈ 31 minElite Challenges
- 1.Elite Formulas with LET and LAMBDAStart ›
- 2.Impossible Data Cleaning with Power QueryStart ›
- 3.Automate with Macros Without Breaking AnythingStart ›
- 4.Final Boss Challenge: The Dashboard That Updates ItselfStart ›
🛠Practical specialization · 8 lessons · ≈ 2 h
Excel for Your Business
+
Practical specialization · 8 lessons · ≈ 2 h
Excel for Your Business
Track inventory, sales, cash flow, and payroll for a small business using your own Excel templates.
By the end: You will have full control of a small business using your own templates.
Unit 1
⏱ ≈ 28 minBusiness Control
- 1.Inventory with Stock AlertsStart ›
- 2.Daily Sales LogStart ›
- 3.Cash Flow and Monthly ExpensesStart ›
- 4.Invoices and QuotesStart ›
Unit 2
⏱ ≈ 28 minReports and Staff
- 5.Payroll and Work HoursStart ›
- 6.Monthly Report with Pivot TablesStart ›
- 7.Sales Dashboard for the OwnerStart ›
- 8.Protecting and Sharing Your TemplatesStart ›
Start today, at your own pace.
The first lesson and the placement test are free.
Create my free account →