Introduction to Course

1m 52s

Delegate Pack

Introduction to Modules

1m 27s

Pre course Reading

What is Data Analysis?

3m 47s

Why Data Analysis?

4m 9s

Types of Data Analysis

4m 24s

Data Analysis Process

7m 48s

Module Assessment 1

Introduction to Excel Data Analysis , Data Cleaning, Data Analysis, Data Visualisation

4m 2s

Module Assessment 2

Case Study Inventory Optimization Using Data Analysis Techniques

Case Study Data Cleaning and Analysis for Retail Sales Data

Audio Book: Please revise the key topics we covered in Module 1 and 2

0m 0s

Excel Ribbons

8m 4s

Importing Data into Excel

4m 9s

Module Assessment 3

Steps to Create Range Name

4m 57s

Module Assessment 4

What is a Table? (Part 1)

7m 19s

What is a Table? (Part 2)

4m 22s

Module Assessment 5

Audio Book: Ensure you review the material from Module 3, 4 and 5 before proceeding

0m 0s

Removing Unwanted Characters from the Text

4m 26s

Module Assessment 6

Case Study Human Resources Data Management

Steps to Change Data Format

5m 30s

Module Assessment 7

Case Study Time Series Analysis for Economic Data

What is Conditional Formatting and How to Use It?

3m 49s

Module Assessment 8

Case Study Financial Performance Review Using Conditional Formatting

Audio Book: Reflect on the lessons learnt in Module 6, 7 and 8 as preparation for the next module

0m 0s

What is Sorting and Filtering all parts

11m 45s

Module Assessment 9

Case Study Logistics and Supply Chain Optimisation

Subtotals all parts

6m 29s

Module Assessment 10

Case Study Real Estate Market Analysis Using Subtotals and Quick Analysis

Worksheet Tab all parts

7m 18s

Module Assessment 11

Audio Book: Revisit the core concepts discussed in Module 9, 10 and 11 to reinforce your understanding

0m 0s

What is Data Validation?

3m 26s

Module Assessment 12

Case Study Customer Satisfaction Survey Analysis

What is Data Visualisation?

6m 53s

Module Assessment 13

Case Study Educational Performance Tracking

Audio Book: Ensure you review the material from Module 12 and 13 before proceeding

0m 0s

Lookup Function

6m 28s

Module Assessment 14

PivotTable Overview

9m 1s

Filters and Slicers

7m 22s

Module Assessment 15

Case Study Market Research Analysis Using Pivot Tables and Charts

Case Study Healthcare Patient Data Analysis

What If Analysis?

11m 39s

Module Assessment 16

Case Study Scenario Analysis for Business Expansion Decisions

Audio Book: Please revise the key topics we covered in Module 14, 15 and 16

0m 0s

Post Course Quiz 1

Post Course Quiz 2

Lets prepare for the Interview