Advanced Excel Formulas (CF)

OBJECTIVE:
Participants will learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. The course builds on CFI’s free Excel Crash Course. The course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. Participants may pause and replay the instructor building all the formulas and functions on screen until they have mastered the exercises.

WHO WILL BENEFIT:
Spreadsheet users who are already proficient and looking to take their skills to an advanced level.

LEARNING OUTCOMES:
Participants will learn to how to use the Excel formulas, functions and data analysis tools listed below:

Formulas and Functions

  1. INDEX and MATCH
  2. IF with AND / OR
  3. OFFSET combined with other functions
  4. CHOOSE for creating scenarios
  5. INDIRECT combined with other functions
  6. XNPV and XIRR
  7. CELL, COUNTA and MID functions combined together
  8. PMT, IPMT and principal payment calculations

Data Analysis:

  1. Data tables
  2. Pivot tables
  3. Column and line charts
  4. Stacked column charts
  5. Waterfall charts
  6. Gauge charts
Course Code:  CF2002
CPD:  Estimated CPD Hour: Total - 4
Competency:  Information Technology
Course Level:  Advanced
When
4/20/2020 - 3/31/2021
Where
On Demand
Canada

Program


Monday, 20 April 2020

 
Time
4/20/2020 - 3/31/2021
4/20/2020

Sign In