# Course | Excel course – The Excel function guide – English

This course will teach you the logic behind functions and be your online library available to your help at anytime.The course consist of two sections: The first two modules (E1-E2) consists of lessons of 1-3 minutes teaching you the basics logics behind formulas and functions. Each lesson has a quiz where you can practice you skills. The rest of the modules (1-12) is short 1 minute lessons showing you about 95 different Excel functions. This part of the course has no quizes, but will be your online Excel library to help you save time and grow your Excel skills.

## E1 Understand the basics and logic behind formulas and functions

In this module we teach you the basics behind formulas and functions. This is important when you move on to the more advanced funcitons in the comming chapters. Each lesson in this module has a test where you can practice the content in the lesson.

## 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.