The most important Excel formulas for financial analysis
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
If you want to become a master of Excel financial analysis and an expert on building financial models then you’ve come to the right place. We’ve built an Excel formulas cheat sheet of the most important formulas and functions required to become a spreadsheet power user.
Below is a written overview of the main formulas for your own self-study. However, if you want a video explanation of the formulas, check out our Free Excel Crash Course.
If you’re already a power user, check out our Advanced Excel Course and learn the most powerful combinations of formulas and functions.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.