Course description
The Excel Functions Guide is an online course designed to provide a structured and practical understanding of Excel functions used in professional financial work. The course is aimed at accountants, controllers and other finance professionals who want to work more efficiently and accurately with calculations, data analysis and reporting in Excel. You will learn how commonly used functions are structured and how to apply them correctly in real work scenarios. The course covers logical, lookup, text, date and mathematical functions with a clear focus on practical usage rather than theory. Through concise video lessons and applied examples, you gain insight into how functions can be combined to solve common business problems. After completing the course, you will be able to use Excel functions with greater confidence and precision, resulting in more reliable analyses and time efficient workflows.
Information about the course
- Online course with access to the learning platform for 12 months
- Advanced Excel course focusing on advanced functions
- Video based learning combined with practical exercises
- Self-paced studies
- Certificate upon completion
- 5 Continuing professional education hours
Expenditure of time
The online course includes 105 short, easy-to-follow lessons with approximately two hours of video content in total. You’ll have 12 months of access, giving you the flexibility to revisit and repeat the course whenever you need.
The purpose of the course is to give you a clear and practical understanding of how Excel functions work and how they are used in professional contexts. The focus is on functions that are most relevant for financial analysis and reporting.
After completing the course, you will be able to independently apply Excel functions to build more accurate calculations, structured models and reliable decision support. You will work more efficiently and with increased confidence in Excel.
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 professionals who already work in the program but want to strengthen their functional skills. The training is delivered fully online and can be completed at your own pace during the access period. The course content is recorded in modern versions of Excel and is applicable in current Excel environments. The course is continuously maintained and updated by Learnesy’s own course developers.
This course is also available in Swedish: Excelfunktioner fördjupning