The Excel Functions Guide - online

In this online course, you will learn to master 100 of Excel's most commonly used functions. Additionally, the course serves as an online library of functions, allowing you to come back and review them at any time.

Auktoriserad lönekonsult Auktoriserad redovisningskonsult Auktoriserad/godkänd revisor Controller Ekonomiassistent Ekonomichef/CFO Lönekonsult Redovisningsansvarig/chef Redovisningsekonom Redovisningskonsult Revisorsassistent Skatterådgivare/konsult

Course description

To master Excel, it is essential to learn how to work with functions. The goal of this course is to enable you, as a user, to seamlessly utilize functions in Excel to become more efficient in your work. In the course, you will learn over 100 of Excel's most commonly used functions, ensuring you gain a comprehensive understanding of how to work with them. The course also includes multiple exercises where you can apply what you have learned in practice.

Short about the course

  • Full access to the course for 12 months
  • 110 lessons
  • Estimated completion time: 5 hours

Expenditure of time

The course takes approximately 5 hours to complete. You will have access to the course for 12 months, allowing you to revisit and review the material.

The purpose of the online course is to quickly make you a more experienced Excel user. The course will make the program an increasingly valuable tool in your work. You will learn many functions that will help you save time and improve the quality of your work.

After completing the course, Excel will become a more natural tool in your work. Among other things, you will have learned how to manage functions and simplify your work using them. Please refer to the course chapter names for more information.

The online course is a collaboration between FAR and Learnesy.

Chapters

  1. Functions with Count And Sum
  2. Logical
  3. Cell references
  4. Date and time
  5. Text
  6. Lookup and reference
  7. Financial
  8. Statistical
  9. Round
  10. Formula errors
  11. Array formulas
  12. Depreciation
  13. Dynamic array functions

Information

Basic skills in Excel is required.

The lessons are based on the latest version of Excel and will work well with all versions without Excel for Mac 2013 and older versions.

This course is also available in Swedish: Excelfunktioner fördjupning

Video example