Become an Excel power user with the most advanced formulas and functions for financial analysis

NEW YORK, NEW YORK, UNITED STATES, March 13, 2017 /EINPresswire.com/ -- CFI, a leading global provider of online financial modeling training, today announced the launch of its new Advanced Excel Formulas Course. CFI’s latest course is designed to replicate the training experience of a new financial analyst hired at a global investment bank.

"CFI's mission is to help anyone in the world learn how to perform world class financial analysis, and this advanced Excel course is a major step towards that end," said Tim Vipond, CEO of the Corporate Finance Institute. "For anyone who wants to take their Excel skill to the next level, this course provides a powerful combination of formulas and functions, which taken in conjunction with each other produce extremely advanced financial analysis."


About the Advanced Excel Formulas Course:

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

This advanced tutorial will help you become a world class financial analyst for careers in investment banking, private equity, corporate development, equity research and FP&A.


The main formulas & functions covered in this course include:

- INDEX and MATCH
- IF with AND / OR
- OFFSET combined with other functions
- CHOOSE for creating scenarios
- INDIRECT combined with other functions
- XNPV and XIRR
- CELL, COUNTA and MID functions combined together
- PMT, IPMT and principal payment calculations
- Other combinations of formulas and functions

The main types of data analysis in this advanced tutorial include:

- Data tables
- Pivot tables
- Column and line charts
- Stacked column charts
- Waterfall charts
- Gauge charts


Who should take this course:

This Excel course is designed for anyone who is seeking to develop advanced financial modeling skills. It’s aimed at professionals in investment banking, equity research, commercial banking, financial planning and analysis, and anyone interested in mastering the art of building models from scratch.


About CFI:

The Corporate Finance Institute (CFI) is a global online financial training firm, specializing in financial modeling, business valuation, and advanced financial analysis for corporate finance careers. CFI courses pick up where business school leaves off to teach you on-the-job aspects of corporate finance and accounting. These courses have trained thousands of students and professionals at many of the top universities, institutions and corporations in the world.

Tim Vipond, CEO
Corporate Finance Institute
1-800-817-7539
email us here