My education at the eller college of Management has put a major emphasis on technological proficiency. The following page provides examples of my work in Excel, as well as data visualization using Tableau
Work With Excel
This screenshot shows my proficiency in creating models of mortgages. In this example, calculations for the interest expense were based on the APR but I also can make models using the EAR as well.
To the left, I created a model of a bond. To gather the data, I used the XlOOKUP function.
I am also proficient in using the MATCH and INDEX functions, which is what I used to create the modle's on the right.
This image shows a model I created based on stocks in a large portfolio.
Data Visulization With Tableau
The following visualizations were created based on a large excel file with data from Amazon orders. Using excel, we and ran regressions as well as correlation matrix to figure out what data has the most significant impacts on profit per order. Then we connected our spreadsheet to excel and made the following visualizations. These visuals were created in tandem with a written report which is highlighted in the reports section of my website.
