1. Software & Programmieren

Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Excel 2016: Data Analysis with Pivot Tables (EN)

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)

lecture locked Course Overview: Data Analysis with Pivot Tables 		01:20
lecture locked Introduction to Preparing Data in Excel 2016 		00:37
lecture locked Preparing Data for Pivot Tables 		05:35
lecture locked Introduction to Creating a Pivot Table in Excel 2016 		00:43
lecture locked How to Create a Pivot Table from a Local Data Source 		05:37
lecture locked How to Create a Pivot Table from Multiple Local Data Sources 		06:36
lecture locked 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 Excel 2016 (EN)

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

Working with Pivot Charts in Excel 2016 (EN)

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

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

© 2025 Lecturio GmbH. Alle Rechte vorbehalten.

Betreuung durch Dozenten
Auch unterwegs auf Tablet und Smartphone lernen
100% Geld-zurück-Garantie