Course ELK91–149: Microsoft® Excel® for Office 365™: Data Analysis with PivotTables

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 course presents information and skills that are appropriate for users of Office 365™ applications.

Duration: 1 Day | Location : Online

Course Prerequisites:
To ensure your success in this course, you should have experience working with Excel and PivotTables. You shou... Show More

Request A Quote

Virtual Interactive Lecturer-led Teaching (VILT)

Virtual instruction environments are designed to simulate the traditional classroom or learning experience. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Course Content

Lesson 1: Preparing Data and Creating PivotTables

Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source

– See fewer details

Lesson 2: Analyzing Data by Using PivotTables

Topic A: Summarize PivotTable Data
Topic B: Organize PivotTable Data
Topic C: Filter PivotTable Data
Topic D: Format a PivotTable
Topic E: Refresh and Change PivotTable Data

+ See more details

Lesson 3: Working with PivotCharts

Topic A: Create a PivotChart
Topic B: Manipulate PivotChart Data
Topic C: Format a PivotChart