Module 3 : Introduction to Filtering, Pivot Tables, and Charts

This module introduces various data filtering capabilities of Excel. You’ll learn how to set filters in data to selectively access data. A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel.

 

Topics covered include:

  • VLOOKUP across worksheets
  • Data filtering in Excel
  • Use of Pivot tables with categorical as well as numerical data
  • Introduction to the charting capability of Excel

Module 2 : Spreadsheet Functions to Organize Data

Module 4 : Advanced Graphing and Charting

Leave a comment

Your email address will not be published. Required fields are marked *