Quick Excel Course for Financial Modeling

Name: Quick Excel Course for Financial Modeling
Rating: 4 (72 reviews)
Author: Blair Cook

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

category icon Office Productivity,Excel,Microsoft Office

Lectures -13

Resources -4

Duration -1.5 hours

4 ★★★★ ★

Add to Cart Buy Now

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

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

Supporting Materials
4 Lectures

Instructor Details

Blair Cook

Thought Leaders in the Field of Executive Finance

A financial executive and corporate director with a broad base of experience working as a financial leader, catalyst, operator and steward in a number of public and private companies operating in a broad array of industries, with a deep background as a financial, consulting, and accounting educator providing professional development services to Big 4 Public Accounting Firms, universities, and professional institutes.

Specialties:Leadership, finance, accounting, mergers and acquisitions, auditing, instructional design, facilitation and instruction, authoring, decision analysis