Curriculum
- 1 Section
- 94 Lessons
- 52 Weeks
Expand all sectionsCollapse all sections
- Mastering Pivot Tables94
- 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.13INDEX 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.57Creating a Pivot Table from a Dynamic Table instead of a Range of cells
- 1.58Filtering the Raw Data with Pivot table values
- 1.59Other filtering options
- 1.60Filtering with the Timeline
- 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.65Creating Top N reports
- 1.66Introduction to Calculated Items
- 1.67Changing the calculation in a value field
- 1.68Working with Grand Totals for Columns and Rows
- 1.69Working with Sub-Totals
- 1.70Adding Gridlines to your report
- 1.71Show Value as Percentage of the Grand Total
- 1.72Show Value as Percentage of the Column Total
- 1.73Show Value as Percentage of the Row Total
- 1.74Show Value as Percentage of the Parent Total
- 1.75Show Value as Percentage of the Parent Column Total
- 1.76Show Value as a Percentage of a Parent Row Total
- 1.77Wrap up of the Parent Total
- 1.78Running Total In
- 1.79% Running Total In
- 1.80Show Value as RANK Largest to Smallest
- 1.81Show Value as RANK Smallest to Largest
- 1.82Show Value as % of another Value
- 1.83Show Change from Previous Item
- 1.84Show % Change from Previous Month
- 1.85Compare this Month and Year to Same Period Last Year
- 1.86Variance from Last Year
- 1.87Introduction to Data Visualisations
- 1.88Creating a Column Chart with a Legend
- 1.89How to quickly transform your Charts
- 1.90Creating and formating the Dashboard Canvas
- 1.91Building Visuals for the Dashboard
- 1.92Part2-Building Visuals for the Dashboard
- 1.93Displaying Visuals on the Dashboard
- 1.94Creating an Interractive Dashboard