Excel 2010: Tables and Lists

Work Smarter, Not Harder


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