Basic Excel Business Analytics - Good Spreadsheet Model Design, Fixed Variable Cost Example

Basic Excel Business Analytics - Good Spreadsheet Model Design, Fixed Variable Cost Example

ExcelIsFun via YouTube Direct link

) Description of the Fixed Variable Cost Analysis for the manufacturing of a Quad Boomerangs From Gel Boomerangs

2 of 8

2 of 8

) Description of the Fixed Variable Cost Analysis for the manufacturing of a Quad Boomerangs From Gel Boomerangs

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. 1 ) Rules for Good Spreadsheet Model Design & Excel’s Golden Rule
  2. 2 ) Description of the Fixed Variable Cost Analysis for the manufacturing of a Quad Boomerangs From Gel Boomerangs
  3. 3 ) Create Formula Inputs Area (Formula Inputs, Parameters, Assumptions, Variables) with proper labeling and formatting
  4. 4 ) Create Math Formulas that describe our calculations for our model
  5. 5 ) Create Model Area that contains Decision Variable and later it will contain our Excel Formulas.
  6. 6 ) Influence Diagram to show the flow Formula Inputs and Formulas in the Model.
  7. 7 ) Create Excel Formulas in the Model Area with Proper Labels and Formatting.
  8. 8 ) What-If Analysis with our Model

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.