The Best Way to Learn Excel Fast
for Busy Professionals (Guaranteed)

6,328 students, 153 reviews

“Zero to Hero” is an online course that turns beginners into Excel superusers in 14 hours.

I have found this instruction/ training to be far superior to any other that is on the market. You get lifetime access and awesome support. Zero to Hero is absolutely unsurpassed by other Excel courses! 5 Stars!

Patrick O'Connell, Zero to Hero student

“Zero to Hero” is all you need to go from beginner to Excel superuser

6,328 students, 127 reviews

“Zero to Hero” is an online course that turns beginners into Excel superusers in 14 hours.

I have found this instruction/ training to be far superior to any other that is on the market. You get lifetime access and awesome support. Zero to Hero is absolutely unsurpassed by other Excel courses! 5 Stars!

Patrick O'Connell, Zero to Hero student

Course content

Zero to Hero takes 14 hours to complete.

There are 7 modules with 199 video lessons.

You get lifetime access to all lessons and free updates.

Finally, you can rewatch all lessons as many times as you want.

“The Foundation” teaches you the basics of Excel, step-by-step.

In the first module, you learn how Excel works from scratch.

  • Introduction to the course (0:51)
  • What you’ll learn in this course (0:48)
  • How to practice (1:52)
  • Important Excel terms (0:59)
  • Important menus/toolbars (2:18)
  • Inserting and deleting columns and rows (0:59)
  • Copy and paste (2:58)
  • Formulas (2:03)
  • References (4:08)
  • References to other sheets and workbooks (2:39)
  • Functions (1:26)
  • Adding numbers with the SUM-function (1:58)
  • How to use all functions in Excel (2:21)
  • General formatting (1:47)
  • Colors (1:42)
  • Borders (2:31)
  • Text manipulation (1:44)
  • Choosing and inserting charts (2:39)
  • Modifying charts (2:46)
  • Find and Replace (2:01)
  • Freeze panes (0:46)
  • Filters (2:16)
  • Comments (1:33)
  • Tables (3:15)
  • Making the data fit the paper (2:47)
  • Protecting your work in Excel (2:08)
  • Certificate (0:47)
  • What now? (0:58)
  • Assignments (~1 hour)

In “Formatting” you learn to create professional spreadsheets.

In the second module, you learn to create spreadsheets that make sense and are easy to navigate.

  • Introduction to ‘Formatting’ (0:36)
  • How to practice (1:52)
  • What is formatting all about? (1:57)
  • Fill color (0:53)
  • Font color (0:45)
  • Borders (3:30)
  • Hiding the gridlines (1:26)
  • Merge cells (1:51)
  • Text size, bolding and alignment (2:08)
  • Wrap text (1:18)
  • Useful presets, comma separator and decimals (2:29)
  • Dates (2:24)
  • Custom formats (2:02)
  • Formatting a dataset in seconds (1:04)
  • The Format Painter (1:00)
  • Clearing formatting (0:53)
  • What is Conditional Formatting? (0:43)
  • Highlight cells rules (1:46)
  • Top/Bottom rules (1:54)
  • Edit and delete rules (2:10)
  • Using multiple rules (2:29)
  • Data Bars (2:10)
  • Color Scales (2:03)
  • Icon Sets (3:11)
  • Formulas in conditional formatting (2:11)
  • Highlight entire rows based on value of a cell (2:31)
  • Finding duplicates (2:39)
  • Certificate (0:47)
  • What now? (1:01)
  • Assignments (~1 hour)

In “Functions” you learn to perform advanced calculations.

In the third module, you get an in-depth understanding of how functions work.

  • Introduction to the course (0:41)
  • What are you going to learn from this course? (0:59)
  • How to practice (1:52)
  • What is a function? (1:18)
  • How to use any function (2:40)
  • Introduction to the IF function (1:26)
  • Use the IF function (2:56)
  • Nested IF functions (5:43)
  • The IFS function (4:47)
  • IF, OR + AND (3:47)
  • SUMIF (2:41)
  • SUMIFS (3:17)
  • COUNTIF (1:26)
  • COUNTIFS (2:17)
  • MAXIFS and MINIFS (3:51)
  • LEFT, RIGHT and MID (3:19)
  • LEN (0:52)
  • SEARCH (1:37)
  • Combination of text functions (3:10)
  • Joining cells (2:06)
  • Working with Dates (2:33)
  • Dissecting dates (DAY, MONTH, YEAR functions) (1:33)
  • Find today’s date with the TODAY function (4:34)
  • Typical errors when working with functions (3:23)
  • IFERROR (2:00)
  • Evaluating formulas (1:40)
  • Named ranges (2:56)
  • Certificate (0:47)
  • What now? (1:05)
  • Assignments (~1 hour)

