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

# Online Excel Course for Intermediates: 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.

• 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

## Course Curriculum

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

#### Introduction

• Introduction to the course
• What are you going to learn from this course?

#### Foundations of functions

• What is a function?
• How to use any function

#### Conditional functions

• 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

#### Functions for working with text

• LEFT, RIGHT and MID
• LEN
• SEARCH
• Combination of text functions
• Joining cells

#### Date functions

• Working with Dates
• Dissecting dates (DAY, MONTH, YEAR functions)
• Find today’s date with the TODAY function

#### Toolbox features

• 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!”

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.