Advanced Excel Formulas - Course Preview | Corporate Finance Institute

This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. Enroll in the Full Course: http://courses.corporatefinanceinstit...

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

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

-- FREE COURSES & CERTIFICATES --
Enroll in our FREE online courses and earn industry-recognized certificates to advance your career:

► Introduction to Corporate Finance: https://loom.ly/us5oJEw

► Excel Fundamentals: https://loom.ly/4KnYciU

► Accounting Fundamentals: https://loom.ly/xHJgJO4

► Reading Financial Statements: https://loom.ly/2wrcPw8

► Fixed Income Fundamentals: https://loom.ly/DZdjDA0

-- ABOUT CORPORATE FINANCE INSTITUTE --

CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world.

By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst.

Explore CFI courses: https://courses.corporatefinanceinsti...


-- JOIN US ON SOCIAL MEDIA --

LinkedIn:   / corporate-finance-institute-cfi-  
Facebook:   / corporatefinanceinstitute.cfi  
Instagram:   / corporatefinanceinstitute