Excel: Modeling for Beginners
38mBeginner2024-08-06
Authors
Jordan Goldmeier
Author, Entrepreneur, and Keynote Speaker
Course details
Models help businesses make better decisions by creating a simplified version of a process. In Excel, you can model just about anything, as long as you know the inputs, assumptions, best practices, tools, and techniques. In this course, Jordan Goldmeier—author, entrepreneur, and Microsoft MVP—defines what a model is and shows you how best to use Excel to represent the model. Learn important functions that will allow you to make predictions and forecasts around your data. Plus, find out how to present results to stakeholders.
Skills covered
Data ModelingSpreadsheetsMicrosoft ExcelData ScienceBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Learn the basics of modeling in Excel
- 02 - Why use Excel
1. Models - Definitions
- 03 - What is a model
- 04 - Picking the best Excel model
- 05 - Three keys to Excel modeling
2. Our First Model - Creating a Value-Based Hierarchy
- 06 - Introduction to value-based modeling
- 07 - Setting up the spreadsheet
3. Advanced Models
- 08 - Understanding different types of models
- 09 - Forecasting sales
- 10 - Workforce planning
- 11 - Simulating when attendees come to the theater
Conclusion
- 12 - Where to advance your Excel skills