In the Word file you will find a summary of the activity with conclussions drawn from the data analysis and charts created in Excel.
In the Excel file you will find 6 sheets:
- Data: Conditional formatting, Date conversion, Excel Formulas
- Category Pivot: Power Pivot and Pivot charts
- Sub-Category Pivot: Power Pivot and Pivot charts
- Dates Pivot: Power Pivot and Pivot charts
- Bonus: Nested formulas and conditionals
- Bonus Statistical Analysis