In “Lookup”  you learn advanced lookup functions.

In the fourth module, you learn to retrieve information across spreadsheets.

  • Introduction to ‘Lookup’ (0:37)
  • What are lookup functions all about? (1:11)
  • How to practive (1:52)
  • What is a lookup? (1:17)
  • How to use VLOOKUP (4:36)
  • How to use VLOOKUP with approximate match (2:10)
  • How to use HLOOKUP (1:49)
  • VLOOKUP vs. INDEX + MATCH (1:35)
  • The MATCH function (1:43)
  • The INDEX function (2:18)
  • INDEX+MATCH – the theory behind (0:58)
  • How to use INDEX+MATCH (4:58)
  • VLOOKUP with multiple criteria (2:56)
  • INDEX+MATCH with multiple criteria – the theory behind (1:41)
  • Use INDEX+MATCH with multiple criteria (4:19)
  • Typical errors with lookups (4:05)
  • Error handling a lookup with IFERROR (2:27)
  • Certificate (0:47)
  • What now? (1:18)
  • Assignments (~1 hour)

In “Pivot Tables”, you learn how pivot tables work and how to apply them.

In the fifth module, you learn why pivot tables are so amazing at handling data.

  • Introduction to the course (0:38)
  • What is this course all about? (0:39)
  • How to practice (1:52)
  • What is a Pivot Table and when should I use it? (2:06)
  • Making your data ready for a Pivot Table (3:37)
  • Building up the Pivot Table (2:19)
  • Rearranging the Pivot Table in seconds (0:56)
  • Change the data source/Refresh (2:04)
  • Selecting, moving, and deleting your Pivot Table (1:45)
  • Hide/Show elements (1:10)
  • Change the name and the column headers of your Pivot Table (1:13)
  • Pivot Table layouts (1:56)
  • Grand Totals and Subtotals (2:01)
  • Value Field Settings (3:14)
  • Summarizing more than one column (1:49)
  • Calculated Fields (4:00)
  • See underlying data with Pivot Table Drilldown (1:22)
  • Use data from a Pivot Table in a formula (3:08)
  • Sorting and filtering (1:35)
  • Using rules for filtering (2:03)
  • Filtering with a Slicer (1:31)
  • Filter multiple Pivot Tables with the same Slicer (1:34)
  • Report filters (1:43)
  • Grouping (4:22)
  • Pivot Table Styles (1:19)
  • General formatting (1:32)
  • Conditional Formatting (1:42)
  • What is a Pivot Chart? (0:22)
  • Create a Pivot Chart (1:59)
  • Using a Pivot Chart (1:21)
  • Sorting and filtering (1:54)
  • Certificate (0:47)
  • What’s next? (1:06)
  • Assignments (~1 hour)

In “Macros”, you learn to automate your current (repetitive) tasks.

In the sixth module, you learn how to create macros that save you time.

  • Welcome (1:14)
  • What is a macro? (1:59)
  • What you learn from this module (1:52)
  • How to practice (1:52)
  • Starting to use macros (2:12)
  • Recording a macro (2:43)
  • Playing a macro (1:22)
  • Playing a macro from a button or shortcut (2:59)
  • The Developer Tab (1:06)
  • Save a workbook with a macro (1:22)
  • Macro security (2:37)
  • Using relative references in macros (4:15)
  • The VBA editor (2:06)
  • What is VBA? (4:33)
  • Join two macros (2:45)
  • Run through a macro (2:06)
  • Editing a recorded macro (4:34)
  • Using comments to keep track of the code (2:04)
  • Starting your own code (2:28)
  • Best advice when things seem too complex (1:01)
  • Breaking down the process (1:36)
  • Shaping the structure (1:47)
  • Set formatting (2:36)
  • Add formulas (6:26)
  • Completing the job (1:12)
  • Certificate (0:47)
  • What now? (1:09)
  • Assignments (~1 hour)

