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.
=XLOOKUP(B3, Prices!A:A, Prices!C:C)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Product | Qty | Price |
| 2 | 10/03 | Coffee 1lb | 12 | $8.50 |
| 3 | 10/03 | Green tea | 6 | $4.90 |
| 4 | 10/04 | Rice 2lb | 20 | $3.20 |
| 5 | 10/04 | Olive oil | 8 | $11.75 |
Is it for you?
No coding knowledge needed. Just some experience using Excel or Google Sheets.
Syllabus
Six short modules. Each one ends with a real spreadsheet you solve yourself.
Tidy up messy data
TRIM, PROPER, text to columns and removing duplicates.
Look up and combine data
XLOOKUP, VLOOKUP and INDEX + MATCH, and when to use each one.
Sum and count with conditions
SUMIFS and COUNTIFS for reports by month, branch or salesperson.
Dates and deadlines
NETWORKDAYS, EOMONTH and conditional formatting so you never miss a due date.
Pivot tables and charts
Summarize thousands of rows in seconds and present them clearly.
Automate the repetitive
Record simple macros and merge several spreadsheets into one.
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.
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.