Tutorialspoint

Quick Excel for Financial Modeling

This course teaches the fundamentals of financially modeling a business using Excel

Course Description

In this course we learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. 

We concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. We use an approach that keeps model integrity and credibility top of mind throughout development.

Who this course is for:

  • Anyone interested in finance, accounting, or related fields.

Goals

  • Identify a disciplined approach for using Excel to develop financial analysis.
  • Discover how to prepare financial projections of the income statement, balance sheet, and statement of cash flows.

Prerequisites

  • Basic proficiency with accounting and Excel.
Show More

Curriculum

  • Course Overview
    04:07
    Preview
  • Planning your Financial Model
    09:18
    Preview
  • Building a Model Template
    12:28
  • Projecting the Income Statement
    13:03
  • Projecting the Balance Sheet
    16:37
  • Projecting Cash Flows
    14:22
  • Advanced Financial Modeling
    13:58
  • BONUS LESSON: Top 5 Excel Features for Financial Modellers
    07:48
Tutorialspoint
Feedbacks
4.8
Course Rating
83%
17%
0%
0%
0%

    Feedbacks (6)

  • Nayab
    Nayab

    Very good

  • Nayab
    Nayab

    Very good

  • Nayab
    Nayab

    Good

  • Nayab
    Nayab

    Good

  • Sunil Kumar
    Sunil Kumar

    Very Good

  • Pallavi kumari
    Pallavi kumari

    This course is very helpful for me....

Quick Excel for Financial Modeling
This Course Includes
  • 1.5 hours
  • 12 Lectures
  • 4 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate