Tackle 2024 with new knowledge – take advantage of Learnesys’ fall campaign on the All Courses package. Read more here.
Back to all courses
This course is also available in: Norsk Norsk Svenska Svenska
The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn to efficiently manage databases, clear text in cells and retrieve values from other tables. The course also goes through how to combine functions, which is required to be able to perform more advanced steps in Excel. With this knowledge, you will be able to simplify time-consuming parts of your work. With over 100 lessons spread over 12 chapters, you will learn a lot in the subject of Excel functions.

  • Complete the course at your own pace
  • Repeat as much as you want
  • Practical exercises and quizzes
  • Personal and digitally shareable diploma
  • Save lessons as favorites
  • The course takes about 4 hours to complete
  • Access to the course material for 12 months
  • 90+ lessons of functions and formulas
  • Get yourself a library of Excel functions
Take this course
Learnesy
Learnesy
4.9
Based on 138 reviews
powered by Google
js_loader
What you will learn Watch a lesson Course contents More about the course FAQ Meet the teachers

Some of the things you will learn in this course:

A library of 100+ functions

After completing the entire course, it can be used as a library of functions. Save your favorite functions and return to them for a refresh whenever you need it.

The most useful functions

Functions that show you how to summarize, count, how to manage absolute and relative references, financial functions, statistical functions, and more.

VLOOKUP and reference functions

VLOOKUP, perhaps Excel’s most famous function, is not always easily understood. Learn this useful function along with 10 other practical functions used to search for and collect values.

Handle dates and text

Something that even experienced Excel users know is complicated are dates and texts in tables or databases. Use functions such as WEEKDAY, WORKINGDAYS, MID, and many other smart tips and tricks to get your data in order and manage it correctly.

A lesson from the course

In this lesson from The Excel Functions Guide, you’ll learn the VLOOKUP function from the chapter “Lookup and reference”. The function looks for a given value in the leftmost column, and returns a value in another column on the same row. VLOOKUP is used to search and retrieve values, and is mainly used in spreadsheets with a lot of data. VLOOKUP can be compared to a phone book. You start with the information you know to find out what you don’t know.

The Excel Functions Guide is one of Learnesy’s intermediate courses in Excel. In this course, you’ll learn even more so-called reference functions. This course actually includes an entire chapter of such features. The remaining twelve chapters cover many other Excel functions with completely different purposes, such as matrix functions, statistics functions and text functions to name a few. In fact, the course contains about 90 lessons with functions, formulas and other tips and tricks for formula management.

Course Content

