Barter AI AcademyStart for free
School with AI tutor · Academia Barter Rubio

Excel Course

Formulas, tables, charts, pivot tables, dashboards, and financial control reports for your job or business.

🔥 Join the more than 15,600 students who have already trained with the Academia Barter Rubio.

5 levels

from Basic to Crack + 1 specialization

60 lessons

6 final projects

≈ 12 hours

in total, at your own pace

≈ 7 weeks

with 15 min a day

Start the first lesson for free →

No credit card · Free placement test to find out where to start

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.

1

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 min

First Steps

  1. 1.The Excel InterfaceStart ›
  2. 2.Cells, Rows, and ColumnsStart ›
  3. 3.Data TypesStart ›
  4. 4.Number and Date FormatsStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Formulas

  1. 5.Formulas and OperatorsStart ›
  2. 6.SUM, AVERAGE, MIN, and MAXStart ›
  3. 7.Relative and Absolute ReferencesStart ›
  4. 8.Common Errors and How to Fix ThemStart ›
▶ Start this unit

Unit 3

⏱ ≈ 28 min

Organizing

  1. 9.Sort and FilterStart ›
  2. 10.Excel TablesStart ›
  3. 11.Conditional FormattingStart ›
  4. 12.Print and ShareStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Hoja de control de gastos con fórmulas y formato🎓 Level certificateTools: Microsoft Excel, Google Sheets
2

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 1

⏱ ≈ 28 min

Logical Functions

  1. 1.IF and Nested IFStart ›
  2. 2.AND, ORStart ›
  3. 3.COUNTIF and SUMIFStart ›
  4. 4.IFERRORStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Lookup

  1. 5.VLOOKUPStart ›
  2. 6.XLOOKUPStart ›
  3. 7.INDEX and MATCHStart ›
  4. 8.Data Validation and ListsStart ›
▶ Start this unit

Unit 3

⏱ ≈ 28 min

Text and Dates

  1. 9.Text functionsStart ›
  2. 10.Date FunctionsStart ›
  3. 11.Clean Up DataStart ›
  4. 12.Charts That CommunicateStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Reporte de ventas con búsquedas, condiciones y gráficos🎓 Level certificateTools: Microsoft Excel, Google Sheets
3

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 min

PivotTables

  1. 1.Create Pivot TablesStart ›
  2. 2.Calculated fieldsStart ›
  3. 3.Slicers and TimelinesStart ›
  4. 4.PivotChartsStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Power Query

  1. 5.Import Data from Multiple SourcesStart ›
  2. 6.Transform and CleanStart ›
  3. 7.Append and Merge QueriesStart ›
  4. 8.Update with One ClickStart ›
▶ Start this unit

Unit 3

⏱ ≈ 29 min

Models

  1. 9.Data Model and RelationshipsStart ›
  2. 10.Introduction to DAXStart ›
  3. 11.Scenarios and Goal SeekStart ›
  4. 12.Dynamic Array FunctionsStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Análisis de datos con Power Query y tabla dinámica🎓 Level certificateTools: Excel with Power Query and Power Pivot
4

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 min

Dashboards

  1. 1.Dashboard DesignStart ›
  2. 2.KPIs and VisualizationStart ›
  3. 3.Interactivity with ControlsStart ›
  4. 4.Telling Stories with DataStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Automation

  1. 5.Recording macrosStart ›
  2. 6.Introduction to VBAStart ›
  3. 7.Automate ReportsStart ›
  4. 8.Excel with AIStart ›
▶ Start this unit

Unit 3

⏱ ≈ 30 min

Beyond the Basics

  1. 9.Power BI for Excel UsersStart ›
  2. 10.Good Practices and AuditingStart ›
  3. 11.Reusable TemplatesStart ›
  4. 12.Excel as a Professional ServiceStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Dashboard interactivo de un negocio con automatización🎓 Level certificateTools: Excel, VBA macros, Power BI
5

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 min

Elite Challenges

  1. 1.Elite Formulas with LET and LAMBDAStart ›
  2. 2.Impossible Data Cleaning with Power QueryStart ›
  3. 3.Automate with Macros Without Breaking AnythingStart ›
  4. 4.Final Boss Challenge: The Dashboard That Updates ItselfStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Reto jefe: un tablero automático que se actualiza solo con datos reales🎓 Level certificateTools: LAMBDA, LET, dynamic arrays, Power Query, macros
🛠

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 min

Business Control

  1. 1.Inventory with Stock AlertsStart ›
  2. 2.Daily Sales LogStart ›
  3. 3.Cash Flow and Monthly ExpensesStart ›
  4. 4.Invoices and QuotesStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Reports and Staff

  1. 5.Payroll and Work HoursStart ›
  2. 6.Monthly Report with Pivot TablesStart ›
  3. 7.Sales Dashboard for the OwnerStart ›
  4. 8.Protecting and Sharing Your TemplatesStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Libro de Excel para un negocio real: inventario, ventas, caja y reporte mensual🎓 Level certificateTools: Excel, tables, data validation, pivot tables

Start today, at your own pace.

The first lesson and the placement test are free.

Create my free account →