Skip to main content
Loading
Toggle navigation
Cart
Sign In
Keyword Search
About Us
Toggle
Overview
Legislation
Bylaws
Code of Conduct
Board of Directors
Our Team
Become a CPA
Toggle
Overview
What CPAs Do
Becoming a Member
Toggle
Post-Secondary Graduates
Candidates Completing the CPA ASB Requirements
Members of Another CPA Provincial Body
Internationally Designated Accountants
Protecting the Public
Toggle
Overview
Discipline Process
Public Notices
Members
Toggle
Overview
Use of the CPA Designation
Code of Conduct
CPA Logo Usage
Resignation of Membership
Retiring Members
Financial Literacy
Firms
Toggle
Firm Registration
Firm Name Policy
Professional Liability Insurance
Practice Inspection
CPA Logo Usage
Public Accounting
Toggle
Public Accounting Licences
Post Designation Public Accounting Education Program (PDPA)
Professional Development
News & Publications
Careers
Contact Us
Directories
Skip breadcrumb navigation
Excel Modeling Fundamentals - 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.
EL21220031
This four part series provides tips and tricks for Excel model builders, gives advice on how to audit your financial models, demonstrates how to use better formulas, and shows you how to monitor and handle uncertainty using scenario planning.
MODULE 1 - EXCEL TIPS AND TRICKS
Learn how to speed up your Excel modeling skills by using keystroke navigation
Significantly improve how you can edit your worksheet by learning how to use editing shortcuts in Excel
Develop the skill every model builder needs in editing and modeling your spreadsheet in mere minutes
MODULE 2 - BETTER FORMULAS
• Build flexibility into financial forecasts
• Break down complex calculations
• Minimize errors in Excel models
• Understand Excel function syntax performance?
MODULE 3 - CATERING FOR UNCERTAINT
Y
• Learn how to perform sensitivity analysis
• Understand how data tables and goal seek can facilitate your model building process
• Learn how to measure the impact of future uncertainty on cash flows and profit with scenario planning
• Learn how to use scenario and solver tools to see how certain inputs can impact your model
MODULE 4 - AUDITING A MODEL
• Learn how to quickly and easily find errors and audit a spreadsheet
• Understand how the auditing tool-bar can help make your spreadsheet error-free
• Learn how to use test data to uncover errors
1 Passport Day - 4 PD Hours
When
4/1/2021 - 3/31/2022
Where
On-line
Username
Password
Keep me signed in
Forgot password?
Register for another event
8.5.2
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##