Microsoft Excel for Office 365 - Data Analysis with PivotTables (v1.1)
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.
Description
In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data. You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze data by using PivotTables. Work with PivotCharts.
Prerequisites
To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following courses: Microsoft Excel for Office 365 (Desktop or Online): Part 1 Microsoft Excel for Office 365 (Desktop or Online): Part 2