From the course: Excel: Mastering Pivot Table Dashboards and Reports
Join today to access over 24,600 courses taught by industry experts.
Averaging with a PivotTable - Microsoft Excel Tutorial
From the course: Excel: Mastering Pivot Table Dashboards and Reports
Averaging with a PivotTable
(gentle music) - Okay, so let's talk about how to do average. We're going to do this one, this pivot table here, on average. Right now we're on that worksheet. Slightly more difficulty, right? So what do we need to do here? We have the region on the left side. We have items across, and then we have the average on the inside. So I'm going to put my cursor right here. I'm going to go to Insert Pivot Table. Over where it says Table range, I'm just going to type in Orders, like that. I'll put it on this existing worksheet right here. I'll go ahead and hit OK. And then, if I want to see the region on the left side, I'll take Region and drop that right here. That looks good. I want to see Item across the top. I'll take Item and drop it right there. Now, let's see here. I want to do the average right here. So I'm going to put Total in here. But note that the total is not the average yet, right? It's the sum of the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.