Overview

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 ConceptsIntroduction to TablesDefining as Formal TableRemoving DuplicatesBasic Features of a Formal TableAutomation SettingsStructured ReferencingTables: Filtering DataFiltering Data - IntroductionText FiltersNumber FiltersDate FiltersPivot Tables - Creation and ReconfigurationIntroduction to Pivot TablesCreating a Pivot TableFilter FieldReconfiguring a Pivot TableTotals and Grand TotalsLayout and StylesPivot Tables - Fields Settings and CalculationsValues Fields SettingsItem Fields SettingsCreating Calculated FieldsCreating Calculated ItemsPivot Tables - GroupingDate GroupingGeneral GroupingColumns GroupingPivot Tables - Special FiltersSlicer FilterTimeline FilterPivot ChartsInserting a Pivot ChartGeneral Tasks with Pivot ChartsPower Pivot - Installation and IntroductionPower Pivot - Add-In InstallationPower Pivot - Database Notions - IntroductionPower Pivot - Database Notions - Relational DatabasePower Pivot - Definining Lists as TablesPower Pivot - Data Model and Pivot TablesAdding Tables to the Data ModelCreating RelationshipsCreating a Pivot Table of a Data ModelPower Pivot - Calculated FieldsCalculated Fields - IntroductionCreating Calculated FieldsCalculated Fields - Using in Pivot TablePower Pivot - KPIs - Key Performance IndicatorsKey Performance Indicators - IntroductionCreating KPIs MetricsApplying KPIs in a Pivot Table

Skills

Reviews