Course: Functions 2017-02-28T08:45:43+00:00

Online Excel Course for Intermediates: Functions

Get instant access

Get access to Functions now

Functions: Course on advanced Excel functions

‘Functions’ is the perfect course if you’re looking to upgrade your skills in Excel.

In just 59 minutes, you’ll have a great understanding of Excel’s most powerful functions.

This is the quickest and best way to perform advanced calculations in your spreadsheets.

  • 30 action-packed lessons
  • Project files to make your new knowledge stick
  • Free cheat sheet for easy repetition
  • (Re)view each lesson as many times as you’d like
  • Perfect if you’re a bit experienced in Excel
Get instant access

Course Curriculum

Here’s the complete list of modules and lessons ‘Functions’ goes through.

  • Introduction to the course
  • What are you going to learn from this course?
  • What is a function?
  • How to use any function
  • Introduction to the IF function
  • Use the IF function
  • Nested IF functions
  • The IFS function
  • IF, OR + AND
  • SUMIF
  • SUMIFS
  • COUNTIF
  • COUNTIFS
  • MAXIFS and MINIFS
  • LEFT, RIGHT and MID
  • LEN
  • SEARCH
  • Combination of text functions
  • Joining cells
  • Working with Dates
  • Dissecting dates (DAY, MONTH, YEAR functions)
  • Find today’s date with the TODAY function
  • Typical errors when working with functions
  • IFERROR
  • Evaluating formulas
  • Named ranges
  • Certificate
  • What now?

Who created this course?

Kasper Langmann (co-founder) created ‘Functions’.

Kasper is also a certified Microsoft Office Specialist.

What’s unique about Spreadsheeto is, that the course creator is also the co-founder.

Kasper will not only be him you’ll listen to throughout the lessons – you’ll also be in direct contact with Kasper all throughout your Excel-journey.

“Hi, there! My name is Kasper and I’m the creator of ‘Functions’. I’ve worked professionally with Microsoft Excel for the past 6 years. I’ve helped thousands of people just like you understand and use complex things in Excel, such as advanced functions. I’m also a certified Microsoft Office Specialist. I’m so ready to help you get awesome in Excel in no time!”
Kasper Langmann, Co-founder and course creator

Frequently asked questions

Got a question we don’t answer below? Then feel free to contact us.

What version of Excel do I need?

The course is made in Microsoft Excel 2016 for Windows. We highly recommend you have the latest version of Excel. This course goes through some functions that are exclusive for Excel 2016.

Can I get a certificate of completion?

Absolutely! Once you’ve completed the course, you’ll get a certificate of completion. This applies not only to this course, ‘Functions’, but all our courses.

Do I need any experience to take this course?

You need to have a basic understanding of what Excel is. You should be comfortable opening spreadsheets, typing data in cells and alike. However, you don’t have to be an expert by any means. The course pace is slow and steady. Everything is explained very beginner-friendly.

How long does it take to complete the course?

You can watch all the lessons in less than 1 hour. We’ve removed all the unnecessary and distilled Excel down to its most important elements. We highly suggest you also do the included exercises. We’ve included a cheat sheet that makes revising the course content smooth and easy. How quick you pick up the material is very different from person to person. Therefore, we recommend setting aside 2-3 hours to go through all lessons and exercises.

Get access to Functions

Create a membership and get instant access to this course (and many others)

Functions: Course on advanced Excel functions
Get instant access

Send this to friend