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.
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.
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.
Explore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.
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.
- 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!