Excel Video 314 has a couple more things you should know about calculations in Pivot Tables. The most important trick is to find an existing calculation when you go to the Insert Calculated Field window. Once you’re okay there, I have a way to show all of the Pivot...

Excel Video 313 Calculated Fields in Pivot Tables Part 1 Here’s a third way to make calculations with Pivot Table Data Excel Video 313 introduces a third way to make calculations with Pivot Table data. Calculated fields take a little longer to set up, but if you’re...

Excel Video 312 covers a few more things to know about GETPIVOTDATA. We’ll start where we left off in Excel Video 311 by adding even more fields to our Pivot Table. Once you understand the structure of the GETPIVOTDATA formula, adding more fields to the Pivot Table is...

Now that we’re a little more familiar with GETPIVOTDATA, let’s see what else it can do for us in Excel Video 311. We’ll take what we learned in the last Excel Video and apply it to the original formula we had trouble copying a videos ago. Notice how easy it is to copy...

Excel Video 310 is the first step in our effort to demystify GETPIVOTDATA. As you’ll remember from our last Excel Video, Excel automatically creates a GETPIVOTDATA formula for you when you click to create a formula referencing a cell from a Pivot Table. Last time I...

Excel Video 309 transitions to a different way to do calculations with Pivot Table data. We’ll start with a little housekeeping to get the data the way we’d like it, and then the first thing I want to show you is that you can put multiple fields in the Values area of...

Excel Video 308 gives us one more way to show values in a Pivot Table. Truth be told, we didn’t necessarily save the best for last, but we did save the most complicated calculation for last. Microsoft uses the index calculation we’ll discuss today to describe the...

If you’d like to see how components of your Pivot Table change over time, try ranking the values in Excel Video 307. Excel will let you rank from lowest to highest or from highest to lowest based on whatever baseline value you choose in your Pivot Table. You’ll see in...

If you’d like to add running totals to a Pivot Table, watch Excel Video 306. It’s easy to add running totals to your Pivot Table, either as a number or as a percent. It’s also easy to sort to see the biggest or the smallest component of those running totals. If you’d...

Excel Video 305 shows you another way to look at percentage differences in a Pivot Table. If you watched Excel Video 303, we calculated percentage differences from a baseline and found payers that were 96% of Medicare or 105% of Medicare. If you’d rather show those...

Would you like to show the actual distance from a baseline instead of a percentage distance in your Pivot Table? Watch Excel Video 304. Today we’ll show the actual dollar difference in billed charges instead of the percentage difference. We’ll also show both the total...

Excel Video 303 introduces another way to calculate percentages in a Pivot Table. Today we’ll select a baseline amount for Excel to calculate percentages of in a Pivot Table. We’ll start by using Medicare as a baseline and comparing the other payers’ charges as a...

Excel Video 302 has two shortcuts to make the percentage calculations we’ve been discussing easier to choose. Watch how in Excel 2010 there is a new Calculations menu and a new way to right-click a value in a Pivot Table to get faster, easier access to the Show Values...

Excel Video 301 is very similar to Excel Video 300, using parent columns instead of rows. It can be a little confusing to understand how Excel is doing these parent calculations, so I did one more video calculating the percentage of the parent column total instead of...

As we hit the milestone of Excel Video 300, I’ll pause for a minute to say thanks for watching. I realize quite a few of you have watched all 300 videos. Thanks for watching and for spreading the word about these Excel Videos. The percentages we discussed last time...

Excel Video 299 introduces a powerful way to look at trends over time by using percentages in your Pivot Table. Instead of putting numbers in the values area of the Pivot Table, today we’ll replace the numbers with percentages to see how the mix of clinic locations...

In Excel Video 298 we’re ready to start talking about calculations in a Pivot Table. Today we’re primarily working with the Values area in the Pivot Table. You can drag multiple fields to the Values area and you can even drag the same field to the Values more than...

When you see how easy it is to expand and contract groups in Excel Video 297, you’ll wish it was this easy to contract your waistline! Today we’ll go through three ways to make your grouped items expand (show detailed data) or contract (show summary data). You can...

If you liked the ability to group text in the last Excel Video, you’ll like the additional grouping options we’ll discuss today in Excel Video 296. The first trick we’ll discuss is how to group groups. You can create levels of grouping to get exactly the analysis...

Now that you’re familiar with grouping dates, watch Excel Video 295 to see how to group text in a Pivot Table. When we grouped dates in Excel Video 294, we grouped by month and year so Excel knew the names of the months and called the new field “Years” for us. When we...