Select Page

Excel Video 306 Running Totals

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 304 Difference From a Baseline

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 Percentage of a Baseline

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 Show Values As Shortcuts

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...