Sheets AcademySheets Academy
Premium
Task #75

Sales report from the CRM

Your manager needs a report on how much each sales rep sold, with a chart to compare them. The names in the CRM are written every which way, so a PivotTable built on them falls apart.

  1. Bring the names in E2:E121 to one format: no extra spaces and starting with a capital letter, for example “Anna”.
  2. Build a PivotTable on the clean names.
  3. Add a chart based on it to compare the reps.
Task #75
Sales report from the CRM

Your manager needs a report on how much each sales rep sold, with a chart to compare them. The names in the CRM are written every which way, so a PivotTable built on them falls apart.

  1. Bring the names in E2:E121 to one format: no extra spaces and starting with a capital letter, for example “Anna”.
  2. Build a PivotTable on the clean names.
  3. Add a chart based on it to compare the reps.