Excel training courses for financial modelling
Our Excel training courses for financial modelling have been developed specifically to address the need expressed by bookkeepers, small business owners, and financial analysts to learn how to use the program more efficiently in their day to day operations.
The short, but in-depth Excel training courses for financial modelling are presented by chartered accountants and financial analysts with years of experience in working with the program specifically to do financial modelling. The attendees at these Excel training courses thus will not just get book knowledge, but will get hands-on experience and the opportunity to learn how to apply the techniques learned effectively in their specific situations.
The financial modelling course includes all aspects required for day to day analysis and planning. You will be introduced to the various models and structures and will also work with examples. On the first day of the three day advanced course you will learn about model integrity and data validation methods as well as hyper linking and extraction of positive as well as negative balances. You will also learn how to complete a monthly budget financial model and how to apply logical tests. In addition the following are treated on the first day:
- Pivot table reports
- SUMIF
- Branch file consolidation
- Summing through the sheets
- Conversion of consolidated results to foreign currency.
The above will go hand in hand with exercises. Much more will be learned on the second and third day. The financial modelling Excel training courses are suitable for users who have already done a basic course in spreadsheets, have worked with them before, and need advanced skills in the software for effective financial modelling.
|