Skip to content

Email Newsletter Challenge 11

This week’s challenge will test your data cleaning skills. Get your broom out and get ready to go! Think you’re up to the challenge?

Download the spreadsheet challenge using the links below.

The Challenge

This time, you’re given some raw data and asked to perform a series of steps to clean the data.

  1. Place the different pieces of data into the correct field
  2. Format the phone numbers
  3. Change the email structure

Just take things one step at a time.

The Solution

Instead of writing a long drawn-out article this week, I decided to put together a short video that demonstrates the full solution instead.

The first part of the video shows the solution for Google Sheets, and the second half demonstrates the solution for Excel. Check it out below.

Thanks for challenging yourself this week, and I hope you had fun and learned something new.

And if you’re not signed up for my weekly email newsletter, you can sign up right here!

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top