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
Other Pivot Table Tips and Tricks
2:52 with Tyler TallonNow that we’ve learned the basics for building and navigating a pivot table let’s look at a few more tips and tricks.
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
Earlier we had mentioned that it was a
best practice to set up your data as table
0:00
before you create the pivot table,
in case you need that add a row or column.
0:01
Let's try that.
0:05
Say we open a new store in June and
need to add that to the data.
0:06
We can insert a line here
right below Houston Texas and
0:10
fill in cells for
a new store in Abilene Texas.
0:14
And let's say we know that we
sold 1,000 units for $4,000.
0:21
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