Course · Excel From Scratch · lifetime access

Stop faking it. Real Excel.

The fastest map from “I can get by in a spreadsheet” to the Excel your job actually needs. Formulas, dashboards, and automation you use this week.

See what’s included

7 days to cancel · CDC art. 49 · pay once · lifetime access

Sales dashboard · Sep 2026

live

Revenue

R$ 184,3 mil

+14,2%

Orders

1.248

+9,1%

Ticket

R$ 147,70

+4,6%

Revenue, 9 months

Regions

  • North R$ 38.2k +12%
  • Southeast R$ 91.4k +18%
  • South R$ 34.1k +7%
  • Northeast R$ 20.6k +22%
VLOOKUP · SUMIFS · Pivot table goal 92%

0+

students

0+

lessons

0h

of training

0+

projects

PROCV PROCX SOMASES SE ÍNDICE CORRESP TABELA DINÂMICA POWER QUERY POWER PIVOT MACROS DASHBOARD SOMA CONT.SE TEXTO DATAS PROCV PROCX SOMASES SE ÍNDICE CORRESP TABELA DINÂMICA POWER QUERY POWER PIVOT MACROS DASHBOARD SOMA CONT.SE TEXTO DATAS
1.247+

Students

150+

Video lessons

18 hours

Of training

12+

Real projects

The problem

Stop pretending you know Excel

You are one broken formula away from looking lost. This is what stalls a career:

  1. 01

    Everything by hand

    You copy and recopy data for hours. Other people’s files close in minutes. Yours looks like it will break on the next filter.

  2. 02

    Google does not save you

    You search “how to VLOOKUP” for the tenth time, paste a formula you do not understand, and hope it survives the meeting.

  3. 03

    Invisible at the table

    The good projects go to “the person who is good in Excel”. You stay operational and watch the promotion pass.

The turn

The perfect spreadsheet is not luck. It is engineering.

Before

Sheet1.xlsx — DO NOT TOUCH FINAL COPY 3
Month Sales Cost Status
Jan 12000 error VLOOKUP??
Feb 11.4 #REF!
Mar paste here 8900 ask João
Apr 15000 12000 N/A
May ?????? update
Jun 18000 broken formula #VALUE!
Jul N/A 11000 ask IT
Aug 21000 #DIV/0!

After

Sales dashboard · Sep 2026

live

Revenue

R$ 184,3 mil

+14,2%

Orders

1.248

+9,1%

Ticket

R$ 147,70

+4,6%

Revenue, 9 months

Regions

  • North R$ 38.2k +12%
  • Southeast R$ 91.4k +18%
  • South R$ 34.1k +7%
  • Northeast R$ 20.6k +22%
VLOOKUP · SUMIFS · Pivot table goal 92%
  • Update the report by hand every Monday
  • Google a formula before every task
  • Break the file and ask IT for help
  • Watch a colleague build a dashboard like magic
  • A dashboard that updates and impresses your manager
  • Write a formula faster than you can search
  • Finish in 10 minutes what used to take hours
  • Be the person everyone asks

150 lessons · 18 hours · 12+ projects you use at work

The product

This is not a “click here” course.
It is Excel taken apart.

Each module opens one piece — formula, pivot, macro, query — and puts it back into the file you deliver at work. 150 lessons. 12 projects. No fluff.

12+ files

Projects you open on Monday.

Finance

Budget

Cash control that updates itself — personal or company.

Operations

Inventory

In, out, reorder point. No hidden red line.

Dashboard

Sales

The board sales opens on Monday and the director understands in 8 seconds.

Report

Finance pack

A short P&L, cash flow, and KPIs — generated, not copied.

Projects

Gantt

A visual timeline with dependencies, no extra software.

Automation

Invoices

One click, one PDF. Number, client, taxes.

8 modules · 18h

What is inside Excel From Scratch

150 lessons sequenced for a fast win at work. Open a module.

