Financial Modelling in MS Excel
Prepare How to Prepare Financial Models in MS Excel - Beginners to Advanced
Financial Modelling in MS Excel udemy course free download
Prepare How to Prepare Financial Models in MS Excel - Beginners to Advanced
Overview
Financial modelling is an essential skill for accounting and finance rofessionals. It is very much in demand in the job market and is highly valued by employers.
Our financial modelling training takes you from basics to professional level. This sixteen-hour training is based on practical exercises
The course focuses 40% on honing the participants MS Excel skills and 60% on application of MS Excel in Accounting and Finance
What You Will Learn
1. Learn many of MS Excel's advanced features
2. Become proficient user of Excel within your team
3. Carry out regular tasks faster than ever before
4. Build Profit and Loss, Statement of Financial Position and Cash Flow statements
5. Build valuation models from scratch
6. Build Net Present Value model from scratch
7. Learn how to make neat and professional-looking charts and graphs
Detailed Content
1. Introduction to Excel
2. Useful tips and tools for your work in Excel
3. Keyboard shortcuts in Excel
4. Excel's key functions and functionalities made easy
5. Update! SUMIFS – Exercise
6. Financial functions in Excel
7. Microsoft Excel's Pivot Tables
8. Case study: Building a complete P&L in Excel
9. Introduction to Excel charts
10. Profit and Loss Case Study continued—with great-looking professional charts
11. Financial modeling fundamentals
12. Introduction to Company Valuation and Introduction to Mergers & Acquisitions
13. Learn how to build a Discounted Cash Flow model in Excel
14. Business Valuation: Complete practical exercise
15. Capital Budgeting: The theory
16. Capital Budgeting: A Complete Case study
17. Impact of interest rates and exchange rates on NPV
18. Sensitivity Analysis in Capital Budgeting
Pre-Requisites
1. We expect participants to have a basic understanding of MS Excel. One could measure this by considering someone who has been using MS Excel for more than a year.
2. Basic knowledge of financial accounting.
3. Microsoft Office 2013 or later installed on your computer.
About the Instructor
A qualified accounting and finance professional with over twenty years of extensive experience in diversified industry sectors such as auditing, large scale manufacturing and oil and gas.
Like most accounting and finance professionals, I started my career as finance executive and then over the years rose to the position of CFO in a multinational company in oil and gas industry.
I have also worked as a consultant with the World Bank and European Union on different projects in Middle East, Eastern Europe and CIS countries during 2011 to 2018 as a principal consultant for IFRS and Financial Management.
I am qualified professional with three professional qualifications MBA, ACCA and CIMA UK. I have been teaching IFRS, Financial Reporting, Financial Management and Performance Management for over fifteen years and my focus areas are ACCA and CIMA qualifications.
