MyExcelOnline demonstrates how to use the GetPivotData formula to improve the layout of a pivot table that displays actual vs. planned sales figures.
Channel analysis involves evaluating partners, often comparatively. Learn how to use GetPivotData formulas to create a channel partners analysis report.
In this lesson, MyExcelOnline explains the benefits of using macros, demonstrating different options for enabling macros or adjusting macro settings.
In this lesson, MyExcelOnline demonstrates each step of recording a macro, explaining different options for storing and sharing, and creates a macro button.
Make it easy to filter data by month, quarter, and year-to-date values. In this lesson, MyExcelOnline records three different macros to apply date filters.
- 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!