A search engine of every*online CPE course.

Excel - Financial Modeling

Provided by:

Course Description

This comprehensive course is designed for professionals of all experience levels who would like to become familiar with financial modeling. It covers Excel-based financial modeling tools and explains, in detail, how to use the program to perform model display and model review, stress-testing, and other important topics for minimizing errors and ensuring accurate robust models. The course is packed with information on the essential concepts behind financial modeling and the practicalities of performing complex analysis in a clear, concise, easy-to-use manner. Utilizes Excel 2007 and above.

Learning Objectives

To recognize key characteristics of reporting To identify the steps for creating a report To recall various tips that will assist the Excel user in building reports To recognize characteristics of report design and structure To identify features of the Format as Table feature and TRIM function To recognize the characteristics of pivot tables To recall various tools available in Excel to use in preparing spreadsheets using summing functions To recall characteristics of Excels reporting accessory functions and features To recognize types of and uses for range names To identify types of controls available in Excel To recognize characteristics of conditional formats To recall features of various charting techniques To identify various report validation features in Excel To recall processes that should be included in the monthly reporting process To recall how charts should be formatted when working with multiple charts

Ratings and Reviews

To review this course, please login.

Please Review This Course

Overall Quality

Instructor

Usefulness

150 Characters Minimum

Submit
Course Information

Overall Quality

(0)

Instructor

(0)

Usefulness

(0)
Add to Transcript Write Review

Learning Format 14.0 Hours
Self-Study / On-Demand

Credit Type(s)
Management Advisory

Knowledge Level
Basic