StationX
Start free

Browse › Excel Expert Productivity

Create and Modify Pivot Tables

Guided

Part of Excel Expert Productivity Topic: Essential IT

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this lab, you will create and modify PivotTables and slicers.

  1. Create a pivot table that uses all data
  2. Configure the pivot table to show a list of regions
  3. Add a new value to the pivot table design surface that shows what each region's sales percentage
  4. Add slicers to allow users to filter data by fields
  5. Create a pivot table from all data present
  6. Configure the pivot table to list salesperson name and the sum of sales for each salesperson
  7. Use a Group Field to group data by years