Module 1- Introduction to getting organised

Module 2- The analysis process

Module 3- Always a need to organise 

Module 4- More on sorting and filtering 

Module 5- Sorting datasets 

Module 6- The SORT function 

Module 7- Sorting queries in SQL

Module 8- Getting started with data formatting 

Module 9- From one type to another 

Module 10- Data validation

Module 11- Conditional formatting 

Module 12- Merging and multiple sources 

Module 13- Strings in spreadsheets 

Module 14- Solution  when you get stuck

Module 15- Running into challenges? Not to worry!

Module 16- Right time to use which tool

Module 17- Aggregate data for analysis 

Module 18- Preparing for VLOOKUP

Module 19- VLOOKUP in action

Module 20- Identifying common VLOOKUP errors 

Module 21- Understanding JOINS 

Module 22- COUNT and COUNT DISTINCT

Module 23- Queries within queries 

Module 24- Using subqueries to aggregate data 

Module 25-  Data calculation

Module 26- Common calculation formulas 

Module 27- Functions and conditions

Module 28-  Composite functions 

Module 29- Start working with pivot tables 

Module 30- Pivot tables continued

Module 31- Queries and calculations

Module 32- Embedding simple calculations in SQL

Module 33- Calculations with other statements 

Module 34 -Check and recheck

Module 35- Temporary tables

Module 36- Multiple table variations