Work

# Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
• Playing
3 CQ
31. P&L Reports with Pivot Table Slicers
A lesson with MyExcelOnline

MS Excel pivot tables help businesses understand profit and loss metrics. In this lesson, learn how to use pivot table slicers for easy-to-read P&L reports.

MS Excel pivot tables help businesses understand profit and loss metrics. In this lesson, learn how to use pivot table slicers for easy-to-read P&L reports.

• Playing
3 CQ
32. Excel Forecasts with Pivot Table Slicers
A lesson with MyExcelOnline

Get the most out of Excel's forecast functions by using pivot tables and slicers to graph business forecasts for base, best-, and worst-case scenarios.

Get the most out of Excel's forecast functions by using pivot tables and slicers to graph business forecasts for base, best-, and worst-case scenarios.

• Playing
3 CQ
33. Adding Calculated Fields
A lesson with MyExcelOnline

Learn to add custom calculations to an Excel pivot table. There's no need to stick to the standard field values; edit pivot tables to fit your needs.

Learn to add custom calculations to an Excel pivot table. There's no need to stick to the standard field values; edit pivot tables to fit your needs.

• Playing
2 CQ
34. Leveraging Calculated Data Fields
A lesson with MyExcelOnline

Explore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.

Explore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.

• Playing
3 CQ
35. Creating a Calculated Item
A lesson with MyExcelOnline

A calculated item is a virtual data item based on a row or column label. MyExcelOnline demonstrates how to add calculated items to MS Excel pivot tables.

A calculated item is a virtual data item based on a row or column label. MyExcelOnline demonstrates how to add calculated items to MS Excel pivot tables.

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!

Comments
500 characters max