Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example
Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example Transcript and Lesson Notes
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn the rules for Good Spreadsheet Model Design and see an example of how to create a good Spreadsheet Model for Fixed C
Quick Summary
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn the rules for Good Spreadsheet Model Design and see an example of how to create a good Spreadsheet Model for Fixed C
Key Takeaways
- Review the core idea: Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn the rules for Good Spreadsheet Model Design and see an example of how to create a good Spreadsheet Model for Fixed C
- Understand how Excel fits into Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example.
- Understand how Microsoft Excel fits into Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example.
- Understand how Highline College fits into Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example.
- Understand how Mike Girvin fits into Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example.
Key Concepts
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.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.
Lesson FAQs
What is Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example about?
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn the rules for Good Spreadsheet Model Design and see an example of how to create a good Spreadsheet Model for Fixed C
What key concepts are covered in this lesson?
The lesson covers Excel, Microsoft Excel, Highline College, Mike Girvin, excelisfun.
What should I learn before Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example?
Review the previous lessons in Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more., then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: Excel, Microsoft Excel, Highline College, Mike Girvin.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
