Outlining And Grouping Your Data
Using Automatic Outlining
Displaying And Collapsing Levels
Grouping Data Manually
Creating Subtotals
Lesson 1.2
Pivot Tables
What Is A Pivot Table?
Creating A Pivot Table Frame
Specifying Data In A Pivot Tables
Rearranging Pivot Table Data
Lesson 1.3
More On Pivot Tables
Modifying Pivot Table Calculations
Formatting A Pivot Table
Refreshing A Pivot Table
Charting A Pivot Table
Creating A Pivot Table Based On Data From An External
Database
Lesson 1.4
Exploring
Scenarios
What Is A Scenario?
Creating A Scenario
Creating A Scenario Summary Report
Saving Multiple Scenarios
Lesson 1.5
What If Analysis
Using A One And Two Input Data Table
Using Goal Seek
Using Solver
SECTION 2:
Excel And The Internet
Lesson 2.1
Excel And Hyperlinks
Hyperlinks And The Internet
Inserting Hyperlinks
Modifying Hyperlinks
Using The Web Toolbar
Browsing Hyperlinks In Excel
Lesson 2.2
Excel Workbooks As Web
Pages
Interactive And Non-Interactive Web Pages
Saving A Workbook As A Web Page
Saving A Worksheet As A Web
