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.
