MS Excel & Financial Modeling
Financial Modeling and Analysis are among the most highly-respected skills in the business world and job marketplace
Financial Analysis,Financial Modeling,Financial Modeling & Analysis,Accounting & Bookkeeping,Finance & Accounting
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
What will you learn in this course:
- 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
What are the prerequisites for this course?
- 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
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

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