Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Finance Fundamentals in Google Sheets

via DataCamp

Overview

DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
Learn the Google Sheet skills you need to make data-driven financial decisions. In this track, you’ll learn to build dashboards to track financial securities performance, measure reward and risk indicators, and create investment models. Through hands-on exercises, you’ll create impressive visualizations and use conditional formulas to produce presentation-ready spreadsheets. You’ll then flex your financial muscles as you focus on cash flows, investments, annuities, saving for retirement, and even how to create a loan amortization schedule to track your own loans. By the end of the track, you'll be ready to build monitoring tools, as used by traders and financial analysts and navigate the world of finance using Google Sheets.

Syllabus

  • Financial Analytics in Google Sheets
    • Learn how to build a graphical dashboard with Google Sheets to track the performance of financial securities.
  • Financial Modeling in Google Sheets
    • Learn basic business modeling including cash flows, investments, annuities, loan amortization, and more using Google Sheets.
  • Loan Amortization in Google Sheets
    • Learn how to build an amortization dashboard in Google Sheets with financial and conditional formulas.

Taught by

David Ardia, Riccardo Mancini, Erin Buchanan, and Brent Allen

Reviews

Start your review of Finance Fundamentals in Google Sheets

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.