Class One; Text (Introduction To Data Analysis)

Class One Quiz

Class Two; Text (Introduction to Excel)

Class Two Video Part 1 (Introduction to Basic excel formula and functions)

Class Two Video Part 2

Class Two Video Part 3

Class Two Video Part 4

Class Two Quiz

Class Three: Text (Split, Transpose, Drop down list and Vlookup functions)

Class Three Video Part 1

Class Three Video Part 2

Class Three Video Part 3

Class Three Video Part 4

Class Three Video Part 5

Class Three Video Part 6

Class Three Quiz

WEEK 1 ASSIGNMENT

Class Four; Text (If statement and data cleaning)

Class Four Video Part 1

Class Four Video Part 2

Class Four Video Part 3

Class Four Video Part 4

Class Four Video Part 5

Class Four Video Part 6

Class Four Quiz

Class Five: Text (SORT AND FILTER, CONDITIONAL FORMATTING, PIVOT TABLE AND CHART)

Class Five Video Part 1

Class Five Video Part 2 (Sort and Filter)

Class Five Video Part 3

Class Five Video Part 4

Class Five Video Part 5

Class Five Quiz

Class Six: Text (Data Cleaning using Power Query Editor)

Class Six Video Part 1 (Power Query Editor)

Class Six Video Part 2

Class Six Video Part 3

Class Six Quiz

WEEK 2 ASSIGNMENT