From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

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

Preparing and connecting a PivotTable to your data

Preparing and connecting a PivotTable to your data - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial Buy for my team

Preparing and connecting a PivotTable to your data

“

- [Instructor] Pivot tables can be a powerful feature to have in any data tracker. Now, when I've taught workshops around pivot tables, students didn't have a challenge with the actual steps of creating a pivot table. What I noticed was a lot of times, their real world data was not ready to go into the pivot table. And that's what we're going to talk about now. Now let's look at this data. We've got transaction date, reps, account data, product line, sales amounts. We've got subtotals like the one in sale I-17. We've got an empty row. Okay, scroll down. We've got another section here. We've got tools and accessories. We've got a lighting section, more subtotals. Now this data at row 95, don't look at that yet. That's for later. Okay, let's get refocused back up top. So let's scroll to the top. Now, what happens if I do create a pivot table right now? My cursor is inside the data set. I'm going to go to Insert and…

Contents