A sample spreadsheet that uses Outlines
and What-If Scenarios to analyze the data.
Brown Bag Lunch Sales Team.xlsx
Do the Practice
Activity, page 81.
Review the Test questions, page 82.
This lesson shows the Data Ribbon.
1.
Data->Sort and
Filter->Sort, page 51
2.
Data->Sort and
Filter->Filter, page 52
3.
Data -> Sort &
Filter-> Clear, page 55
4.
Data -> Outline->
Subtotal, page 56
5.
Data -> Outline->
Subtotal->Group->Group,
page 66
6.
Data -> Data
Tools->What-If Analysis-> Goal Seek, page
69
7.
Data -> Data
Tools->What-If Analysis-> Scenario Manager, page
71 |
|
|
|
