Financial Modeling and Data Analysis
Spreadsheets are amazing tools for organizing information, performing analysis, and persuading others. In this hands-on course, we will use spreadsheets to evaluate financial projects and analyze data. In the finance portion of this course, we will build financial models to evaluate projects on both a pre-tax unleveraged basis and an after-tax leveraged basis. Evaluation criteria such as NPV, IRR, coverages, and sensitivities will be covered. In the data portion of this course, we will create meaning from data sets by learning to organize, analyze, summarize, and present insights about the data. Topics covered will include: Functions, Filters, Pivot Tables, and Basic Statistics.