At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

Here's an example for a generic home-improvement project. First, calculate the percentage over budget for the total budget to get an understanding of the overall project.

Microsoft Excel enables you to quickly find the percentage of two cells by using a formula and changing the cell format. This is especially useful if you have a spreadsheet full of sales data and ...