Lookup Formulas

This module explains how to make use of Vlookup, Hlookup to retrieve desired items in Excel Tables.

Lessons

• Using VLookup
• Using HLookup

Lab : Practice 4

After completing this module, students will be able to:

• Make use of Vlookup and Hlookup

Exporting and Importing Data

This module explains how to import and export Excel data to text formats. It also shows how to import data from the web.

Lessons

• Exporting Data to Other Applications
• Exporting to XML
• Importing Data from Text Files
• Changing External Data Range Properties
• Importing Data from Other Applications
• Removing the Query Definition
• Importing Dynamic Data from the Web
• Copying a Table from a Web Page

Lab : Practice 5

After completing this module, students will be able to:

• Import and export data to Text format
• Import data from other applications
• Import data from the Web

Creating/Revising PivotTables

This module explains how to use determine the source needed to create its PivotTable/PivotChart report.

Lessons

• Creating a PivotTable Report
• Adding PivotTable Report Fields
• Selecting a Page Field Item
• Refreshing a PivotTable Report
• Changing the Summary Function
• Adding New Fields to a PivotTable Report
• Moving PivotTable Report Fields
• Hiding/Unhiding PivotTable Report Items
• Deleting PivotTable Report Fields
• Creating a Page Field Report
• Formatting a PivotTable Report
• Creating a PivotChart Report
• Publishing PivotTable Reports to the Web

Lab : Practice 6

After completing this module, students will be able to:

• Determine the source needed for its PivotTable
• Create the PivotTable
• Adding/removing Fields for the PivotTable
• Creating Page Field Report
• Creating a PivotChart Report

Publishing PivotTable Report to the Web