Excel - Pivot Tables - Part Two

Printer-friendly versionPrinter-friendly versionEmailEmail

Crash course on Pivot Tables - Part Two

We've split this lesson into two parts: Part One will cover how to quickly create a pivot table while Part Two goes into a bit more detail. You should probably watch Part One first.

Unable to display content. Adobe Flash is required.

Transcript
Welcome back to T4T’s crash course in Pivot Tables. If you haven’t watched Part One of our Pivot Table topic, I’d highly recommend that you pause this clip and head back to watch Part One first.

Ok, when we last left off, we had just created a very basic pivot table that summarizes voter information. Just to remind you where we’re at, we had 4,000 voter registration records and we put them into a pivot table to summarize voter counts by precinct.

We first inserted a pivot table then dragged ‘Precinct’ down to Row Labels and ‘Voter’ down into the value box and changed it from a SUM to a ‘COUNT of Voter’ records.

You’re caught up! Let’s head over to scenario #2 where we want to make sure there are enough ballots printed by precinct by party affiliation. In our pivot table, we already have precinct and voter count, so we just need to add ‘Party’ to the pivot table. This is where the trial and error comes into play, so let’s try dragging ‘Party’ into the Row Labels with ‘Precinct’ to see what happens. You can see that our pivot table automatically updated and it looks like useful information.

Once again, the trial and error is a nice feature. For example, I could drag ‘Party’ above ‘Precinct’ to get a little different view that is just as useful. Very easy to drag and drop the information.

Onto our third scenario: We need to make sure we have enough ballots to bring to the polls. So which voters are registered with the POLL designation?
Back to our pivot table, to keep it simple I’ll remove ‘Party’ from our pivot table. In this case, I’ll grab ‘Ballot Status’ and drag that down to Row Labels. And very quickly, we can see how many people to expect actually showing up at the poll on Election Day.

To get more detailed, we can re-add ‘Party’ to the pivot table to see what happens. Don’t be afraid to experiment!

Well thank you for watching T4T’s tip #28 where we covered a little bit about Pivot Tables. We’ll see you next time.

Excel - Pivot Tables - Part Two | Teaming for Technology

Spot on with this write-up, I really assume this website needs rather more consideration. I

Teaming for Technology Colorado | Building better communities

This site is known as a stroll-by way of for all the information you needed about this and didn

Teaming for Technology Colorado | Building better communities

I

Teaming for Technology Colorado | Building better communities

This is the right blog for anyone who needs to find out about
this topic. You notice a lot its virtually onerous to argue with you (not
that I actually would want

Teaming for Technology Colorado | Building better communities

It

Teaming for Technology Colorado | Building better communities

Hey, you used to write fantastic, but the last few posts have been kinda
boring

Teaming for Technology Colorado | Building better communities

Aw, this was a very nice post. In idea I wish to put in writing like this moreover

Teaming for Technology Colorado | Building better communities

Good

Teaming for Technology Colorado | Building better communities

F*ckin

Teaming for Technology Colorado | Building better communities

I

Teaming for Technology Colorado | Building better communities

I found your blog website on google and check a few of your early posts.

Continue to maintain up the superb operate. I just extra up your RSS feed to
my MSN News Reader. Looking for ahead to studying more from you in a while!

Teaming for Technology Colorado | Building better communities

Hello, i think that i noticed you visited my website thus i got here
to

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <h2> <h3> <h4> <h5> <h6> <em> <strong> <small> <big> <code> <blockquote> <q> <sub> <p> <br> <hr> <ul> <ol> <li> <dl> <dt> <dd> <a> <b> <u> <i> <sup> <img> <table> <tbody> <td> <th> <tr> <dt> <dl> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options