From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Midterm challenge: Get a count of all colors

Midterm challenge: Get a count of all colors - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial Buy for my team

Midterm challenge: Get a count of all colors

“

We have learned a lot up to this point and so now it's time to take a challenge that will combine various skills and Power Query features. Everything you've learned so far is fair game. So are you hydrated? Are you ready for a challenge? I hope so because here it goes. Here is your midterm challenge. A chance to put your skills together in a real-world scenario. Let's look at the data before we go through the challenge details. We've got Inventory 1. Ah. Does this look familiar? Okay. We've got the colors, the sizes, and the counts. We've got store and Warehouse 1. And then over here, we have Inventory 2 coming from Warehouse 2. Here we see we have fourteen 12-ounce indigos. Three 8-ounce mustard yellows. Let's go to the challenge. Use Power Query to get a count of all of the colors by size. That means we'd like to be able to see between those three data sources. How many 8-ounce cyans do we have? How many 3.5 ounce indigos? And we do not need any other data, just the colors and a…

Contents