by Nate Moore | Oct 24, 2012 | Pivot Tables
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...
by Nate Moore | Oct 22, 2012 | Pivot Tables
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...
by Nate Moore | Oct 17, 2012 | Pivot Tables
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...
by Nate Moore | Oct 15, 2012 | Pivot Tables
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...
by Nate Moore | Oct 10, 2012 | Pivot Tables
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...
by Nate Moore | Oct 8, 2012 | Pivot Tables
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...
