Curriculum

11 Topics
Warm-Up - Creating a Budget in Excel
NCAA T-Shirt Vendor
Woodworks Bookshelf Co.
Course Information
Spam Posts on Discussion Forums
NCAA T-Shirt Vendor
Formatting Formulas and Functions
Woodworks Bookshelf Co.
References Tables and Charts
Introduction to Excel
Introduce Yourself

12 Topics
Quality Sweater Company
B&N Bookstore
Quality Sweater Company
Goal Seek and One-Way Data Tables
The Break-Even Point
B&N Bookstore
Two-Way Data Tables and More Functions
What-If Analysis in Excel
Self-Evaluation for What-If Analysis
Haute Dog
Copy Shop
What-If Analysis and Uncertainty (Quality Sweater Company)

14 Topics
The 19th Hole
NPV Example: Gopher Drugs
The 19th Hole
Trendlines and Conditional Formatting
Gopher Drugs
Modeling Net Present Value
Midcourse Project
Sample Model - Bluejay Natural Gas
Decision Analysis through Regression and NPV
Self Evaluation for Decision Analysis
Model Set-Up - Bluejay Natural Gas
Exercise Equipment Company
Net Present Value
Decision Analysis through Regression (The 19th Hole)

17 Topics
Campaign Marketing
PC Tech Company
Investment Allocation
Busing Problem
What Is Linear Programming?
Adding Solver to Excel
Campaign Marketing
Using Solver for LP Problems
PC Tech Company
Investment Allocation
Busing Problem
Linear Programming
Intro to Linear Programming
Furniture Company
Feed Mix
Bus Company
LP and Uncertainty (Investment Allocation)

12 Topics
Transportation Problem Excel Template
Alternative Excel Template
New Hire Assignments
MLB Umpire Assignment
Transportation Problems
New Hire Assignments
Assignment Problems
MLB Umpire Assignment
Transportation and Assignment Problems
Construction Projects
College Professors
Identifying Transportation and Assignment Problems

20 Topics
Princess Brides
Bolsa de Café
Binary Investment Decision
Portfolio Variance
Motorcross Snowmobiles
Princess Brides
Bolsa de Café
Integer Programming in Solver
Binary Investment Decision
Binary Integer Programming with Solver
Portfolio Variance
Motorcross Snowmobiles
Nonlinear Programming with Solver
Final Project
Solution- Bluejay Natural Gas Project Selection
Integer Programming and Nonlinear Programming
Project Selection at Bluejay Natural Gas
Art Posters
Horizon Wireless
Baseball Stadium

  Write a Review

Business Analytics with Excel: Elementary to Advanced

Go to Free Course