Stop guessing your way through spreadsheets. In 110 practical lessons, build the formulas, functions, and data skills that save hours every week — taught through real business scenarios, not abstract exercises.
Most professionals learn Excel by trial and error. That means gaps, workarounds, and hours lost to tasks that should take minutes.
Manually formatting, copying, and recalculating the same reports every week or month.
Building formulas by trial and error because no one taught you the underlying logic.
Spending time cleaning, fixing, and reorganizing data before you can even start analyzing it.
Knowing the answer is in the data but not being able to pull it out clearly or present it with confidence.
A structured path from basic operations to advanced data lookups — each module builds on the last.
Build a solid foundation in how Excel actually calculates. You'll understand cell references, write confident formulas, and use essential functions like SUM, AVERAGE, COUNT, and ROUND — the building blocks behind every serious spreadsheet.
Apply formulas to real business scenarios. Calculate market share, profit margins, variance analysis, year-on-year change, and forecasted results — the calculations your manager actually cares about.
Make your spreadsheets think. Use IF logic to evaluate results, flag exceptions, and automate decisions — from simple yes/no checks to multi-layered nested conditions that handle real-world complexity.
The biggest module — and the one that pays for itself fastest. Eliminate repetitive work with fill series, Flash Fill, and text functions. Master filtering, sorting, and duplicate removal to clean messy data in minutes instead of hours.
Keep your work safe from accidental edits and unauthorized access. Set passwords, lock cells and sheets, protect workbook structure, and control exactly what others can change — essential when sharing files across teams.
Dates and times are where most Excel users struggle. You'll learn how Excel stores dates internally, then master weekday and workday calculations, time intervals, end-of-month logic, age calculations, and shift/break tracking.
The skill that separates spreadsheet users from spreadsheet builders. Master VLOOKUP and XLOOKUP to pull data across tables, merge datasets, find matches and mismatches, and build dynamic reports that update themselves when source data changes.
Turn thousands of rows into instant business reports. You'll learn to build, filter, group, and visualize summarized data with Pivot Tables — the single most powerful reporting feature in Excel and the perfect capstone for everything you've learned in Modules 1–7.
Short, focused lessons you can fit around your work schedule.
Downloadable work files so you can follow along and practice hands-on.
Excel Know How certificate upon completion — share with your employer or LinkedIn.
Learn at your own pace. Come back to any lesson whenever you need a refresher.
Stuck on something? Reach out via email and get help from the instructor.
Not the right fit? Full refund within 14 days, no questions asked.
Data Analytics Instructor & BI Consultant · SOFIUS SIA
With over 25 years of daily Excel use and 10 years in Power BI, every lesson in this course comes from real business scenarios I've encountered in practice — not textbook theory. I've trained 3,500+ professionals at companies including Atea, LMT, Grindeks, and Latvenergo.
I've also delivered data analytics programmes at Riga Business School and Estonian Business School. When I'm not teaching, I build Power BI dashboards and Excel automation tools for enterprise clients.
"This Excel course is excellent for people who want to gain a general and in-depth understanding of Excel functions and capabilities. The videos are easy to understand and comprehend."
"The information is presented in easy-to-understand language for everyone. I particularly like the lecturer's tone of voice. Everything is taught through practical examples."
"Complicated Made Simple — I learned a lot. Complicated things are explained simply and understandably! Ivars is the best specialist in his field!"
Full course access with both options. Same content, same certificate — pick what works for your budget.
3 monthly payments · €87 total
Single payment · Full access immediately
110 practical lessons. Real business scenarios. Skills you'll use tomorrow.