In “VBA” you learn how to write custom applications in Excel.

In the seventh – and final – module, you learn what VBA is and how it works.

  • Welcome (1:22)
  • What is VBA? (0:38)
  • What you learn from this module (3:02)
  • How to practice (1:52)
  • Short recap of macros (1:47)
  • Starting out (1:32)
  • Writing in cells (3:06)
  • Copy/paste (3:17)
  • The OFFSET command (3:26)
  • Sheets (2:23)
  • Workbooks (2:47)
  • Variables (2:46)
  • Variables in practice (4:12)
  • Creating solutions to problems (1:31)
  • What are loops? (0:58)
  • Using loops to create repeated actions (2:38)
  • What are IF statements? (0:42)
  • Adding logic with IF statements (5:08)
  • Using loops and IF statements together (6:10)
  • Using normal functions in VBA code (SUMIF) (3:15)
  • Talking to the user with message boxes (3:23)
  • Getting help (0:44)
  • Speeding up code (2:40)
  • Completing the job (2:04)
  • Certificate (0:47)
  • What now? (1:32)
  • Assignments (~1 hour)

I almost passed over this course because I consider myself to be an experienced Excel user, working with Excel spreadsheets daily at work and at home. But, I’ve already learned a lot that I had never known or used before in just the Foundations module. I can’t wait to move on to the next module, and I’m very happy that I purchased the entire training suite. Thank you for this course!!!

Andrew Prouty, Zero to Hero student

Free sample videos

Freeze panes

Learn how to make a row “sticky”.

Charts

Learn how to pick the right chart and insert it in your spreadsheet.

VLOOKUP

Learn how to use Excel’s most-popular function.

Spreadsheeto has helped me so much. Kasper explains everything so clearly and it is so easy to go back and review some of the exercises to really understand everything. I highly recommend anyone wanting to learn more about Excel to join up, you won’t be disappointed.

Rosemary Walkem, Zero to Hero student

Course content

Zero to Hero takes 14 hours to complete.

There are 7 modules with 199 video lessons.

You get lifetime access to all lessons and free updates.

Finally, you can rewatch all lessons as many times as you want.

I almost passed over this course because I consider myself to be an experienced Excel user, working with Excel spreadsheets daily at work and at home. But, I’ve already learned a lot that I had never known or used before in just the Foundations module. I can’t wait to move on to the next module, and I’m very happy that I purchased the entire training suite. Thank you for this course!!!

Andrew Prouty, Zero to Hero student

Free sample videos

Freeze panes

Learn how to make a row “sticky”.

Charts

Learn how to pick the right chart and insert it in your spreadsheet.

VLOOKUP

Learn how to use Excel’s most-popular function.

Spreadsheeto has helped me so much. Kasper explains everything so clearly and it is so easy to go back and review some of the exercises to really understand everything. I highly recommend anyone wanting to learn more about Excel to join up, you won’t be disappointed.

Rosemary Walkem, Zero to Hero student

Real-world assignments and project files

Assignment file from Zero to Hero

Don’t just watch someone do Excel, try it yourself!

Imitation and repetition are the keys to accelerated learning.

That’s why you get 7 (big) assignments and 100s of project files to follow along and practice with.

This training is presented very well using great videos and excellent practice sheets. The testing is really comprehensive and also fun! I can’t wait to start on the next module!

Ken Hostetler, Zero to Hero student

Fast technical mentor support

When you enroll in Zero to Hero, we see it as the beginning of getting to know you.

Immediately after enrolling, you receive our personalized onboarding that helps you get started.

If you get stuck and have a question, write us and we’ll answer it within 24 hours.

  • Unlimited support for all your technical Excel questions

  • Free access to support knowledgebase with +200 tutorials

  • All questions answered within 24 hours

I have found the material from spreadsheeto absolutely first class. I have learned a tremendous amount from working my way through it. Kasper is very generous with his time and has personally answered many queries/questions I have had not only with the course material but with work-related spreadsheet issues I have had. I would recommend Zero to Hero to anyone looking to upgrade their spreadsheet skills

Tom McGorry, Zero to Hero student

Including 3 bonuses!

Learn Excel (even) faster and easier with…

