Work

# Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
• Playing
8 CQ
11. Excel Value Field Settings
A lesson with MyExcelOnline

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

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

• Playing
7 CQ
12. Excel Value Field Settings | Pt 2
A lesson with MyExcelOnline

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.

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.

• Playing
7 CQ
13. Excel Value Field Settings | Pt 3
A lesson with MyExcelOnline

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

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

• Playing
8 CQ
14. Excel Value Field Settings | Pt 4
A lesson with MyExcelOnline

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.

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.

• Playing
8 CQ
15. Excel Value Field Settings | Pt 5
A lesson with MyExcelOnline

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.

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.

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

You don't have any lessons in your history.
Just find something that looks interesting and start learning!