Login

If you are a CPA Alberta member, or have a CPA Alberta account, please login with your account information.

If you are a non-member and do not already have an account, please create an account.

Forgot your account number or password?

Need help registering for a seminar? See our How to Register instructions.

  1.  
  2.  

Centennial 2010
  • Location:
 

FINANCIAL MODELING FUNDAMENTALS


Level:
Competency: Corporate Finance
Seminar Code: 01601
Format: Recorded Webinar 4 Hours
CPD Hours: 4
Availability: Spaces available


Register before Mar 24, 2018 and pay the early fee!
Date: Saturday, Mar 31, 2018
Time: 12:00 AM
Location:

,
Meeting Room:
Fee Options: Tickets Required: 6 ticket(s)
Fee Required: N/A - Early Member
N/A - Early Non-Member
$180.00 - Regular Member
$180.00 - Regular Non-Member
Seminar Description: Available now! Please ignore its "Date and time" noted in the cart item listing. Session expires 3 months after purchase.

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
1. Learn how to speed up your Excel modeling skills by using keystroke navigation.
2. Significantly improve how you can edit your worksheet by learning how to use editing shortcuts in Excel.
3. Develop the skill every model builder needs in editing and modeling your spreadsheet in mere minutes.
MODULE 2 - BETTER FORMULAS
1. Build flexibility into financial forecasts.
2. Break down complex calculations.
3. Minimize errors in Excel models.
4. Understand Excel function syntax performance
MODULE 3 - CATERING FOR UNCERTAINTY
1. Learn how to perform sensitivity analysis.
2. Understand how data tables and goal seek can facilitate your model building process.
3. Learn how to measure the impact of future uncertainty on cash flows and profit with scenario planning.
4. Learn how to use scenario and solver tools to see how certain inputs can impact your model.
MODULE 4 - AUDITING A MODEL
1. Learn how to quickly and easily find errors and audit a spreadsheet.
2. Understand how the auditing tool-bar can help make your spreadsheet error-free.
3. Learn how to use test data to uncover errors.
Seminar Outline:
Pre-requisite:
Who Will Benefit:
Seminar Leader(s):
Special Notes: Login credentials for this recorded webinar will be sent by e-mail within 2 to 5 business days after registration.
Additional Offerings:
Can't make it to this session? See the other offerings of this seminar.

Terms and Conditions