Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Quick Excel Course for Financial Modeling

person icon Blair Cook

4

Quick Excel Course for Financial Modeling

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Blair Cook

English [CC]

category icon Office Productivity,Excel,Microsoft Office

Lectures -13

Resources -4

Duration -1.5 hours

4

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

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

What will you learn in this course:

  • 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

What are the prerequisites for this course?

  • Basic proficiency with accounting and Excel.
Quick Excel Course for Financial Modeling

Curriculum

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

Introduction
8 Lectures
  • play icon Course Overview 04:07 04:07
  • play icon Planning your Financial Model 09:18 09:18
  • play icon Building a Model Template 12:28 12:28
  • play icon Projecting the Income Statement 13:03 13:03
  • play icon Projecting the Balance Sheet 16:37 16:37
  • play icon Projecting Cash Flows 14:22 14:22
  • play icon Advanced Financial Modeling 13:58 13:58
  • play icon BONUS LESSON: Top 5 Excel Features for Financial Modellers 07:48 07:48
Supporting Materials
4 Lectures
Tutorialspoint

Instructor Details

Blair Cook

Blair Cook

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

Feedbacks

N

Nayab

e

Very good

N

Nayab

e

Very good

N

Nayab

e

Good

N

Nayab

e

Good

Sunil Kumar

Sunil Kumar

e

Very Good

P

Pallavi kumari

e

This course is very helpful for me....

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