StationX
Start free

Browse › Excel Expert Productivity

Can You Create Advanced Charts and Tables?

Advanced

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 advanced charts and tables.

  1. Create a Box & Whisker chart that shows the distribution of sales figures for each product in each region
  2. Create a Box & Whisker chart and a Combo chart that shows the total sales figures for each product in each region
  3. Use a PivotTable to group the data by product and region
  4. Create a PivotChart that shows the total sales figures for each product in each region
  • ⏱ About 45 minutes