Completed
) Rules for Good Spreadsheet Model Design & Excel’s Golden Rule
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Basic Excel Business Analytics - Good Spreadsheet Model Design, Fixed Variable Cost Example
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Rules for Good Spreadsheet Model Design & Excel’s Golden Rule
- 2 ) Description of the Fixed Variable Cost Analysis for the manufacturing of a Quad Boomerangs From Gel Boomerangs
- 3 ) Create Formula Inputs Area (Formula Inputs, Parameters, Assumptions, Variables) with proper labeling and formatting
- 4 ) Create Math Formulas that describe our calculations for our model
- 5 ) Create Model Area that contains Decision Variable and later it will contain our Excel Formulas.
- 6 ) Influence Diagram to show the flow Formula Inputs and Formulas in the Model.
- 7 ) Create Excel Formulas in the Model Area with Proper Labels and Formatting.
- 8 ) What-If Analysis with our Model
