2 minute read

Excel Challenge #1

Alan Murray

Welcome to Excel challenge #1!

This week's challenge is designed to test your knowledge on the formulas and chart content from the GoSkills Excel - Basic course.

Everything you need to participate in the challenge can be found on this page. To take part:

Watch the challenge video
Read the instructions below the video
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 new Slack channel to share your insights and queries with like-minded learners.

Excel Challenge #1

Download your challenge data

Start working on the Excel challenge with this data worksheet

We have the following sales data:

The first task is to write a formula in column C that extracts the region code from the ‘Ref’ column.

The region code is the three digits in the middle of the reference.

The solution needs to be dynamic, so that formulas automatically work on new rows that are added to the sales data.

With this task complete, we then need to do some sales analysis.

We need to return the total sales for each region, and also calculate how many sales met or exceeded the target value of 2,500.

Then, create a clean and easy to understand column chart of the sales by region data.

You can make any changes that you feel necessary for the chart.

total-sales-chart Some test data is provided in range I6:L8 so that you can check that your solution automatically updates by adding this data to the sales data.

Download your challenge data

Start working on the Excel challenge with this data worksheet

The Solution

We hope you enjoyed taking part in this challenge! Stay tuned to the GoSkills Excel Resource hub for more Excel challenges, and check out our range of Excel courses to further sharpen your skills.

Level up your Excel skills

Become a certified Excel ninja with GoSkills bite-sized courses

Start free trial

Alan Murray

Alan is a Microsoft Excel MVP, Excel trainer and consultant. Most days he can be found in a classroom spreading his love and knowledge of Excel. When not in a classroom he is writing and teaching online through blogs, YouTube and podcasts. Alan lives in the UK, is a father of two and a keen runner.

8 comments

Rayanna

that was epic
Alan Murray

Well done everybody on finding solutions to the challenge.
Funsho

This is fantastic. Expecting another challenge.
Tavia

Hello, it's Tavia. I enjoyed solving the challenge. I learnt new functions. 💕
LISBETH

Hi, I've completed the challenge :-)
Davidprince

DONE
David

Solved (under 15 min)
GoSkills User

Solved 😁!