Who’s this course for?

This online course in Excel Functions 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. With increased knowledge in Excel you can save time in your work, there may be elements in your work that can easily be bypassed with a function.

The online course in Excel functions is aimed at those who have basic knowledge of Excel and have an understanding of how Excel functions are used but want to learn many more useful functions.

What will I learn?

Some of the functions that you will learn to use are  IF, VLOOKUP,  COUNT and INDEX.

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 Excel Function Guide is to increase your knowledge which will save you time. Navigate further down to see which chapters and lessons are included in the course.

Our pedagogy is based on Nano-learning means that the lessons are short –  average 2 minutes. After completing a course, you will be awarded a personal course certificate, and you can at any time log in and repeat any parts of the course you are unsure of or have forgotten.

If you have any questions, visit our FAQ page or feel free to contact us

This is included in the online course:

  • Full access to the online course in Excel Functions for 12 months
  • Requirements: Basic knowledge  in Excel. Excel installed in your PC or MAC. 
  • 94 lessons divided into 12 chapters
  • Video time: 1h 40 min
  • Time to complete to course including exercises and quizzes: 2-3h
  • Average time per lesson: 1 min
  • Personal diploma upon completion

Do you need to install Excel on your computer? You can buy Excel here at Microsoft

Course Content
Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.
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.