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
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
eCourse 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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now