Advanced Excel Formulas (CF)

Participants will learn the most advanced formulas, functions and types of financial analysis to be an Excel power user.

Corporate Finance Institute (CFI) on-demand courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance and supporting skillsets. 

After registering for a CFI On Demand Course, CPA Saskatchewan will send you information on how to access the course within 2 business days.

On completion of the CFI courses, CFI will issue a certificate as supporting documentation for CPD audit purposes.

Click HERE for more information.

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 how to use the Excel formulas, functions and data analysis tools listed below:

Formulas and Functions

  •  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

Data tables

  •  Pivot tables
  • Column and line charts
  • Stacked column charts
  • Waterfall charts
  • Gauge charts
When
5/7/2021 - 3/31/2022
Where
On Demand

Personal Passport Eligibility

Corporate Passport Eligibility

 

No content found

Please sign in to register