Learn the basic parts of a PivotTable in Excel: value fields, row fields, column fields, and filters.
- [Narrator] Earlier we talked about how a basic function…of a pivot table is that it totals or counts things up…like sales and then breaks that total down by a condition.…For example, I have 04,03 unpacking pivot tables open…in the chapter four folder and my total is sales…and then it's being broken down by city.…But what are the parts of a pivot table called?…This doesn't look like you're typical spreadsheet here.…Well, this area here is a value field…and this area here, these cities,…this is known as a row field.…
The row field provides the condition…in which we can break down the total.…And you can see what's driving these two things…if you click inside the pivot table…and then you'll see the pivot table fields list up here…and if you don't see it appear you can always right click…and choose show field list, in this case it's up…and I can see it just fine.…So how are these two things represented in this field list?…Well here is your total: sum of sales…and here is the condition: the city.…So the total is being broken by city…
- Using, modifying, and sharing templates
- Importing data from a database
- Cleaning up data
- Refreshing queries
- Pasting data
- Sorting and filtering tables
- Using slicers
- Adding a dynamic commission calculation
- Using conditional formatting
- Working with PivotTables and PivotCharts
- Creating a leaderboard
- Create period, monthly, and yearly summaries
- Creating dashboards
Skill Level Intermediate
1. Getting Started with Templates
2. Importing Sales Data
3. Working with Tables
4. Analyzing Sales Data
5. Build Awesome Sales Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.