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 |
|
||
|
|