Complete Guide to Excel Pivot Tables

Value fields perform the kinds of auto calculations that have made Excel ubiquitous. Learn how to customize value fields to perform different functions.

Now that you've learned how to access and edit MS Excel pivot table value settings, learn more about helpful calculations you can apply to a data set.

Learn how to add statistical calculation functions, including standard deviation and variance, to MS Excel pivot tables using the Value Field Settings menu.

This lesson from MyExcelOnline explains how to add value fields for running total and rank, as well as how to create an index and compare revenue and margins.

MS Excel percent calculations can shed a lot of light on a data set. Learn how to apply percent calculations to pivot tables with the Value Field Settings menu.