Expand All
1 Functions with Count And Sum 11 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/11 Steps
COUNT – Counts the number of cells containing numbers
Count the nonblank cells with COUNTA
Count the number of blank cells with COUNTBLANK
Count cells based on a criteria with COUNTIF
Count cells based on multiple criteria with COUNTIFS
Count logical values
Count text occurrences
Use SUM to sum up the values in a range of cells
Sum cells based on one criteria with SUMIF
Sum cells based on multiple criteria with SUMIFS
SUMPRODUCT sums the product of a range of cells
2 Logical 3 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/3 Steps
The IF-function
Combine the IF-function with AND / OR
Combine multiple IF-functions
3 Cell references 4 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/4 Steps
Copy exact formulas
How to mix relative and absolute references
Sum values from multiple sheets with 3D references
Insert hyperlinks
4 Date and time 9 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/9 Steps
Learn the tricks for Date and Time
Get the number of days between two dates with DATEDIF
Day of the year
Days until anniversity
Last day of the month
Quarter
Weekdays
Number of NETWORKDAYS between two dates
NETWORKDAY returns a date after a number of weekdays
5 Text 11 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/11 Steps
How to compare text in two different cells
JOIN and LEN
Remove unwanted characters
Capital or small letters with UPPER, LOWER and PROPER
Extract characters with LEFT, RIGHT and MID
FIND and SEARCH characters in cells
SUBSTITUTE and REPLACE characters in cells
Count the number of words in cells
Number of instances a text or a number occurs in a cell
Separate strings of text from a cell
Use the Text to columns-guide
6 Lookup and reference 9 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/9 Steps
Search and return a value with VLOOKUP
Search and return a value with HLOOKUP
How to use VLOOKUP if you don’t have an exact reference
Use MATCH, INDEX, CHOOSE to find values in a list
Use INDEX/MATCH to return a value left of a reference
Get the cell reference for the cell with max value
Get a value using coordinates with OFFSET
Use INDEX/MATCH to lookup values in a two-dimensional range
Get values with an INDIRECT reference
7 Financial 10 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/10 Steps
PMT (payment)
RATE
NPER (number of periods)
PV (present value)
FV (future value)
PPMT (principal payment)
IPMT (interest payment)
IRR (internal rate of return)
NPV (net present value)
Compound interest
8 Statistical 11 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/11 Steps
Get the average of values with AVERAGE/AVERAGEIF
Use FORECAST to predict the next number in a range
Find the middle/most common value with MEDIAN, MODE
Identify the n:th largest/smallest number with LARGE/SMALL
Use STDEV to calculate standard deviation
RAND returns a random number between 0-1
RANDBETWEEN returns a random number between two numbers
Rank the numbers in a range with RANK, RANK.AVG
PERCENTILE returns a number corresponding to a percentile
QUARTILE returns the number corresponding to a quartile
Neutralise negative numbers in a list
9 Round 4 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/4 Steps
ROUND numbers to integers or decimals
Use ROUNDUP/ROUNDDOWN to round numbers
Round to the closest EVEN or ODD number
Delete decimals with INT/TRUNC
10 Formula errors 6 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/6 Steps
How to find and correct circular references
How to deal with #NAME?, #VALUE! and ####
How to deal with #DIV/0! and #REF!
Trace dependent/Precedents cell references
Show and Evaluate formula, Error checking
Correct errors with ISERROR
11 Array formulas 10 Lessons
Expand
Chapter Content
0% Complete 0/10 Steps
Introduction to array formulas
Count the number of errors in a range
Count unique values in a range
Count cells with or and and criteria
Find the most frequent word in a range
Sum every nth row in a range
Sum the largest numbers in a range
Sum a range with error values
Sum cells with or and and criteria
Two-column lookup in an array formula
12 Depreciation 6 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/6 Steps
Introduction to depreciation
SLN (Straight Line)
SYD (Sum-of-Years’ Digits)
DB (Fixed Declining Balance Method)
DDB (Double Declining Balance Method)
VDB (Variable Declining Balance)
13 Dynamic Array Functions 13 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/13 Steps
Introduction to Dynamic Array Functions
SORT
SORTBY
UNIQUE
FILTER
RANDARRAY
SEQUENCE
XMATCH
Show the nth largest or smallest values
Filter every nth row
Use FILTER to remove columns
Randomly sort a list
Get common values

More about the course

The Excel Functions Guide is a continuation course for those who want to expand their competence within the program’s many functions. Prior knowledge of Excel is required. If you’re lacking said knowledge, we can recommend our course Excel Essentials. In addition to the more basic functions, you will also learn dynamic array functions and how to handle error messages. When you handle multiple functions, you can save time in your work because you can often replace multiple elements with a single formula. Last but not least – to become an advanced Excel user, you must be able to master functions.

  • Approximately 90 lessons divided into 12 chapters.
  • Total video time: 1 hour 40 minutes.
  • Estimated time to take the course including quizzes: 3 hours.
  • Average length per lesson: 1 minute.
  • Personal shareable certificate after completing the course.

FAQ

Who should enroll this course?

This course is for those who have previously taken the course Excel Essentials or who have basic Excel skills, as this is one of Learnesy’s intermediate courses in Excel.

Is there exercises in this course?

This course includes many and short exercises. If you want to follow along with the lessons, you can do so by downloading the files that are attached to each lesson.

All chapters end with a quiz. With some questions there’s a downloadable resource which is needed to solve said exercise. 

