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: PivotTables in Excel

Solution: PivotTables in Excel - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Solution: PivotTables in Excel

“

- [Instructor] Let's create these pivot tables. There are several ways that we can start. Let me do this. First of all, I'm going to be good in my habits and create a copy. Okay. And then I'm going to move this over in case I do mess something up and then make that red. Now, this is what I'm going to work with. And here, now we get started. Insert. Now I'm going to do plumbing, paint, and then, I'm giving flash fill enough information so that it can help me. Let me scroll, grab this. Okay, let's see if it's going to work. Go to Data, flash fill. All right, gutters and roofs. HVAC without the code, Electrical without the code. All right, beautiful. Also, here, I don't need these. I don't need that date or that empty row. Delete that. So now it's going to be much easier for me to have flash fill help me. Flash fill. All right. Right, HVAC. Always check our work. Okay, now, I don't need this. Just task, not task in code. I want to put this data into a table. Go Home, Format as Table. I…

Contents