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.
Excel What-If Goal Seek Analysis for Amortization, Breakeven Point (BEP), and CAPM using Stock Beta.
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.
Apple Stock and S&P 500 Descriptives and Basic Trend Calculation using Excel
Pivot Tables and Predictive Regression Modeling for Prediction Modeling using International Used Vehicle Sales data.
Basic visualization and data modeling for predicting Patient Insurance Premiums
Running Prediction analysis using Regression Modeling for predicting insurance premiums for new patients