I HAVE PREVIOUSLY LEARNED EXCEL FUNCTIONS IN the Excel Essentials COURSE – IS THIS COURSE FOR ME?

Yes, if you have previously taken the Excel Essentials course, this course will give you a much deeper understanding and practical knowledge of Excel functions.

I HAVE USED EXCEL BEFORE. IS THIS COURSE FOR ME?

Yes. This comprehensive course contains lots of useful features and tips. However, this course requires some prior knowledge in the area of Excel functions. If you feel that you need to repeat the basics instead, you can take our course Excel Essentials.

HOW LONG DOES IT TAKE TO COMPLETE THE COURSE?

This course takes about 3 hours to complete. To pass the course and receive your diploma, you must complete all the lessons and quizzes that make up each chapter. If, on the other hand, you want to download the lesson materials and follow along practically in each lesson yourself, this course will take a little longer.

WHERE CAN I GO IF I NEED HELP WITH THE CONTENT OF THE COURSE?

If you need help, you can visit our forum or contact us at [email protected].

We are an enterprise, a team or a school needing a intermediate Excel course. How do we proceed?

Do you want to learn Excel functions, acquire a library of these and are looking for a business solution for your group? Then get in touch at [email protected].

If you are an educational institution that wants to offer its students supplementary Excel training, you can contact [email protected].

Meet your teachers

Henrik

Course creator, Learnesy

Henrik is one of Learnesy’s course creators. Since 2015, he has developed and produced many of Learnesy’s courses. He has studied software development but also sound, which is why you can so often hear his voice in many of Learnesy’s courses.

Henrik has extensive experience in e-learning and possesses very good knowledge in the majority of data-related areas and the tools used.

Emil

Course creator, Learnesy

Emil is an important part of our team of course creators. He has been creating courses on Learnesy since 2017 and has previous multi-year education in computer science. Many of the popular courses that can be found in Learnesy’s course range have been developed by Emil and he has a broad competence in Excel, data analysis and programming.

Choose what suits you best:

The Excel Functions Guide

249 kr / month Billed yearly. VAT will be applied.
  • Choose the course that suits your needs
  • Access to all material 24/7 for 12 months
  • Complete the course at your convenience
  • Repeat freely throughout the access period
  • The course is maintained and updated
  • Personal and digitally shareable diploma
  • Save your favorite lessons
  • Contact us and we will help you choose the right one!
Take this course

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

Invoice

All courses

Campaign until 31/12-2023
599 kr 499 kr / month
Billed yearly. VAT will be applied.
  • Campaign: gain access until 2024-12-31
  • Access to the entire course catalog
  • Access 24/7 for 12 months
  • Complete the courses at your convenience
  • Repeat freely throughout the access period
  • Courses that are maintained and updated
  • Personal and digitally shareable diploma by course
  • Save your favorite lessons
  • Take full courses or see only the lessons you need
  • Contact us and we will help you get started today!
Take all courses

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

Invoice

For teams

Offer
  • Personal Account Manager
  • Personal account for all users
  • Choose the courses that suits your needs
  • Multi-user discounts
  • Optional Kickoff at startup
  • Statistics via Data Insight
  • Technical support
  • Unique login domain
Contact for demo / quote

Prices excluding VAT

Related courses

Excel Essentials

The ultimate guide to mastering Excel

From beginner to expert with Excel Essentials – the ultimate guide to mastering Excel. Explore the functions, formulas, and techniques necessary to manage data, create charts, and automate worksheets in...

Course details
The Excel PivotTables Guide

Become an expert in Excel's most fundamental data analysis tool

With this course, you’ll quickly and efficiently learn how to set up and analyse databases. Once you’re able to analyse data at a deeper level, you will then be able...

Course details
Power Pivot & DAX

Analyse data on a whole new level with Power Pivot and Data Analysis Expressions (DAX)

With Power Pivot and DAX, you can model data, visualize big data, and easily and efficiently create analyses to gain important insights. Data Analysis Expressions (DAX) is a collection of...

Course details

A selection of customers: