From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Delete transactions and insert a PivotTable

Delete transactions and insert a PivotTable - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Delete transactions and insert a PivotTable

“

- [Instructor] We would like a total of our reps sales by product line, and we're going to create a pivot table to do that for us, but the first thing is we've got a bunch of reps that have nothing to do with us there in our source data, and we need to just get rid of their transactions. We're concerned about Guy, Kate, Lennox and Sandra, but over in the source data, we've got Max, Roxanna, Sly, so your help is needed. First, get rid of the unneeded transactions. Then create a pivot table with sales and values, product line in columns, reps in rows, then sort the total sales descending. Alright. Pause the video. Pull up that exercise file. Create that pivot table. Then come back and we'll do it together. Alright, you're back. Let's do it. First of all. Put our data in the tables. I'm going to highlight here. Format as table. Pick that blue. Okay. Over here with my cursor in the data range. Format as…

Contents