Advanced Excel Objectives
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, for
example use Goal Seek to define a total and 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 |
|
