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.
- Recommended Recommended
- History & In Progress History
- Browse Library
- Most Popular Library
Get Personalized Recommendations
Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.Start Interview
You don't have any lessons in your history.
Just find something that looks interesting and start learning!