Free Online Excel Training: 7-Part Course for Excel 2016

Looking to get better at Excel? For free?
Look no further!

Here’s your blueprint for learning Excel in just 7 days.
Our free, online training will give you a strong foundation and understanding of Microsoft Excel in record time.
Go ahead, watch the first lesson of the course right below…

Watch the first lesson right now

Click the button right below and sign up to get the rest of the course.

Click here to get our FREE training

Kasper Langmann:
Instructor and Co-founder of Spreadsheeto

“In the first lesson of our free training, we’ll take a closer look at 6 shortcuts that are easy to remember and instantly boosts your productivity.”

If you liked the first lesson, then you’re going to love the rest of this training.

Sign up right below the video and receive lesson 2 immediately. 

We promise you won’t regret it :)

“This training is awesome for getting a basic understanding of Excel. As a beginner, this is a great place to start!
Mille
I highly recommend this course to anyone starting out in Excel – even people who’s worked in Excel for some time. I surely picked up and few tips here and there!”
Sophus

Here’s what you’ll get

Why this course? Well, my friend was in trouble…

So how did the course come about?

Well, one day my friend sent me this message…

“As you know, I’m starting a new job in a week. My boss told me I should know my way around a spreadsheet… How do I get up to speed in Excel in about a week?
Nicolai

Great question (and quite the challenge)!

To be frank, learning Excel in about a week is quite hard. Because, where do you even begin?

Excel has 100s of functions and can be used in so many ways. Knowing exactly what to focus on, is almost… Well, impossible!

But of course, I didn’t want to let my friend down.

I came up with 7 different topics, that my friend absolutely needed to master (so that his new boss and colleagues wouldn’t think he was a dork)..

These 7 topics, are the exact topics that I’m going to teach you throughout this free course.

How did it go? Well, here’s what my friend said…

“Kasper brought me up to speed in Excel very quickly. It even exceeded my expectations. Starting the new job was a breeze and Excel wasn’t a headache like I was used to. Instead, it has become a valuable tool in my everyday life.
Nicolai

So in just 7 days, my friend got up to speed in a program, he wasn’t very familiar with.

I’m absolutely positive you can accomplish the same too – and it might be even easier than you’d think.

I recommend you watch the first lesson of our free Excel course right now and see if it’s something for you.

If you like it, go ahead and sign up for the rest of the course and have it delivered directly to your inbox.

Click the button right below and sign up to get the rest of the course.

Click here to get our FREE training

Course Content

Interested in what you’re going to learn?
See the exact content of the course right below…

Lesson 1: Boost Productivity with Shortcuts

Excel shortcuts

In the first lesson, we’re going to show you 4 different shortcuts – we call them ‘smartcuts’ – that’ll instantly boost your performance and productivity in Excel.

Lesson 1 is instantly available for you to see.

  • Learn to jump around in Excel
  • Copy paste data
  • Get a total

Lesson 2: Make Excel ‘Pretty’ with Formatting

Excel is by default.. well ugly! But it doesn’t have to be.

In the second lesson, we’ll teach you the basics of formatting your spreadsheet.

  • Color your data (the right way)
  • Apply borders to your sheet
  • Wrap text and merge cells
Formatting

Lesson 3: Explore the Core Functions

Basic Excel functions

The backbone of Excel is functions. Without functions, Excel wouldn’t be one – if not the – most powerful software in the world.

Learning functions isn’t optional. It’s a must. In the third lesson, we’ll teach you the foundation of functions.

  • How functions work
  • Adding numbers with SUM
  • Counting cells with COUNT

Lesson 4: Dive Deeper into Advanced Functions

In the fourth lesson, we dive even deeper into the more advanced and powerful functions of Excel.

By having a grasp of these advanced functions, you’ll make Excel do all the hard work for you.

Sounds good, right? Here’s what you’ll learn:

  • Do something based on certain criteria (IF)
  • Adding numbers that meet certain criteria (SUMIF)
  • Counting cells conditionally (COUNTIF)
Advanced Excel functions

Lesson 5: Working with ‘Big Data’

Working with Big Data

Sooner or later, you’ll find yourself working with tons of data in Excel. If you don’t know the right tools, you’ll soon be lost.

Fear not, in lesson 5 we’ll teach you the exact tools you need to know in order to handle ‘Big Data’.

  • Freeze panes
  • Comments
  • Filtering

Lesson 6: Make Data Actionable with Conditional Formatting

Getting an overview of your data is quite the hassle. Because how do you make sense of rows and rows of data?

‘Conditional Formatting’ makes your data relatable and most important of all – actionable.

  • Find duplicates
  • Color scales
  • Color a number greater than
Conditional formatting

Lesson 7: Visualizing Data using Charts

Visualizing data using charts

In larger datasets, the overview is quickly lost and so is interpretation.

Being able to (properly) visualize data is, therefore, a necessary skill to master.

Exactly this is what we’re going to teach you in the final, and most important, lesson.

  • How to visualize your data using charts
  • Modify the chart to your specific needs

