Module 5: Spreadsheet Analysis | Data Analysis using Pivot Table, Filters and What If Analysis

• Module 1: Spreadsheet Analysis | Starting up with MS Excel
• Module 2: Spreadsheet Analysis | Function Referencing
• Module 3: Spreadsheet Analysis | Graphs and Validation Techniques
• Module 4: Spreadsheet Analysis | Lookup Functions
• Module 5: Spreadsheet Analysis | Data Analysis using Pivot Table, Filters and What If Analysis

These Slides cover:
Data Analysis using Pivot Tables: Using the Pivot Table Wizard, Changing the pivot table
layout, Formatting, Grouping items, Inserting calculated fields, Pivot Table Options, Display
and hide data in fields, Lay out reports directly on worksheet, Pivot Chart, Using Slicer in
pivot Tables, Applying and Using AutoFilter, Creating a Custom AutoFilter, Sorting On More
Than One Column, Using Advanced Filter, Using Formulas In Criteria. What If Analysis.
Scenario Manager, Goal Seek, Solver.

NEXT