Course | Excel course – The Excel function guide – English

Or log in to access your purchased courses

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.


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.


8 Statistical

An overview of some very useful statistical functions 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.