From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Challenge: Multiple datasets in Excel

Challenge: Multiple datasets in Excel - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Challenge: Multiple datasets in Excel

“

(upbeat music) - [Narrator] Now the challenge for the chapter on working with multiple data sets. We have this venue data for The Pelican, months, revenue cancellations, total of events. We have some totals in here. Let's look at Seven Winds, much different, same data, different format, different information, all venues. Here's the contact information. Let's go back. The challenge. Use Power Query to append these two data sets, The Pelican and the Seven Winds. And remember to check for consistency in the headers because append won't work in certain situations. Once you have it stacked up, clear the totals out, and then use fill down to ensure that the correct venue is in each row. And that will allow us to distinguish between January's revenue for The Pelican and January's revenue for Seven Winds. And then sort by the revenue. You can choose ascending or descending. And then once you have this data back out into Excel, use XLOOKUP to retrieve the phone number and contact on each row…

Contents