1 Excel introduction Navigate, shortcuts, first workbook. ▼
  • Interface and navigation
  • Cells, rows, columns, sheets
  • Shortcuts that multiply speed
  • Your first workbook
2 Foundations Input, format, references. ▼
  • Enter data the right way
  • Format cells, numbers, and dates
  • Relative, absolute, and mixed references
  • Basic formulas and calculations
  • Conditional formatting
3 Essential formulas SUM, IF, VLOOKUP, XLOOKUP, SUMIFS. ▼
  • SUM for fast totals
  • IF and nested logic
  • VLOOKUP and XLOOKUP to join tables
  • SUMIFS and COUNTIF
  • Text: CONCAT, LEFT, RIGHT
  • Dates and times
4 Data visualization Charts, pivot, dashboard. ▼
  • Charts: bar, line, scatter, combo
  • Pivot tables from zero
  • Dashboard principles
  • Slicers and timelines
  • Sparklines
5 Automation and macros Macros, buttons, VBA without drama. ▼
  • Record the first macro — no code
  • Edit and adjust macros
  • Buttons and forms
  • VBA for people who do not program
  • Errors and debugging
6 Advanced analysis Power Query, Power Pivot, Solver. ▼
  • Power Query: clean dirty data
  • Power Pivot for millions of rows
  • Stats and projection
  • Scenarios and what-if analysis
  • Solver to optimize
7 Real projects What you deliver at work. ▼
  • Personal and company budget
  • Inventory control
  • Sales dashboard
  • Automatic finance reports
  • Gantt-style timeline
  • Invoice generator
8 Close-out Checklist, certificate, next step. ▼
  • Review and what not to forget
  • Best-practice checklist
  • Certificate of completion
  • Where to go next
🎓

Built by Rockmah

Practical courses for work and for people who create. No guru energy, no fluff — just the skill that raises the level.

One payment

One investment. A lifetime skill.

Stop faking it. Start delivering. The price may rise as the content grows.

Rockmah

Excel From Scratch

Complete Excel training

R$ 199,00

One-time payment · access forever

  • ✓ 150+ video lessons · 18 hours
  • ✓ 12 projects with downloadable files
  • ✓ Practice workbooks in every module
  • ✓ Certificate of completion
  • ✓ Lifetime updates, no subscription
  • ✓ 7 days to cancel — CDC art. 49

🛡️ 7 days to cancel under CDC art. 49 — full refund, no theater

Bought Excel? Add AI Video Creation Mastery

Questions? We answer.

What you need to know before you start

Where do I start if I have never really opened Excel? ▼

Module 1. It assumes zero. Interface, data entry, first formula. Around lesson 10 you already build a useful sheet.

Does it work on Mac and Windows? ▼

Yes. We cover both and call out differences when they matter. 95% of the content is the same. Excel Online and Google Sheets cover most of it — Power Query and VBA are desktop.

Do I need VBA or coding? ▼

No. Formulas and native tools come first. VBA enters in Module 5, starting with recording a macro — zero code. You produce without writing a line.

Is R$ 199,00 worth it? ▼

If you save one hour a week, you recover the price in a month. 150 lessons, 12 projects, updates, and a certificate. Equivalent courses ask for much more. Seven days to change your mind, no theater.

How does the 7-day refund work? ▼

Under CDC art. 49 you cancel within 7 days of purchase and get the money back, no questions. Email support@rockmah.com with the order number.

What does lifetime access mean? ▼

Pay once, stay in forever. New lessons or updates land in your account at no extra cost. No subscription, no expiry date.

Is there a certificate? ▼

Yes, a course completion certificate. It is not an MEC diploma or a third-party professional certification.

Now

Stop faking it. Start studying.

You are one spreadsheet skill away from looking like the most organized person in the room. Your manager notices.

One-time payment · updates forever · the price may rise as the content grows

🛡️ 7 days to cancel (CDC art. 49)