Excel Dashboard using Pivot Tables/Charts
![image](http://datawithchristos.co.uk/wp-content/uploads/2022/04/excelpivottables.png)
Description of Project
Step 1: Add Filters to Headers
Step 2: Remove duplicates
Step 3: Replace text ‘M’ with ‘Married’ and S with ‘Single’ in Marital status column, and M/F for male/female in gender column
Step 4: Add age bracket column, using a nested IF statement. Breaking the ages down into buckets
Step 5: Create pivot tables + corresponding charts
Step 6: Dashboard creation with slicers + visual edits. Connecting slicers to all pivot tables for consistency throughout.