Excel Fundamentals – Formulas for Finance
Level 2
2h 14min
100% online and self-paced
Field of Study: Finance
- Explore the Excel 365 interface and focus on the features that are the most common within the finance industry.
- Compare various financial analysis functions to understand their advantages and disadvantages.
- Practice using tools and shortcuts improve your speed and accuracy with the keyboard.
Overview
Excel Fundamentals – Formulas for Finance Overview
Excel is a sophisticated piece of software, and it can be overwhelming to look through and work with the many available features. CFI’s “Excel Fundamentals – Formulas for Finance” course will help you filter down through those features to focus on the ones that are the most common and useful within the finance industry. This course will help you learn the basic functions to perform statistical analysis on data sets in Excel 365.
Excel Fundamentals – Formulas for Finance Learning Objectives
- Use basic Excel functions to perform statistical analysis on data sets.
- Explore functions used to aggregate or summarize financial data in various ways.
- Compare various lookup functions to understand their advantages and disadvantages.
- Apply useful date functions for annual, quarterly, and monthly models.
- Compare the basic NPV & IRR and the more advanced XNPV & XIRR functions.
- Understand basic and advanced custom formatting for numbers and dates in Excel.
Who Should Take This Course?
This course is perfect for beginners, intermediate, and even advanced financial professional Excel users. The course starts with the basics, but quickly advances so even more proficient users will learn something new and have a great refresher.
Prerequisite Skills
Recommended skills to have before taking this course.
- Excel
- Valuation



