K2's Excel Financial Modeling Best Practices Webcast | 4203612A

Course Details

Date

Friday, July 17, 2020

5:00am – 6:40am
(Registration: 4:30am)

Field of Study

Finance

Course Number

4203612A

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Intermediate

Vendor

CalCPA Education Foundation

Prerequisites

Fundamental knowledge of computer operations and Microsoft Excel

Description




Excel remains the tool of choice for many professionals to build financial models, including forecasted financial statements and budgets. Yet many have never received any training on best practices to build financial modeling spreadsheets. Join us to learn amazing techniques that will save valuable time and improve the accuracy and quality of your results.

Highlights




Design considerations for Excel-based models
Advanced options for analyzing your models
Troubleshooting your models
Formatting reports for improved readability

Objectives




Identify ten best practices for creating financial models in Excel
Utilize Excel features and add-in services for sensitivity, trend, and discounted cash-flow analyses
Create optimization models using Excel's Solver tool
Implement procedures for eliminating errors in Excel-based financial models
Incorporate various formatting techniques to improve the usefulness of reports

Designed For




Business professionals who are seeking to utilize the Windows-based version of Excel more efficiently and effectively when creating financial models, plans, and analyses

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$75.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$101.00
Your Price $101.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts