Finance & Accounting Online Course by Udemy, On Sale Here
Prepare How to Prepare Financial Models in MS Excel – Beginners to Advanced
An excellent training about Financial Modeling & Analysis
Learn Financial Modelling in MS Excel
OVERVIEWFinancial 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 exercisesThe course focuses 40% on honing the participants MS Excel skills and 60% focus on application of MS Excel in Accounting and FinanceWHAT YOU WILL LEARN1. Learn many of MS Excel advanced features2. Become proficient user of Excel within your team3. Carry out regular tasks faster than ever before4. Build Profit and Loss, Statement of Financial Position and Cash Flow statements5. Build valuation models from scratch6. Build Net Present Value model from scratch7. Learn how to make neat and professional looking charts and graphsDETAILED CONTENT1. Introduction to Excel2. Useful tips and tools for your work in Excel3. Keyboard shortcuts in Excel4. Excel’s key functions and functionalities made easy5. Update! SUMIFS Exercise6. Financial functions in Excel7. Microsoft Excel’s Pivot Tables8. Case study – Building a complete P & L in Excel9. Introduction to Excel charts10. Profit and Loss Case Study continued with great-looking professional charts11. Financial modeling fundamentals12. Introduction to Company Valuation and Introduction to Mergers & Acquisitions13. Learn how to build a Discounted Cash Flow model in Excel14. Business Valuation – Complete practical exercise15. Capital Budgeting – The theory16. Capital Budgeting – A Complete Case study17. Impact of interest rates and exchange rates on NPV18. Sensitivity Analysis in Capital BudgetingPREREQUISITES1. 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.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.