Financial Modeling in Spreadsheets

Learn basic business modeling including cash flows, investments, annuities, loan amortization, and more using Sheets.

Start Course for Free
4 Hours13 Videos52 Exercises8,400 Learners
4550 XP

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies


Course Description

Have you ever wanted to plan for retirement, understand the stock market, or create a cash flow for your business? In this course, you will learn how to build business and financial models in Sheets. Google Sheets is an excellent technology for business models! You can create a framework for your goal, like understanding the growth of investments, and then update that framework based on current data. You will learn the basics of business modeling focusing on cash flows, investments, annuities, loan amortization, and saving for retirement. By the end of the course, you will have gained referencing and function skills in Sheets that you can apply to all sorts of models.

  1. 1

    What are Models?

    Free

    An introduction to modeling financial statements in Sheets focusing on balance and income statements, which help create cash flow models.

    Play Chapter Now
    How to love models
    50 xp
    Format the income statement
    100 xp
    Create the sum values
    100 xp
    Copy sums for each year
    100 xp
    Continuing simple models with balance sheets
    50 xp
    Format a balance statement model
    100 xp
    Balance all the years
    100 xp
    Common size statement
    100 xp
    Build a cash flow model
    50 xp
    Update the cash flow
    100 xp
    Complete cash flow for all years
    100 xp
    Forecast Cash Flows
    100 xp

In the following tracks

Finance Fundamentals

Collaborators

Chester IsmayAmy Peterson
Erin Buchanan Headshot

Erin Buchanan

Professor at Harrisburg University of Science and Technology

Dr. Erin Buchanan is a Professor at Harrisburg University of Science and Technology where she teaches a variety of statistics courses, data science skills, and natural language processing. Her research focuses on applied statistics, the use and misuse of statistics, and computational linguistics. She runs a statistics YouTube channel channel and an associated website for everyone to improve their skills.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA