Course description
The ability to create and understand financial models is one of the most valued skills in business and finance today.
Microsoft Excel has been the dominant vehicle used by finance and corporate professionals in the preparation and utilisation of the full range of financial models and other applications. Most users know that they could be getting more out of Excel which would result in them being able to build more flexible, dynamic and professional models. Unfortunately, this aspect of Excel often appears to be complex and intimidating.
Programme Summary
This intensive workshop starts with basics and progresses in a logical step by step manner to the more complex and rewarding tools needed to build more robust models that save time, reduce unnecessary human errors and customise applications that would be impossible to achieve with suboptimal models. Every section is followed by a direct application related to the financial issues.
The course will emphasize some important financial concepts that will assist in building vigorous models. It is designed to give you the information you need without making you wade through cumbersome explanations and endless technical background. Delegates will need some basic knowledge of Excel but not of professional modelling or programming.
Key Learning Points
- Develop a thorough understanding of Excel for financial modelling purposes
- Learn the needed tools to build models that are less time and effort consuming
- Gain the best practice in modelling forecasted financial statements (Balance sheet, income statement and cash flow statement)
- Work with over one million rows of data in seconds with Power Pivot
Upcoming start dates
Suitability - Who should attend?
Anyone who wishes to gain a better understanding of financial modelling techniques, from financial analysts to CEOs
Outcome / Qualification etc.
Benefits of Attending
- Translate specific business challenges into logically structured mathematical models
- Learn how to use powerful Excel® tools such as Solver and Goal Seek
- Draw more realistic conclusions from the results of your models
- Drive better performance through improved ‘What if?’ analyses
- Simulate the potential return on new capital investments
- Design budget models for departments, divisions, processes, or other entities
Training Course Content
Session One
- Pivot Tables, Power Pivot, & Data Validation
- Introduction to pivot tables
- Creating a pivot table report
- The pivot table wizard
- Percentage of column, percentage of raw, and percentage of previous
- Top and bottom 10 feature
- Retrieving data from external sources including access and internet
- Pivot charts manipulation
- Building one variable data tables
- Building two variables data tables
Session Two
- Creating financials from raw data
- How to link to pivot tables
- GETPIVOTTABLEDATA, SUMIF(S)
- Financials (Revenue, Expense, Profit)
- Interrelationships within a model
- Logical arrangement of the parts
- Model design and structure
- Attributes of good Excel models
- Exploring Excel functions
- Financial, Date and time, Statistical, Lookup & Reference, Database, Text, Logical, Information
- Data validation
- TOP 36 Functions & TIPS / TRICKS
- Basic, intermediate and advanced functions
- Conditional addition and counting functions
- Going through a spreadsheet that contains worked examples of all 40 functions