Microsoft Excel

2 minute read

Excel Challenge # 10

Claudia Buckley

Claudia Buckley

How good are you at representing data visually? 

In this challenge, we’re looking at some numbers that come in from our website analytics software. 

Here’s what to do:

  • First, watch the challenge video and read the instructions below the video.
  • Review the previously published video(s) or article(s) suggested.
  • Download the Excel worksheet you will use to complete the challenge tasks.
  • Put yourself to the test!

Want to chat about your approach and process with other Excel heads? Join our Slack channel to share your insights and questions with like-minded learners.

The challenge

We need to generate two charts from each worksheet - one which shows the new and returning visits by country, and the other which shows the proportion, or percentage, of paid accounts by country. Your manager didn't tell you what type of charts to create - it’s your job to determine the best chart based on the type of data you will be representing.

You’ve decided that since you will need to do this process every three months, you should just create a macro to do it all in one click each time.

The charts should be on the same page as the data they represent, and they should be formatted with proper labels and titles.

Set up your macro, run it for each quarter and your job is done.

If you need clues or a refresher, watch our videos on how to make a graph and how to create a macro, and you’ll be ready to take on this challenge.

Download the file and let us know how you solved it!

Download your challenge data!

Start working on the Excel challenge with this data workbook.

The solution

We hope you'll enjoy taking part in this challenge!

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 enjoyed this challenge, try the Basic and Advanced Excel course to help you learn more essential formulas, functions, and practical, real-world Excel skills.

Level up your Excel skills

Become a certified Excel ninja with GoSkills bite-sized courses

Start free trial
Claudia Buckley

Claudia Buckley

Claudia is a content creator and business skills instructor at GoSkills. If she's not at work, she's probably tackling a genealogy project.