Dominate Microsoft Excel Pivot Tables for data analysis

Tables, Pivot Tables, filtering data, calculated fields and items, grouping and subtotals, Pivot Charts and Power Pivot.

What you'll learn
Pivot Tables and Pivot Charts for data analysis by crossing information, grouping and various types of filtering.
Power Pivot and KPIs (Key Performance Indicators) for following up strategic metrics for the achievement of a goal, the so called "The Vital few"..
Notions and concepts of tables, including it's formal definition and the advantages of this feature.
Data Model and Relationships which implies to understand Relational Database notions and how to apply this concept under Power Pivot.
Requirements
To be an user of Excel, at least familiar with the basic operations.
Description
All organizations need to analyze data on their activity to find out trends, strengths, weaknesses, and other aspects to understand the waters they sail on, and Pivot Tables it’s an excellent tool for this purpose. A must to learn for any manager.
If your aim is to learn quickly, smoothly, and thoroughly this tool, going directly to the point, you came to the right place.
Based on more than 25 years of experience as an Excel trainer and business manager, this course reflects this wide and versatile knowledge, delivered to you in a tray with juicy content.
You’ll acquire proficiency in Excel by dominating matters such as notions about tables and the advantages of their formal definition, creation, and reconfiguration of Pivot Tables, diverse types of filtering data, defining calculated fields and items, grouping data and subtotals, Pivot Charts and Power Pivot, amongst others.
Course content:
Tables: - Notions and Concepts
Introduction to Tables
Formal Definition of a Table
Removing Duplicates
Basic Features of a Formal Table
Automation Settings
Structured Referencing
Pivot Tables - Creation and Reconfiguration
Introduction to Pivot Tables
Creating a Pivot Table
Filter Field
Reconfiguring a Pivot Table
Totals and Grand Totals
Layout and Styles
Pivot Tables - Fields Settings and Calculations
Values Fields Settings
Item Fields Settings
Creating Calculated Fields
Creating Calculated Items
Pivot Tables - Grouping
Date Grouping
General Grouping
Columns Grouping
Pivot Tables - Filters
Slicer Filter
Timeline Filter
Pivot Charts
Inserting a Pivot Chart
General Tasks with Pivot Charts
Power Pivot - Installation and Introduction
Power Pivot - Add-In Installation
Power Pivot - Database Notions - Introduction
Power Pivot - Database Notions - Relational Database
Power Pivot - Definining Lists as Tables
Power Pivot - Data Model and Pivot Tables
Adding Tables to the Data Model
Creating Relationships
Creating a Pivot Table of a Data Model
Power Pivot - Calculated Fields
Calculated Fields - Introduction
Creating Calculated Fields
Calculated Fields - Using in a Pivot Table
Power Pivot - KPIs - Key Performance Indicators
Key Performance Indicators - Introduction
Creating KPIs Metrics
Applying KPIs in a Pivot Table
Who this course is for:
Those needing to do data analysis in-depth with Pivot Tables and want to go directly to the point without wasting their time with side matters.

More Info