Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

MS Excel & Financial Modeling

person icon Saad Zubair Vohra

4.1

MS Excel & Financial Modeling

Financial Modeling and Analysis are among the most highly-respected skills in the business world and job marketplace

updated on icon Updated on May, 2024

language icon Language - Hindi

person icon Saad Zubair Vohra

category icon Financial Analysis,Financial Modeling,Financial Modeling & Analysis,Accounting & Bookkeeping,Finance & Accounting,

Lectures -64

Resources -9

Duration -10 hours

4.1

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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

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 
MS Excel & Financial Modeling

Curriculum

Check out the detailed breakdown of what’s inside the course

Basic Excel
8 Lectures
  • play icon Class 1 Part 1 03:22 03:22
  • play icon Class 1 Part 2 07:28 07:28
  • play icon Class 1 Part 3 07:23 07:23
  • play icon Class 1 Part 4 05:37 05:37
  • play icon Class 1 Part 5 09:10 09:10
  • play icon Class 1 Part 6 06:17 06:17
  • play icon Class 1 Part 7 08:09 08:09
  • play icon Class 1 Part 8 02:43 02:43
Intermediate Excel
8 Lectures
Tutorialspoint
Advance Excel
24 Lectures
Tutorialspoint
Business Reporting in Excel
6 Lectures
Tutorialspoint
Financial Modeling
17 Lectures
Tutorialspoint
Excel File (Attachments)
1 Lectures
Tutorialspoint

Instructor Details

user profile image

Saad Zubair Vohra

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515