This class was formerly called "Business Modeling & Data Analysis"
Explore the updated outline and description
This class meets two consecutive days. Nov 4 & 5, 2021
Most workplaces have dozens of Excel spreadsheets full of the critical numbers that drive every aspect of the organization, whether it be finance, production, sales, marketing, engineering, etc.
You know all of it is valuable, but you are not sure how to use it effectively and efficiently. You are expected to interpret the data and make projections that keep the organization successful. How do you begin to take advantage of the data and information at your disposal to make good decisions?
In your day-to-day functions, regardless what they are, you have access to more data and information than you know what to do with. You know all of it is valuable, but you are not sure how to use it effectively and efficiently. You are expected to interpret the data and make projections that keep the organization successful. How do you begin to take advantage of the data and information at your disposal to make good decisions?
Dr. Sue will help you use common business tools and real world examples, that exist in Excel, to model the outcomes of different applications and help you make better choices. Excel has allowed individuals and companies to explore and make informed decisions without having to wait weeks or months for information. You will be able to take Excel from the simple usage of tables and charts to a powerful decision-making tool that works for you.
You will learn the practical steps to gather data and organize it, then analyze it in Excel’s basic and advanced tools. This will help you understand historical trends, diagnose the current situation, predict the future with accuracy measures, and find better metrics to measure the Key Performance Indicators (KPIs) of your business. Don’t continue making decisions in the dark, when this course will give you the tools to make better decisions.
This class will demonstrate all the Excel tools using practical examples from numerous functional areas of the business, including Operations/Production, Supply Chain, Marketing, Finance, Sales, Information Technology, Management, Human Resources, R & D, and many others. Regardless of your industry (service, aerospace, health, government, education, finance, non-profit, etc.), you will come out of this workshop with knowledge of many tools that help you harness the power Excel for analyzing data and information to make better decisions.
The classroom will be equipped with laptops for each participant to complete class exercises. Every participant must be comfortable working with spreadsheets in Excel.
Excel, Data, Databases, and Data Analytics
- Sources of Data – Big and Small
- Collecting, Organizing, and Cleaning Data
- Spreadsheets vs, Databases for Data Analysis
- Role of Enterprise Resource Planning (ERP)
- Data Analytics – The Next Competitive Advantage
Build an Excel Spreadsheet Model
- Review basics of Data Analysis in Excel
- The 7-step Spreadsheet Modeling Process
- Excel Tips and Best Practices in Excel
- Key Excel Tools: Goal Seek and Data Tables
- Breakeven Analysis What-if Example
- Cash Flow Analysis What-if Example
Optimize the Excel Spreadsheet Model
- Optimization vs. What-if Models
- Importance of Optimization Models
- The Basic Excel Optimization Model
- Key Excel add-ins: Solver and Solver Table
- Product/Marketing Mix Example
Develop Advanced Excel Optimization Models
- Capital Budgeting Example
- Workforce Scheduling Example
- Product/Service Pricing Example
- Extra: Portfolio and Investment Examples
Use Network Optimization Models in Excel
- Network Model – A Specific Optimization Model
- Excel vs. Microsoft Project for Network Models
- Project Scheduling Example
- Transportation / Supply chain Example
- Job or Machine Assignment Example
“Dr. Sue was very professional and knowledgeable. Very informative and enlightening. I will be able to take what I’ve learned and apply it to my job.”
Grant Waters, Project Controls Analyst, Evergy, Topeka, Kansas
“This class opened the realm of possibility that has evolved with the use of Microsoft Excel. The capability of Excel has allowed an individual/company to explore and make informed decisions without having to wait weeks or months for the information. Dr. Sue is very knowledgeable of the subject she teaches & has worked to stay current in this field. Thank you for making the 2 days fun and full of information & learning.”
Steve Roach, Textron Aviation, Wichita, Kansas
“Vital information/tools/tips for any Analyst, new and seasoned professional alike!
“Daniel Kautz, Project Manager, Wichita Kansas
“Great program. Very impressed with the structure of the classroom, lunch, etc. The subject matter was very useful in our day-to-day job functions. Dr. Sue is an excellent instructor! I thoroughly enjoyed the small class and the one-on-one assistance. Great learning experience and I look forward to returning in September for another class with Dr. Sue.”
Linda Holleman, Retail Sales Administrator, Great Plains Industries, Inc., Wichita, Kansas
“Great program. Excellent service overall. It was clear to me that CMD operates like a business and understand customer satisfaction and responding to the needs of customers. Dr. Sue was a great instructor. Very easy to work with and truly wants to help people learn the material. The real world examples are the best, these aren’t just made up out of the blue, but real world problems that you could see. I enjoyed “testing what I’ve learned” the most by building our own model from a paragraph.”
Brad Jones, Flint Hills Resources, Wichita, Kansas
This class will demonstrate all the Excel tools using practical examples from numerous functional areas of the business, including Operations/Production, Supply Chain, Marketing, Finance, Sales, Management, Human Resources, R & D, and many others. Regardless of your industry (service, aerospace, health, government, education, non-profit, etc.), you will come out of this workshop with knowledge of many tools that help you harness the power Excel for analyzing data and information to make better decisions.
You need to have a very basic understanding of Microsoft Excel to participate in this course.
Substitutions are free and must be done prior to the start of the class or certificate program.
Cancellations or rescheduling must be received in writing and full refunds will be given up to four business days prior to the start of class.
Any cancellation or reschedule submitted with three or less business days notice is subject to a $35 charge on 1 or 2 day classes and a $75 charge on certificate programs.
No refunds after the first day of the class or certificate program.