Excel+Hints

Data: Import data | Filter data | Goal Seek Formulae Charts: Pivot table

Need to: Create hint for goal seek

Pivot_Tables orange View, toolbars, pivot table Highlight data (if more than one column, must be side by side) Pivot table button, select wizard Step 1 select pivot chart Step 2 check correct data selected Step 3 new sheet Drag and drop field name onto x axis (untick blank box) Drag and drop field name onto chart Use the chart wizard to create title and label axes