Frequently Asked Questions

Got a question?

It’s probably answered in one of the boxes right below. If not, feel free to contact us right here.

Is this for Windows or Mac?

Flip to get answer

Windows

Our course was recorded on a computer running Windows, using Microsoft Excel 2016.

Do I need to have Excel 2016 installed?

Flip to get answer

Excel 2007 or later is fine

Working in the latest version of Excel is what we recommend. With Office 365 it’s become very inexpensive to always have the latest software. If you for some reason haven’t got Excel 2016, fear not. I’d say that you’ll be perfectly capable of following along if you have Excel 2007 or later.

Is this training free? For real?

Flip to get answer

Yep! This course is completely free.

This training is 100% free. The first lesson is already available for you to watch on this page. If you like the course, go ahead and sign up and have the rest of the training sent directly to your inbox. Unsubscribe anytime (we’re pretty sure you’d like to stick around, though!).

What's included in this training?

Flip to get answer

Everything necessary

Great question. Short answer: Lots of awesome stuff! The core of this course consists of 7 (HD) video lessons, specifically designed to teach you Excel as easily and swiftly as possible. Further, the training also comes with free exercise files, additional resources along with a few nice bonuses (which you’ll have to sign up to get).

When do I receive the lessons?

Flip to get answer

Right away

You’ll get lesson 2 instantly upon signing up (lesson 1 is already available for you to see on this page). From there, we’ll send you 1 lesson per day for a total of 6 days. Not only will you receive our free training, you’ll also get the latest updates from us, new articles, tips & tricks and all sorts of other good stuff.

Do I need to watch a lesson each day?

Flip to get answer

It's completely up to you

Ideally, this is what we recommend. However, we also realize that something can come up that changes your plans. Since this is 100% online, you’re free to watch any lesson exactly when you’d like – and as many times, you’d like. Our goal is to make it as easy and flexible for you to learn Excel :)

Can I see the exact course content?

Flip to get answer

Of course you can

We’ve included the exact content of this course right here on this page.

Is this for beginners? How good will I get?

Flip to get answer

Perfect for Beginners

This training is designed for the beginner. Having a basic grasp of what Excel is, is a good idea. We start off with the most fundamental stuff and progress each lesson into more powerful functions and tools. Once you’ve completed the course, and done our recommended exercises, you’ve become a great “generalist” in Excel.

Who’s the instructor?

Flip to get answer

Kasper is your instructor

Kasper is your instructor. Kasper LOVES Excel and can’t wait for you to check out his course. Learn more about Kasper right here.

What's the duration of the lessons?

Flip to get answer

About 10-20 minutes

Each lesson consists of a video, along with an exercise file (and sometimes a few additional resources and bonuses). A video is usually around 10 minutes. We highly urge you to do the recommended exercises, so set aside 30 minutes per lesson to get the best understanding.

Is this training in English?

Flip to get answer

All the training is in English

The entire course is in English. You’ll probably notice, that we aren’t native speakers and might say (or spell) a word weird here and there. That’s because we’re from Denmark (Scandinavia). We sound a bit like “Le Chiffre” (Mads Mikkelsen) from James Bond – but we promise we’re not bad guys like him!

Can I watch the lessons on any device?

Flip to get answer

Any device will work

Yes, you can! Whether you’re using a smartphone, tablet, laptop or a good ol’ fashion desktop, you can always access our lessons – any time, anywhere, any device.

Here’s what a few other people think about this training

The structure of the course enables anyone to learn Excel despite prior experience. The course explains the basics so that you learn Excel in the right order. I strongly recommend all beginners in Excel to try it out!”
Mads
“I think the course is great. It’s easy to understand and down-to-earth while still learning a lot. I like the lessons are brief and to the point. When done with the course, you’re well suited to advance even further in Excel.”
Carina
“This course is great, even for the complete beginner who’s looking to get some experience. The lessons are very intuitive and the included exercise files makes it easy to get started right away. I’m currently in between jobs, and certainly think this course has given me skills I can leverage later on.”
Camilla
“I’ve learned so much from each lesson. They are all straight to the point, relevant and full of so many tips. I’m very pleased with the training. Thanks for everything!”
Rikke

About your instructor

“Hi, there! I can’t wait to show you how awesome Excel is. I’ll be your instructor throughout this course. I’ve been working professionally with Excel since 2009 and taught thousands of people just like you to get better at Excel.”
Kasper Langmann, Instructor and Co-founder of Spreadsheeto

Your instructor throughout this free training is Kasper. Kasper is quite the “Excel geek”, with a burning passion for teaching others how to get good at Excel. Kasper is all about teaching you the most efficient way of getting up and running in Excel as quickly as possible. Therefore, all unnecessary formulas, functions and tools have been kept out and it’s all boiled down to 7 high-effective parts.

Read more about Kasper and Spreadsheeto right here.

Sign up and get lesson 2 right away..

Click the button right below and sign up to get the rest of the course.

Click here to get our FREE training