Master Microsoft Excel 2023 Pivot Tables for Data Analysis.
Excel Pivot Tables: filters, calculated fields and items, grouping and subtotals, charts. Power Pivot. Full and in-depth
Ratings 4.47 / 5.00
What You Will Learn!
- Pivot Tables and Charts with Power Pivot for data analysis by crossing, grouping, summarizing, and filtering information. From the basics to the advanced.
- Power Pivot and KPIs (Key Performance Indicators) for following up "The Vital Few": strategic metrics for the achievement of a goal. A must for any management.
- Notions and concepts of tables, including their formal definition and the extra features it bring up. An important base for dominating Pivot Tables.
- Data Model and Relationships: Understanding the Relational Database system and applying it under Power Pivot, for creating Pivot Tables out of several tables.
- Several filtering data tools, create calculated fields and items, custom grouping and subtotals, amongst other matters for thorough and in-depth data analysis.
- Tools for dynamic Data Analysis for learning them quickly, smoothly, and thoroughly, going directly to the point without wasting time with side matters.
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 is an excellent tool for this purpose. A must to learn for any manager.
If your aim is to learn quickly, smoothly, and thoroughly Pivot Tables, going directly to the point, you have come 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 Pivot Tables 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
Defining as Formal Table
Removing Duplicates
Basic Features of a Formal Table
Automation Settings
Structured Referencing
Tables: Filtering Data
Filtering Data - Introduction
Text Filters
Number Filters
Date Filters
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 - Special 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 Pivot Table
Power Pivot - KPIs - Key Performance Indicators
Key Performance Indicators - Introduction
Creating KPIs Metrics
Applying KPIs in a Pivot Table
Who Should Attend!
- 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.
- Appropriate for Data Analysts and those needing to get Data Analytics.