Pivot Tables allow you to analyze raw data for business analysis purposes, but they are limited. Due to Excel’s own limitations, you cannot analyze more than 1,048,576 rows of data, and there may even be limitations in analyzing data from two or more spreadsheets. The Power Pivot Add-In allows you to import, merge, and analyze data from several sources simultaneously, with barely any limitations. Turn your raw data into a Pivot Table to help you gather business analytics. Create a Pivot Chart from your Pivot Table. Explore these amazing tools in Excel and make the most of your data.
Students must have Excel intermediate level skills, and need to know how to use formulas and functions in Excel.
Course Code: COMP G7478
Day/Time: Friday, 9am to 4pm
Instructor: Michael Montgomery