| Published | 2020-12-12 |
| Platform | Udemy |
| Rating | 4.11 |
| Number of Reviews | 38 |
| Number of Students | 191 |
| Price | $19.99 |
| Instructors |
Syed Muhammad Ali Shah
|
| Subjects |
Prepare How to Prepare Financial Models in MS Excel - Beginners to Advanced
OVERVIEW - Updated October 2021.
Financial Modeling is an essential skill for accounting and finance professional. It is very much in demand in the job market and is highly valued by employers.
Our Financial Modeling training takes you from basics to professional level. This sixteen hours training is based on practical exercises
The course focuses 40% on honing the participants MS Excel skills and 60% focus on application of MS Excel in Accounting and Finance
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
6. Financial functions in Excel
7. Microsoft Excel's Pivot Tables
8. Building a complete P&L in Excel - Case Study
9. Introduction to Excel charts
10. Profit and Loss - Case Study
11. Statement of Financial Position - Case Study
12. Statement of Cash Flows - Case Study
13. Financial modeling fundamentals
14. Introduction to Company Valuation and Introduction to Mergers & Acquisitions
15. Learn how to build a Discounted Cash Flow model in Excel - NPV and IRR
16. Investment Appraisal - Case Study
17. Business Valuation - Case Study
18. Capital Budgeting - The theory
19. Capital Budgeting - Case Study
20. Impact of interest rates and exchange rates on NPV
21. Sensitivity Analysis in Capital Budgeting
PREREQUISITES
1. Participants are expected to have basic knowledge of MS Excel. This could be measured as an MS Excel user for more than one year.
2. Basic knowledge of financial accounting.
3. Microsoft Office 2013 or later installed on your computer.