Note: You must use Mozilla Firefox to save or open files on this site
Lab One
Reading for lab |
Lab Files (use 7-Zip
or WinZip) to unzip files
|
Demos |
|
Lab
1
|
Lab 1 data (zipped) |
|
|
| Creating Models | |||
| Goal Seek | Goal Seek data (zipped) | ||
| IF statement | IF data (zipped) | ||
|
|
|
||
Lab Two
Reading for lab |
Lab Files
(use 7-Zip or WinZip) to unzip files |
Demos |
|
| Lab
2 Sorting data in Excel |
Sorting data (zipped) | ||
| Subtotaling in Excel | Subtotals data (zipped) | ||
| Conditional formatting | Conditional formatting data(zipped) | ||
Charts (PowerPoint slides)
|
|
||
Lab Three
Reading for lab |
Lab Files (use 7-Zip or WinZip) to unzip files |
Demos |
|
Lab
3 LINEST functionData Tables (Break Even Analysis) |
Multiple Regression w/ Marketing problem Selmore (break Even using Data Table) |
|
|
Lab Four
Reading for lab |
Lab Files
(use 7-Zip or WinZip) to unzip files |
Demos |
|
| Lab
4 |
|
||
|
Online Management Training Inc. sales transactions
|
Groceriespt.xlsx |
|
|
Lab Five
Reading for lab |
Lab Files (use 7-Zip or WinZip) to unzip files |
Demos |
|
| Lab
5 |
|
||
|
Scenario Manager
|
|
||
Reading for lab |
Lab Files (use 7-Zip or WinZip) to unzip files |
Demos |
|
| Lab 6 |
|
||
|
|
|
||