Course description
The Excel Functions Guide is an online course for users who already have basic Excel skills and want to develop a broader and more practical understanding of Excel functions. The course is particularly relevant for professionals who use Excel for calculations, data analysis, reporting and other recurring data-related tasks.
You will learn how to use functions for counting and summing, logical calculations, cell references, dates and time, text processing, lookup and reference, finance, statistics, rounding and error handling. The course also covers array formulas, depreciation and dynamic array functions.
A central part of the course is learning how functions can be combined to solve more advanced tasks and reduce manual work. With more than 100 function-focused lessons and examples, the course can also serve as a practical reference library that you can return to whenever you need to refresh your knowledge.
Through short video lessons, practical exercises and quizzes, you develop skills that can be applied directly in your daily work in Excel.
Information about the course
- Online course with access to the learning platform for 12 months
- Intermediate Excel course for users with basic Excel knowledge
- More than 100 lessons and examples covering Excel functions
- Short video lessons combined with practical exercises and quizzes
- Self-paced studies
- Personal and digitally shareable certificate upon completion
- 5 Continuing Professional Education hours
Expenditure of time
The course is built around short, focused lessons that make it easy to study individual functions and return to specific topics when needed. You have access to the course for 12 months and can repeat the material throughout the access period.
The purpose of the course is to give you a practical understanding of how Excel functions work and how they can be applied to calculations, data management, analysis and reporting. After completing the course, you will be better equipped to select, combine and apply functions independently and build more efficient and reliable spreadsheets.
The online course is a collaboration between FAR and Learnesy.
Chapters
- Functions with Count And Sum
- Logical
- Cell references
- Date and time
- Text
- Lookup and reference
- Financial
- Statistical
- Round
- Formula errors
- Array formulas
- Depreciation
- Dynamic Array Functions
Information
The course requires basic knowledge of Excel and is suitable for users who already work in the program and want to strengthen their skills in formulas and functions. If you are new to Excel, Excel Essentials is a more suitable starting point.
The course covers a broad range of functions, including IF, VLOOKUP, XLOOKUP, INDEX, MATCH and FILTER, as well as functions for dates, text, finance, statistics, rounding and error handling.
You will also learn how to combine functions. This is an important skill when building more flexible formulas and when several calculation or data-processing steps need to be handled in a single solution.
The course is designed both as structured training and as a reference resource. You can save useful lessons and return to individual functions whenever you need to refresh your knowledge during the 12-month access period.
The training is delivered fully online and can be completed at your own pace. The course is continuously maintained and updated by Learnesy's course developers.
This course is also available in Swedish: Excelfunktioner fördjupning
Course scope
5 Continuing Professional Education hours
Example lesson