Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Intermediate Excel!
You have completed Intermediate Excel!
Preview
Finishing the Pivot Table
2:43 with Tyler TallonNow let's try building our pivot table by dragging fields into the four pivot table boxes.
Downloads
Please note that this is a new spreadsheet, different from the one you used in the previous stage:
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
in which fields are added in each box will
affect how it displays in the pivot table.
0:00
It's usually best to start with
the broadest category followed
0:03
by logical subsets.
0:06
Let's practice navigating
the pivot table here a bit.
0:08
Let's move State down to Rows,
we can just click on it, and then drag and
0:11
release once you are in
the box you want to go in.
0:15
Then let's place city in the rows
box also, right after state.
0:18
Now let's say we want to look
at sales dollars by quarter,
0:25
let's drag quarter to the columns box.
0:29
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up