Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts

We have another great Excel challenge lined up for you! This time we’ll be summarizing a large data table by selected categories. That summary will be in the form of an interactive chart that allows us to group or expand categories at will.

Here’s what to do:

1. Watch the challenge video 
2. Download the Excel worksheet 
3. Complete the challenge tasks

Want to discuss, ask for help, or share your solution? Join our Slack channel to share your insights and questions with other learners and experts.

The challenge

Here’s the scenario: 

This list of customers has too much detail for the General Manager. He’s more interested in an overview. He wants to be able to view how many customers we have in each country, broken down by basic, standard, and premium subscriptions. 

Tasks🏋️

You’re the Excel expert in the office, so he wants you to do the following:

1. Create an interactive chart that summarizes this data.
2. The chart should enable the manager to see whatever country or level he is interested in at that moment.
3. He would prefer to see Basic, Standard, and Premium, in that order, if you can manage it.

So, can you? You can use this GoSkills video as a starting point for your solution:

• Read our blog article - How to Create a Pivot Table in 5 Easy Steps

We have lots more free pivot table resources available. Go to GoSkills.com, search for anything you like, and brag about your solution on our Slack channel. Then tune in next week for our solution. Download the file to get started.

We hope you'll enjoy working on this challenge!

The Solution

Stay tuned to the GoSkills Excel Resource hub for more Excel challenges, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.

If you like our challenges, you’ll love our Basic and Advanced Excel course which will help you learn more essential formulas, functions, and practical, real-world Excel skills. Or maybe you’re ready to take your Pivot Table skills to the next level. Take our Microsoft Excel - Pivot Tables specialty course and learn how to analyze large pieces of data like a pro!