Curriculum
- 1 Section
- 70 Lessons
- 52 Weeks
Expand all sectionsCollapse all sections
- Mastering Pivot Tables70
- 1.1Introduction
- 1.2Course Materials.
- 1.3Understanding Data Types
- 1.4Determining the Proper Date Entry
- 1.5Different Types of Datasets
- 1.6Categories of Databases
- 1.7Structures of Databases
- 1.8Normalising Databases – How to remove Duplicates
- 1.9Performing The VLOOKUP Formula to De-Normalise Databases
- 1.10Performing The VLOOKUP Approximate
- 1.11Performing The HLOOKUP
- 1.12The MATCH function
- 1.13The INDEX and MATCH function
- 1.14The XMATCH function
- 1.15The XLOOKUP function
- 1.16The IF function
- 1.17The AND function
- 1.18The OR function
- 1.19The Nested IF-AND-OR function
- 1.20Number Formating
- 1.21Deleting Named Ranges and Table Properties
- 1.22The Pivot Table Layout
- 1.23Getting Data ready for Analysis
- 1.24My First Report
- 1.25Two Dimensional Report
- 1.26Multi Dimensional Report
- 1.27Creating reports that involve COUNT, AVERAGE, MAX and MIN
- 1.28Formating your Report
- 1.29Turning your pivot table into a final report
- 1.30Applying Filters to your Report
- 1.31Performing Magic with the Filters
- 1.32Introduction to Slicers
- 1.33Formatting your Slicers
- 1.34Creating Reports From Recommended Pivot Tables
- 1.35Quick Analysis Tool Completed
- 1.36Positioning and Naming your Pivot Reports
- 1.37Creating your report next to your Data Source
- 1.38Relocating your pivot table report
- 1.39Changing your report’s Data source
- 1.40Managing changes in the Data Source
- 1.41Changing the Data Source
- 1.42Adding new Fields to the Data Source
- 1.43Eliminating Errors in my Dataset
- 1.44Dealing with Blank rows in the Dataset
- 1.45Introduction to Grouping
- 1.46Grouping Dates
- 1.47Grouping Dates into Weeks
- 1.48Grouping Numbers
- 1.49Grouping Text Fields
- 1.50Sorting the Pivot Table Report
- 1.51Controlling how the Pivot table summaries your values
- 1.52The Pivot table’s Special tabs
- 1.53The Compact Layout
- 1.54The Outline Layout
- 1.55The Tabular Layout
- 1.56Introducing the Dynamic Excel Table
- 1.57Filtering the Raw Data with Pivot table values
- 1.58Other filtering options
- 1.59Filtering with the Timeline
- 1.60Creating Top N reports
- 1.61Introduction to Calculated Fields
- 1.62How to Modify or Delete a Calculated Field
- 1.63Creating a report with Values in the Rows area
- 1.64Adding Calculated Columns in the Raw Data
- 1.65Introduction to Calculated Items
- 1.66Changing the calculation in a value field
- 1.67Working with Grand Totals for Columns and Rows
- 1.68Working with Sub-Totals
- 1.69Adding Gridlines to your report
- 1.70Show Value as Percentage of the Grand Total