Tech & Excel Analytics
Basic Mortgage Javascript Program
Excel Skills
BreakEven Analysis I
Break even Analysis is a helpful way to figure out at how much you need to sell to start making profits. How many clothes does a retail store need to sell to cover all its costs and expenses? How much should you price your products or services if you know your demand?
What-if analysis is a scenario analysis that you can use to achieve a certain objective.
Breakeven Analysis II
Excel What-If Goal Seek Analysis for Amortization, Breakeven Point (BEP), and CAPM using Stock Beta.
Basic Excel Manipulations
The three videos are quick takes on how to run basic data manipulations, filtering and tabulations in Excel.
A pivot table is a way to summarize and represent large data in a meaningful way that makes business sense.
We also learn how to create a custom Google map based on location data in an Excel spreadsheet.
AAPL stock Descriptives & Trend
Apple Stock and S&P 500 Descriptives and Basic Trend Calculation using Excel
Excel Predictive Analytics
Pivot Tables and Predictive Regression Modeling for Prediction Modeling using International Used Vehicle Sales data.
Data Modeling Overview and Prediction Modeling I
Basic visualization and data modeling for predicting Patient Insurance Premiums
Data Modeling Overview and Prediction Modeling II
Running Prediction analysis using Regression Modeling for predicting insurance premiums for new patients