Advanced Excel Formulas

Advanced Excel Formulas
Corporate Finance Institute (CFI) on-demand courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The courses move through three levels of mastery for anyone looking to be an expert in financial modeling, valuation, and financial analysis. Participants typically include professionals in entry to mid-level positions in financial planning and analysis (FP&A), corporate development, treasury, investor relations, and capital markets. All participants are automatically issued certificates of completion after successfully finishing each course.


NOTE: Course login details are normally sent to registrants within one week from date of registration.

EL22230081

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.

OVERVIEW
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

  • 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 TUTORIAL INCLUDE

  • Datatables
  • Pivot tables
  • Column and line charts
  • Stacked column charts
  • Waterfall charts
  • Gauge charts
CPD- 4 Hours
When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand