My Profile
My Events
My Self-Study
My CPE Tracker
My Discounts
Member Directory
Upcoming Events
Communication Preferences
My Committees
My Transactions
My Dues
Online Store

Help

Sessions | Instructor | Event Registration |

Event Information

K2's Excel Financial Modeling Best Practices Webcast | 4203612B
Date: August 20, 2020
Event Start time: 10:00 AM   End time: 11:40 AM
Location: Webcast

Facility: Webcast Rebroadcast

 


Member:       $79
Nonmember: $109

CPE Credits:

2.00 CPE: Continuing Professional Education Technical


 

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.

 

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

 

Major Subjects:
 

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

 

Level of Difficulty:
Intermediate

Field of Interest:
Finance

Prerequisites:
 

Fundamental knowledge of computer operations and Microsoft Excel

 

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

 

Advanced Prep:
 

 None

 

Event Notes:
Save with Discount Programs

Join or Renew Today