Just finished module one and already rearing to go for the next. This course is the best hands-on training anyone can dream of. A big thank you!

Samit Ghosal, Zero to Hero student

Including 3 bonuses!

Learn Excel (even) faster and easier with…

Just finished module one and already rearing to go for the next. This course is the best hands-on training anyone can dream of. A big thank you!

Samit Ghosal, Zero to Hero student

Meet your instructor

Hi, I’m Kasper Langmann!

Kasper Langmann co-founder and Excel expert

I’m the co-founder of Spreadsheeto and your instructor in “Zero to Hero”.

3 things you should know about me:

  1. I’m a certified Microsoft Office Specialist
  2. I also work as an Excel-consultant
  3. +100,000 students have seen my courses

“I believe anyone can learn Excel… fast!”

I’ve worked professionally with Excel for +10 years and taught Excel to +100,000 students. That’s why I know exactly what works – and what doesn’t.

Zero to Hero is my blueprint for turning beginners into Excel pros as fast and easily as possible.

I can’t wait to teach you 🙂

I went from being a hesitant and clumsy user of Excel to being able to do so many things that saved so much time and energy. I appreciate Kasper’s clear style and the organization into bite-size chunks.

Thomas McCrorey, Zero to Hero student

The rest of team Spreadsheeto can’t wait to meet you either!

Mikkel Sciegienny
Co-founder

Camilla Randløv
Customer Success

Carina Hansen
Customer Success

Meet your instructor

Hi, I’m Kasper Langmann!

Kasper Langmann co-founder and Excel expert

I’m the co-founder of Spreadsheeto and your instructor in “Zero to Hero”.

3 things you should know about me:

  1. I’m a certified Microsoft Office Specialist
  2. I also work as an Excel-consultant
  3. +100,000 students have seen my courses

“I believe anyone can learn Excel… fast!”

I’ve worked professionally with Excel for +10 years and taught Excel to +100,000 students. That’s why I know exactly what works – and what doesn’t.

Zero to Hero is my blueprint for turning beginners into Excel pros as fast and easily as possible.

I can’t wait to teach you 🙂

I went from being a hesitant and clumsy user of Excel to being able to do so many things that saved so much time and energy. I appreciate Kasper’s clear style and the organization into bite-size chunks.

Thomas McCrorey, Zero to Hero student

Meet our students

Meet Ken Hostetler who enrolled in Zero to Hero to do Excel consulting work.

“I highly recommend Zero to Hero regardless of where you are with Excel”

“I highly recommend this course to anyone who uses Excel regularly”

I am at a point with Excel where my basic knowledge is not helping with my career. I went online looking for affordable ways to gain the advanced skills to use all the features of Excel. I came across Spreadsheeto in my search. I am so glad I signed up for Zero to Hero! I am loving this training.

Mary E. Norris, Zero to Hero student

Spreadsheeto is saving me hours and hours! Kasper is clear in his directions, it is in short segments with practice in between each, and a review at the end where I find out what I need to practice more. So nice I can go back any time to review. This was an investment in myself and it is paying off beautifully and quickly. Also, I decide when I do the course; I love that flexibility. I highly recommend this course to anyone who uses Excel regularly.

Leslie Tavernier, Zero to Hero student

I am so happy I decided to learn more in Excel with Spreadsheeto. The lessons are taught in segments which is so great because you can go back and repeat what you needed to view again. You get assignments to complete and the practice helps you retain what you learned. All lessons are clear and easy to understand. And, you can contact Kasper when you have a problem. He gets back to you and is so helpful. There is no way you can’t improve your Excel skill level if you take the lessons and do the assignments. The course is so well worth it.

Diane D'Avanzo, Zero to Hero student

The curriculum flows very well through all of the training modules. Kasper keeps the information moving which keeps you engaged. I would highly recommend this training!

Steven Gustafson, Zero to Hero student

Professionals from the world’s best organizations have already joined

How Zero to Hero works

Zero to Hero pricing

1. Enroll and start today (or when it fits you)

After enrolling, you get instant access to all content.

Everything is 100% online and immediately available.

Access the training from any device and all locations.

Superb Excel training! Clear, concise, and simple to follow – 5 stars!

Tom Burton, Zero to Hero student

2. Stuck? Get help!

