Analyze a data list using filtering and aggregation

1.Create a worksheet with a data list (you provide the data; obtain from work or from the Internet). 2.Create a set of PivotTables and PivotCharts to summarize/filter the data -- typically a minimum of three different questions should be analyzed; therefore at least three PivotTables showing different aspects of the analysis

3.Use slicers and conditional formatting features, if appropriate.

4.Use conditional aggregate functions to summarize/filter the data.

5.Use database functions to summarize/filter the data.

DOCUMENTATION

The documentation (explanation of your analysis) should include:

1. Description of the data.
2. Specification of the questions being investigated with a clear mapping between each question and the technique (PivotTable, PivotChart, conditional formatting, database function, logical aggregate function, etc) used to investigate.
3. Description of any insights gained from investigation of the data.