Completed
) Create Model Area that contains Decision Variable and later it will contain our Excel Formulas.
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
