Microsoft Excel: Data Analysis with PivotTables

About this course

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. This material will benefit users of any current Office version. The course environment setup is based on Excel for Office 365. Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables. In this course, you will: prepare data for PivotTable reporting and create PivotTables from various data sources, analyze data by using PivotTables, and work with PivotCharts. This course requires that you have Microsoft Excel installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.