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