Excel Dashboard using Pivot Tables/Charts

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.