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.
Learn More
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.
Students also bought
Master Excel Pivot Tables - Excel 365 and Excel 2019
1.5 total hours
Updated 6/2016
Rating: 4.5 out of 5
4.5
27,691
Current priceRp279,000
Microsoft Excel - Data Analysis with Excel Pivot Tables
Bestseller
7 total hours
Updated 7/2023
Rating: 4.6 out of 5
4.6
218,529
Current priceRp1,299,000
Complete Introduction to Excel Pivot Tables [2023 Edition]
4 total hours
Updated 1/2023
Rating: 4.5 out of 5
4.5
6,063
Current priceRp429,000
Microsoft Excel Pivot Tables - Beginner to Advanced
4.5 total hours
Updated 1/2023
Rating: 4.7 out of 5
4.7
3,048
Current priceRp449,000
The Complete Excel Pivot Tables Course: Beginner to Advanced
15 total hours
Updated 3/2023
Rating: 4.6 out of 5
4.6
887
Current priceRp459,000
Pivot Tables, Power Pivot Tables, Power Query & Power BI
18.5 total hours
Updated 2/2021
Rating: 4.5 out of 5
4.5
32,623
Current priceRp429,000
Advanced PivotTables in Excel: Master the Pivot Table!
9.5 total hours
Updated 3/2023
Rating: 4.8 out of 5
4.8
1,116
Current priceRp499,000
Excel Pivot Tables in a Nutshell
31 total mins
Updated 5/2023
Rating: 4.4 out of 5
4.4
23,553
Current priceRp249,000
Excel Pivot Tables for Management Consultants & Analysts
Highest rated
2.5 total hours
Updated 3/2023
Rating: 4.5 out of 5
4.5
21,678
Current priceRp329,000
Excel Deep Dive: Pivot Tables Workshop
1.5 total hours
Updated 8/2019
Rating: 4.6 out of 5
4.6
15,563
Current priceRp329,000