This module introduces various data filtering capabilities of Excel. It helps to learn how to set filters in data to access data selectively. A compelling data summarizing tool is the Pivot Table. Topics covered include:

• Create a Pivot Table
• Data requirement for the Pivot Table
• Removing empty rows or blank rows
• Formatting column header and putting data into a table.
• Data filtering, sorting, and slicing
• Creating Pivot Charts

**Workshop will take place in LAC101B