Curriculum
- 1 Section
- 35 Lessons
- 52 Weeks
Expand all sectionsCollapse all sections
- Introduction to Data Analytics35
- 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
Course Materials
Next