MyExcelOnline records macros to generate views for region by quarter, year-to-date sales by month, and top ten channels, creating buttons for each macro.
Find out how to use Excel macros to easily identify your best customers! In this lesson, MyExcelOnline demonstrates how to create a macro for a top 10 filter.
Get data management tips that will help you conserve memory when working with large MS Excel files. Find out about four ways to reduce Excel workbook file size.
You've learned how to create pivot tables the hard way, and skills are sharper for it! Now learn how to use the Excel Pivot Table Wizard to consolidate data.
Learn how to use pivot tables to create a frequency distribution, and insert a chart to visually display the frequency of sales according to sales person.
- 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!