Advanced Excel Formulas Course - On-demand

Advanced Excel Formulas Course - On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


EL19200121

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

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

½ Passport  Day - 4 PD Hours
When
4/1/2019 - 3/31/2020
Where
On-Line