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:
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

•  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 Analysis:

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