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.

Solution: Multiple datasets in Excel

Solution: 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

Solution: Multiple datasets in Excel

“

(bright upbeat music) - [Instructor] Let's glide on in. First of all, we do have to check these headers. I'm going to highlight the headers here, copy, and then put 'em here. Paste so that I can see. Venue, Venue, fine. Month, Revenue. Okay, Revenue is over here. I don't have to fix that. They don't have to be in order for Append, they just have to be the same name, which Total Events and Events are not consistent. Cancellations is fine. I am going to go back over here and call this just Events. With my cursor in the dataset, I have to start making my queries. Right-click, Get Data From Table/Range, table has headers. Okay. I'm going to go ahead and do my Fill, Down right now. Fill, Down. Then, I have to clear totals and I have to be careful. I can clear the nulls in the Month and Events. I can't clear nulls over in Cancellations. So, let's go to Events and then clear the nulls, 'cause those were the total rows that we don't need, and then Close & Load. Here we go, and I'm going to…

Contents