Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm
Learn the rules for Good Spreadsheet Model Design and see an example of how to create a good Spreadsheet Model for Fixed Cost Variable Coast Analysis:
1) (00:17) Rules for Good Spreadsheet Model Design & Excel’s Golden Rule
2) (05:05) Description of the Fixed Variable Cost Analysis for the manufacturing of a Quad Boomerangs From Gel Boomerangs
3) (07:55) Create Formula Inputs Area (Formula Inputs, Parameters, Assumptions, Variables) with proper labeling and formatting
4) (12:28) Create Math Formulas that describe our calculations for our model
5) (13:32) Create Model Area that contains Decision Variable and later it will contain our Excel Formulas.
6) (17:52) Influence Diagram to show the flow Formula Inputs and Formulas in the Model.
7) (30:27) Create Excel Formulas in the Model Area with Proper Labels and Formatting.
8) (35:43) What-If Analysis with our Model
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.