Microsoft Excel

2 minute read

Excel Challenge 10: Automating Repetitive Tasks With Macros

Claudia Buckley

Claudia Buckley

Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Download your challenge data!

Start working on the Excel challenge with this data workbook.


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. Or check out our Excel Macros and VBA course to start automating more of your Excel tasks.

Ready to become a certified Excel ninja?

Take GoSkills' Macros & VBA course today!

Start free trial

Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Claudia Buckley

Claudia Buckley

Claudia is a certified Microsoft Office Expert (Excel Specialist), project manager, and business skills instructor at GoSkills who has spent over 20 years in employee professional development. Claudia has a Masters Degree in Business Administration and a Diploma in Educational Psychology. In her spare time, she listens to audiobooks and is an amateur genealogist. View her profile here.