Managing Workbook Data 

• Viewing and Arranging Worksheets
• Protecting Worksheets and Workbooks
• Saving Custom Views of a Worksheet
• Adding a Worksheet Background
• Preparing a Workbook for Distribution
• Inserting Hyperlinks
• Saving a Workbook for Distribution
• Grouping Worksheets

Using Tables 

• Planning a Table
• Creating a Table
• Adding Table Data
• Finding and Replacing Table Data
• Deleting Table Data
• Sorting Table Data
• Using Formulas in a Table
• Printing a Table

Analyzing Table Data 

• Filtering a Table
• Creating a Custom Filter
• Filtering a Table with Advanced Filter
• Extracting Table Data
• Looking up Values in a Table
• Summarizing Table Data
• Validating Table Data
• Creating Subototals 

Automating Worksheet Tasks 

• Planning a Macro
• Enabling a Macro
• Recording a Macro
• Running a Macro
• Editing a Macro
• Using Shortcut Keys with Macros
• Using the Personal Macro Workbook
• Assigning a Macro to a Button
• Concepts Review
• Skills Review
• Independent Challenges 

Enhancing Charts 

• Customizing a Data Series
• Changing a Data Source and Adding Data Labels
• Formatting the Axes of a Chart
• Adding a Data Table to a Chart
• Rotating a Chart
• Enhancing a Chart with WordArt
• Adding a Picture to a Chart
• Identifying Data Trends 

Sharing Excel Files and Incorporating Web Information

• Sharing Excel Files
• Setting up a Shared Workbook for Multiple Users
• Tracking Revisions in a Shared Workbook
• Applying and Modifying Passowrds
• Working with XML Schemas
• Importing and Exporting XML Data
• Running Web Queries Retrieve External Data
• Importing and Exporting HTML Data