Welcome To Divex Training

Welcome Message

INTRODUCTION TO DATA ANALYSIS

Data Analysis Part 1

Data Analysis Part 2

Quiz - Introduction

MODULE 1 - INTRODUCTION TO EXCEL

Introduction to Excel

Workbook Versus Worksheet

Basic Formatting

Saving and Organising Workbooks

Basic Arithmetic in Excel

Quiz - Introduction to Excel

MODULE 2 - BASIC EXCEL FUNCTIONS

Introduction to Basic Functions

Basic Excel Functions (1)

Basic Excel Functions (2)

Cell Refrencing

Logical Functions (1)

Logical Functions (2)

Look up and reference functions (1)

Look up and reference functions (2)

Date and Error functions

Summarization functions (1)

Summarization functions (2)

Quiz Basic Functions

Assignment Basic Functions

ACCESS TO MODULE 3

MODULE 3 - EXCEL TABLE AND CONDITIONAL FORMATTING

Welcome to Excel Table and Conditional Formatting

Conditional Formatting 1

Conditional Formatting 2

Data Bars, Colour scale and Custom rules

Structured References in Formulas

Summary of Module 3

Assignment Conditional Formatting

ACCESS TO MODULE 4

MODULE 4 - DATA SORTING AND FILTERING TECHNIQUES

Introduction to Sorting and Filtering

Sorting and Custom Sorting

Basic and Advanced Filtering Techniques

Adding Slicers to Data Set

Creating Custom Views for Report

Summary Sorting

Quiz Data Sorting

Assignment Sorting

ACCESS TO MODULE 5

MODULE 5 - PIVOT TABLE AND DATA VISUALIZATION

Introduction to Pivot Tables and Data Visualization

Adding Calculated Field to Pivot Tables

Creating Pivot Tables Part 1 (A)

Creating Pivot Tables Part 1 (B)

Creating Pivot Table Part 2

Visualizing Data Part 1

Visualizing Data Part 2

Summary Pivot Tables

Quiz Pivot Tables

Assignment Pivot Tables

ACCESS TO MODULE 6

MODULE 6 - POWER QUERY FOR DATA CLEANING

Introduction to Data Cleaning Using Power Query

Importing and Transforming Data (1)

Importing and Transforming Data (2)

Merging and Appending Data

Summary Power Query

Quiz Power Query

Assignment Power Query

ACCESS TO MODULE 7

MODULE 7 - EFFECTIVE DATA VISUALISATION AND DASHBOARDING

Introduction to Dashboards

Choosing and Creating the Right Chart (1)

Choosing and Creating the Right Chart (2)

Dashboard Creation (1)a

Dashboard Creation (1)b

Dashboard Creation (1)c

Dashboard Creation (1)d

MODULE 8 - EFFECTIVE DATA VISUALISATION AND DASHBOARDING 2

Dashboard Creation (2)a

Dashboard Creation (2)b

Dashboard Creation (2)c

Dashboard Creation (2)d

Dashboard Creation (2)e

Dashboard Creation (2)f

Principles for Effective Dashboard Creation

Sparklines for Quick Trends

Quiz - Visualisation

Assignment Visualisation

MENTORSHIP

Assignment Power Query

Using the Excel file attached to this practice question, merge the customer and product table to the data table using their unique identifiers (Customer ID and Product ID).
Remove Duplicate Values

Power Query Practice Question data Download