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.
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.Login