When a question comes up, search our knowledge database to get an instant answer.

If that doesn’t solve your problem open a ticket!

We answer all your questions (always within 24 hours, usually much faster).

I rather had doubted the individual attention this system had promised, but I do receive emails from Kasper and others. I ask a question, and the answer is in less than a day. I highly recommend this course to anyone who uses Excel regularly.

Leslie Tavernier, Zero to Hero student
Support
Zero to Hero module overview

3. Complete a module and get your certificate

After completing each of the 7 modules, your certificate is available for download.

Once you’ve completed one of the seven modules, continue to the next.

Protip: Because you get lifetime access, you can go back and rewatch any module you like.

This is a well-structured course and easy to follow with the videos and practice files. Demystifies Excel and I find I look forward to my learning time. Tried other courses but did not like the way they were presented so lost interest. I recommend anyone who has struggled with Excel to give this a try.

Tracy Rutherford, Zero to Hero student

Risk-free learning
Enroll knowing you’re protected by our 30-day money-back guarantee

Enroll in Zero to Hero today with complete peace of mind, as you’re protected by our 30-day money-back guarantee.

If, within 30 days of enrolling in the course, you are not completely satisfied with your experience, simply send an email to [email protected] and we will promptly refund your entire payment, no questions asked.

You may be wondering:

“Why do you offer such a generous, no-questions-asked refund policy?”

It’s simple:

We’ve seen Zero to Hero transform 1000s of Excel beginners into Excel pros.

We’re confident that our training works, which is why we’re happy to offer this risk-free guarantee.

Fun fact: Refund rates for online courses are 10-15%. Ours? 3.6%.

Kasper Langmann, Excel expert and instructor (left). Mikkel Sciegienny, communications. Founders of Spreadsheeto.

Enroll now to get instant access to Zero to Hero

All-in
$19
12 monthly payments
7 modules
Assignments
1-year support
Certificates
30-day money-back guarantee
Premium
$49
12 monthly payments
7 modules
Assignments
3-years support
Certificates
30-day money-back guarantee
2x30-minute coaching call (value $199)

I like your training, it’s very easy to follow and I have learned a lot. I am so grateful that I have the chance to learn Excel from Spreadsheeto. The training is excellent. I will let my friends know about Spreadsheeto when they need to learn Excel.

Linda Sun, Zero to Hero student

Frequently asked questions

If we don’t answer your question below, contact us!

Our training is for Excel on Windows. If you have Excel 2010 (or later), you’re all set!

On a Mac? No problem! Get the latest version of Excel for Mac (available with a Microsoft 365 subscription) and you’ll be fine.

You have lifetime access to Zero to Hero.

You get future updates for free.

Zero to Hero is 100% self-paced. That means you can go through the course whenever you want.

You can review any part of the course whenever you want, as many times as you want. Many students go back to the lessons several times as a refresher.

So even if you don’t have time today – because you’re super busy – you can still buy the course, and start whenever you prefer.

There are 7 modules in Zero to Hero.

1 module takes 1 hour to watch and 1 hour to practice.

So ~14 hours for the entire training.

With Zero to Hero, you get access to 7 modules.

The modules are: ‘The Foundation’, ‘Formatting’, ‘Functions’, ‘Lookup’, ‘Pivot Tables’, ‘Macros’, and ‘VBA’.

Read all about the modules here.

First of all, that’d surprise us!

General refund rates for online courses are 10-15% – ours is just 3%.

In the unlikely event that you’re not satisfied, send an email to [email protected] by day 30 and we’ll refund your entire payment immediately.

Right here (they are super simple)!

If there’s something you have a question about, feel free to reach out.

Yes, of course!

You can go through the course whenever you want.

You have lifetime access to the course materials.

There are no live sessions where you need to show up.

You can progress at your own pace through the lessons.

You can review any part of the course long after you graduate.

You can start today! (or whenever you have time)

Simply select your plan, and you’ll receive your course credentials a few minutes after your purchase.

  1. Pick your plan to see a secure checkout.
  2. After your payment, you’ll receive an email within minutes with your login instructions.
  3. You can then log in and start the course.

Any other questions?

We’re here to help!

Kasper Langmann & Mikkel Sciegienny

Spreadsheeto's founders

CUSTOMER SERVICE

 About

 Contact