Who's this course for?
"Excel Course - The Excel Function Guide - English" will teach you the logic behind functions at the same time as it's your very own online-library filled to the brim with functions. All available to watch and repeat whenever you need.

What will i learn?
The course consists of 12 chapters with short 1-minute lessons, all with the same structure. Teaching you 95 different functions. The final goal of the The Excel Function Guide is to increase your knowledge which will save you time. Go to the course to see which chapters and lessons are included in the course.

This is included:
- Full access for 12 months
- 94 lessons
- Video time: 1h 40 min
- Time to complete to course: 2-3h
- Avarage lesson time: 1 min
- Personal diploma upon completion

1.495 kr (ex. moms)

## How the course works

Before you begin Learnesy's course "The Excel Functions Guide" - Click the lesson below to see a video showing how the course is structured and how to navigate the page.

## 1 Functions with Count And Sum

The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.

## 2 Logical

Learn how to use Excel's logical functions such as the IF, AND and OR function.

## 3 Cell references

Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

## 4 Date and time

Date and time can be tricky to work with in Excel, however in this chapter you will learn the smart ways to work with date and time in order to get save time and get it right.

## 5 Text

Excel has many functions to offer when it comes to manipulating text strings. In this chapter we will show you the most powerful.

## 6 Lookup and reference

Learn all about Excel's lookup & reference functions such as the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE function.

## 7 Financial

This chapter illustrates Excel's most popular financial functions.

## 8 Statistical

An overview of some very useful statistical functions in Excel.

## 9 Round

This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

## 10 Formula errors

This chapter teaches you how to deal with some common formula errors in Excel.

## 11 Array formulas

This chapter helps you understand array formulas in Excel. Single cell array formulas perform multiple calculations in one cell.

## 12 Depreciation

Excel offers five different depreciation functions. In each of the following video we will consider an asset with an initial cost of \$15,000, a salvage value (residual value) of \$1500 and a useful life of 10 periods (years). In the lessons you can find the results of all five functions, each function explained separately.