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.
Overview
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