From the course: Excel PivotTable Quick Tips
Join today to access over 25,300 courses taught by industry experts.
Create a basic Excel PivotTable - Microsoft Excel Tutorial
From the course: Excel PivotTable Quick Tips
Create a basic Excel PivotTable
- [Narrator] Let's create a basic PivotTable. I want to find out how many were sold in each category here in column G. I have my line item transactions and each one has a quantity sold. Click anywhere in your dataset. Change to the insert ribbon tab and click PivotTable here on the left. Excel will automatically select the data range for you. Click OK and you now have a new sheet. Your original dataset is still intact here in this order sheet. That's never going to change. Now you can just start dragging the fields to the areas below to create your PivotTable. I'll drag ProdCategory to the rows area. Instantly my categories appear in the sheet. I'll drag Quantity to the values area. Now I can very easily see how many of each category I've sold.
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.