In this lesson, you will learn how to:
1. Use the Data Ribbon to Sort and Filter the data.
2. Outline the data with the Outline Tools and use the Outline to
Show or Hide Rows of information.
3. Use the Data Tools to perform a What-If Analysis and use Goal
Seek to see how that goal can be met.
4. Use the Scenario Manage to define Best, Worst and Expected
results by changing one or more cells.
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 |
|
|
|
