Excel challenges

2 minute read

Excel Challenge 13: Use Partial Match to Find Multiple Criteria

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 using Excel filters? 

If you’re not too confident in your skills, maybe some practice is just the thing you need. If you're a spreadsheet whiz, try timing yourself for an added challenge. 

Here’s what to do:

  • First, watch the challenge video and read the instructions below the video
  • Download the Excel worksheet you will use to complete the challenge tasks
  • Put your skills 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

Here’s the scenario to be solved from the download file:

An online video streaming service has its customer database saved on an Excel worksheet. They want to run a promotion to their customers who have a Basic-level subscription or those who have yahoo email addresses. Can you help them extract those records using Excel filters?

Check out the two videos below if you need a helping hand.

Download the file below to get started.

Download your challenge data!

Start working on the Excel challenge with this data workbook.

Team up and chat with other learners and pros on our Slack channel, and stay tuned for the solution. Have fun!

The solution

 


If you enjoyed this challenge, check out the GoSkills Excel Resource hub for more Excel challenges and blog pieces. Better yet, why not sharpen your Excel courses no matter what level you're at?

We recommend 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

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.