This comprehensive 6-hour course will teach you how to summarize data using these powerful Excel tools, enabling you to create summary reports and charts. With Power Query and Power Pivot, you'll learn to import data from multiple sources, manipulate it, and then review the consolidated data in a pivot table using multiple tables.

This class is a perfect for those who having been using Excel for years but don't know how to use these advanced features for data visualization and analysis.