Design demo: the course, the instructor and the prices are fictional. · Versión en español · ← All demos
Enroll
Online course · 100% hands-on

Stop copying and pasting. Learn the 12 formulas you use every day.

For people who work with spreadsheets and feel it takes too long: invoicing, inventory, payroll or reports. With real office files, not textbook examples.

I want to enroll Starts October 6 · limited seats

Is it for you?

No coding knowledge needed. Just some experience using Excel or Google Sheets.

Office staffWho build the same reports every week and want to do them in minutes.
Small business ownersWho track inventory, sales and expenses in spreadsheets that became a mess.
Job seekersIntermediate Excel shows up in most office job listings.

Syllabus

Six short modules. Each one ends with a real spreadsheet you solve yourself.

Module 1

Tidy up messy data

TRIM, PROPER, text to columns and removing duplicates.

1 h 10 min
Module 2

Look up and combine data

XLOOKUP, VLOOKUP and INDEX + MATCH, and when to use each one.

1 h 30 min
Module 3

Sum and count with conditions

SUMIFS and COUNTIFS for reports by month, branch or salesperson.

1 h 15 min
Module 4

Dates and deadlines

NETWORKDAYS, EOMONTH and conditional formatting so you never miss a due date.

50 min
Module 5

Pivot tables and charts

Summarize thousands of rows in seconds and present them clearly.

1 h 40 min
Module 6

Automate the repetitive

Record simple macros and merge several spreadsheets into one.

1 h 20 min

Total: 7 h 45 min of video + 6 practice spreadsheets

What's included

  • 12 months of access to the recorded lessons.
  • 6 practice spreadsheets with step-by-step solutions.
  • Questions answered in the course group within 48 business hours.
  • Certificate of completion.
  • Works with Excel 2021, Microsoft 365 and Google Sheets.
Launch price
$49 one-time

Not what you expected? Get a full refund within the first 7 days.

Your instructor

Valerie Ruiz

Accountant. For ten years she built the management reports of a distributor with five branches, and she teaches exactly the tools she used every day.

FAQ

Are the classes live?

No. They're recorded, so you watch them whenever you want. Questions are answered in writing in the course group.

Does it work with Google Sheets?

Yes. When a formula has a different name or syntax in Google Sheets, we show it in the same lesson.

Do I need a powerful computer?

No. Any computer that runs Excel or a web browser is enough.