Calculating percentages in Excel often means wrestling with absolute cell references and division symbols. But why do the work when a built-in tool can do it for you? By using the PivotTable Show Values As option, you can calculate complex ratios in seconds without typing a single formula.