MS Excel & Financial Modeling
Financial Modeling and Analysis are among the most highly-respected skills in the business world and job marketplace
Office Productivity,Microsoft,Excel
Lectures -64
Resources -9
Duration -10 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Financial Modeling and Analysis are among the most highly-respected skills in the business world and job marketplace. From Banks, Accounting, Investment, Insurance and Business Decision-Making rely on complex analytical decisions every day. This financial modelling course will teach candidates to forecast the future performance of a company using a model built in Excel, candidates will learn the fundamentals of accounting, corporate finance, budgeting and forecasting and valuation.
Candidates will learn how to use Excel to produce financial forecasts that can explain the answers to relevant business problems. Candidates will be introduced to best-practice techniques of financial modelling and learn how to integrate income statements, balance sheets, and cash flow and eventually how to make strategic financial decisions.
Goals
- Financial Analysis using What if Analysis.
- Application of best practices in financial modelling.
- Preparation of operating & financial schedules.
- Scenario Management & Analysis in Model
- Financial Statements projection model - Case Study
- Discounted Cash Flow Model – Case Study
- Calculation of NPV, IRR,and Payback period
Prerequisites
- Accounting & Finance Background is required

Curriculum
Check out the detailed breakdown of what’s inside the course
Basic Excel
8 Lectures
-
Class 1 Part 1 03:22 03:22
-
Class 1 Part 2 07:28 07:28
-
Class 1 Part 3 07:23 07:23
-
Class 1 Part 4 05:37 05:37
-
Class 1 Part 5 09:10 09:10
-
Class 1 Part 6 06:17 06:17
-
Class 1 Part 7 08:09 08:09
-
Class 1 Part 8 02:43 02:43
Intermediate Excel
8 Lectures

Advance Excel
24 Lectures

Business Reporting in Excel
6 Lectures

Financial Modeling
17 Lectures

Excel File (Attachments)
1 Lectures

Instructor Details

Saad Zubair Vohra
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now