This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis.
The main formulas and 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: loom.ly/us5oJEw
► Excel Fundamentals: loom.ly/4KnYciU
► Accounting Fundamentals: loom.ly/xHJgJO4
► Reading Financial Statements: loom.ly/2wrcPw8
► Fixed Income Fundamentals: 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 world's top universities, investment banks, accounting firms, and operating companies.
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: courses.corpor...
Join us on social media!
LinkedIn: / corporate-finance-inst...
Facebook: / corporatefinanceinstit...
Instagram: / corporatefinanceinstitute
#AdvancedExcel #ExcelFormulas #Excel