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,
Lectures -64
Resources -9
Duration -10 hours
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Â
![MS Excel & Financial Modeling MS Excel & Financial Modeling](https://d3mxt5v3yxgcsr.cloudfront.net/courses/9336/course_9336_image.png)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advance Excel
24 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Business Reporting in Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Financial Modeling
17 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel File (Attachments)
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![user profile image](/market/public/assets/newDesign/img/default-user-img.jpg)
Saad Zubair Vohra
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)