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

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)“
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 Ecxcel 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