Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

# Excel 2016 - Data Analysis with Pivot Tables (EN)

Von Sonic Performance

The need to analyze data and gain actionable insight is greater than ever. You already have experience working with 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!

Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality 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.

## Inhalte

### Preparing Data and Creating Pivot Tables in Excel 2016 (EN)

 Course Overview: Data Analysis with Pivot Tables 01:20 Introduction to Preparing Data in Excel 2016 00:37 Preparing Data for Pivot Tables 05:35 Introduction to Creating a Pivot Table in Excel 2016 00:43 How to Create a Pivot Table from a Local Data Source 05:37 How to Create a Pivot Table from Multiple Local Data Sources 06:36 How to Create a Pivot Table from an External Data Source 06:41 Quiz zum Kurs „Preparing Data and Creating Pivot Tables in Excel 2016 (EN)“

### Analyzing Data by Using Pivot Tables in Ecxcel 2016 (EN)

 Introduction to Summarizing Data in Pivot Tables in Excel 00:39 Using a Pivot Table to Summarize Data 00:38 Introduction to Organizing Data in Pivot Tables in Excel 00:38 How to Use Pivot Tables to Organize Data 04:08 How to Use Pivot Tables to Filter Data 06:52 Introduction to Fomatting Pivot Tables 00:28 How to Format Pivot Tables 02:35 Updating a Pivot Table 00:22 How to Refresh and Change a Pivot Table 06:09 Quiz zum Kurs „Analyzing Data by Using Pivot Tables in Ecxcel 2016 (EN)“

### Working with Pivot Charts in Excel 2016 (EN)

 Introduction in Creating Pivot Charts in Excel 00:41 How to Create a Pivot Chart 03:53 Using the Pivot Table Field List to Manipulate Data 04:11 Formatting a Pivot Chart 04:58 Follow-Up: Data Analysis with Pivot Tables 01:14 Quiz zum Kurs „Working with Pivot Charts in Excel 2016 (EN)“

## Details

• Enthaltene Vorträge: 21
• Laufzeit: 1:04 h
• Enthaltene Quizfragen: 12
• Enthaltene Lernmaterialien: 3

## Dozenten des Kurses Excel 2016 - Data Analysis with Pivot Tables (EN)

### Sonic Performance

Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.

All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.

### Rezensionen

(1)
5,0 von 5 Sternen
 5 Sterne 5 4 Sterne 0 3 Sterne 0 2 Sterne 0 1  Stern 0