Quick Excel for Financial Modeling

Course

Online

£ 3 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About 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

Anyone interested in finance, accounting, or related fields

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Using excel
  • Financial Training
  • Planning
  • Financial
  • Finance
  • Balance Sheet
  • Budgeting
  • Excel

Course programme

Introduction 8 lectures 01:31:44 Course Overview Planning your Financial Model Quiz: Planning Building a Model Template Quiz: Building the Template Projecting the Income Statement Quiz: Projecting the income statement Projecting the Balance Sheet Quiz: Projecting the balance sheet Projecting Cash Flows Quiz: Projecting cash flows Advanced Financial Modeling Quiz: Advanced financial modeling BONUS LESSON: Top 5 Excel Features for Financial Modellers Introduction 8 lectures 01:31:44 Course Overview Planning your Financial Model Quiz: Planning Building a Model Template Quiz: Building the Template Projecting the Income Statement Quiz: Projecting the income statement Projecting the Balance Sheet Quiz: Projecting the balance sheet Projecting Cash Flows Quiz: Projecting cash flows Advanced Financial Modeling Quiz: Advanced financial modeling BONUS LESSON: Top 5 Excel Features for Financial Modellers Course Overview Course Overview Course Overview Course Overview Planning your Financial Model Planning your Financial Model Planning your Financial Model Planning your Financial Model Quiz: Planning Quiz: Planning Quiz: Planning Quiz: Planning Building a Model Template Building a Model Template Building a Model Template Building a Model Template Quiz: Building the Template Quiz: Building the Template Quiz: Building the Template Quiz: Building the Template Projecting the Income Statement Projecting the Income Statement Projecting the Income Statement Projecting the Income Statement Quiz: Projecting the income statement Quiz: Projecting the income statement Quiz: Projecting the income statement Quiz: Projecting the income statement Projecting the Balance Sheet Projecting the Balance Sheet Projecting the Balance Sheet Projecting the Balance Sheet Quiz: Projecting the balance sheet Quiz: Projecting the balance sheet Quiz: Projecting the balance sheet Quiz: Projecting the balance sheet Projecting Cash Flows Projecting Cash Flows Projecting Cash Flows Projecting Cash Flows Quiz: Projecting cash flows Quiz: Projecting cash flows Quiz: Projecting cash flows Quiz: Projecting cash flows Advanced Financial Modeling Advanced Financial Modeling Advanced Financial Modeling Advanced Financial Modeling Quiz: Advanced financial modeling Quiz: Advanced financial modeling Quiz: Advanced financial modeling Quiz: Advanced financial modeling BONUS LESSON: Top 5 Excel Features for Financial Modellers BONUS LESSON: Top 5 Excel Features for Financial Modellers BONUS LESSON: Top 5 Excel Features for Financial Modellers BONUS LESSON: Top 5 Excel Features for Financial Modellers Supporting Materials 3 lectures 00:00 Slides: Financial Modeling Using Excel Financial Modeling Using Excel Glossary/Index Excel Files "Start and Solution" Supporting Materials 3 lectures 00:00 Slides: Financial Modeling Using Excel Financial Modeling Using Excel Glossary/Index Excel Files "Start and Solution" Slides: Financial Modeling Using Excel Slides: Financial Modeling Using Excel Slides: Financial Modeling Using Excel Slides: Financial Modeling Using Excel Financial Modeling Using Excel Glossary/Index Financial Modeling Using Excel Glossary/Index Financial Modeling Using Excel Glossary/Index Financial Modeling Using Excel Glossary/Index Excel Files "Start and Solution" Excel Files "Start and Solution" Excel Files "Start and Solution" Excel Files "Start and Solution"

Additional information

Basic proficiency with accounting and Excel

Quick Excel for Financial Modeling

£ 3 + VAT