Learn Financial Modelling in MS Excel

[Srbija]

Learn Financial Modelling in MS Excel
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz
Language: English | SRT | Size: 7.26 GB | Duration: 15h 36m



What you'll learn
This course is designed for accounting and finance professionals who are keen to learn Financial Modelling in MS Excel. Financial Modelling and MS Excel are two key essential skills for all accounting and finance professionals.
Requirements
Basic knowledge of MS Excel and Basics of Accounting and Finance

Description
OVERVIEW

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

WHAT YOU WILL LEARN

1. Learn many of MS Excel 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

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.


Who this course is for:
Accounting and Finance professionals as well as accounting and finance students.


Homepage

Hidden Content

Give reaction to this post to see the hidden content.

 

 

 

 

 

 

 

 

 

 

Hidden Content

Give reaction to this post to see the hidden content.

 

 

 

Edited August 18, 2021 by Bad Karma
Dead links removed