# CFRM 506: Financial Data Analysis

> Reading Material:
>
> * *VBA For Modelers*, S. Albright, 2015.
> * *Advanced Modeling in Finance*, M. Jackson, 2001.
> * *Microsoft SQL Server & T-SQL*, B. Forta, 2008.

This course introduced me to applying the software Microsoft Excel, VBA, and SQL for financial data access and analysis.

1. Microsoft Excel
   1. Solver
   2. Goal Seek
   3. Pivot Tables
   4. Integration with R
2. VBA
   1. The Visual Basic Programming Language
   2. Goal Seek
   3. Dynamically Linked Libraries
3. Databases and SQL
4. In-Database Machine Learning Services with R