Joining Data in Excel

Lesson List

Course Introduction?

Data Analysis with Excel Course Introduction (read-through)

Introduction to Data Analytics

Transforming Data

Text Manipulation

Exploratory Analysis

Introduction to Power Query

Quartlies, Percentiles and the IQR

Calculating and Interpreting Box-Plots and IQR

Standard Deviation

Demonstration – Applying Descriptive Statistics

Data Analytics Assignment – Kickstarter

Data Analysis with Excel | Final Quiz

Joining Data in Excel | Lesson Part 1

Please download the following lesson handout and workbook for completing the following lessons.

Lesson Handout

Lesson Workbook

← Previous Next →

Course Introduction?

Data Analysis with Excel | Course Introduction

Introduction to Data Analytics

The Role of a Data Analyst

The Data Science Hierarchy

Data Storage and Databases

The Data Analytics Process

Transforming Data

Introduction to Transforming Data

Cleaning Data

Dealing with Missing and Incorrect Values

Text Manipulation

Text Manipulation | Lesson part 1

Text Manipulation | Lesson part 2

Text Manipulation | Lesson Exercise

Joining Data in Excel

Joining Data in Excel | Lesson Part 1

Joining Data in Excel | Lesson part 2 – INDEX/MATCH

Joining Data in Excel | Exercise

Exploratory Analysis

Exploratory Analysis | Lesson part 1

Exploratory Analysis | Lesson part 2

Exploratory Analysis | Lesson part 3

Introduction to Power Query

Introduction to Power Query | Lesson 1

Introduction to Power Query | Lesson part 2 – Loading data from separate sources

Quartlies, Percentiles and the IQR

Quartiles, Percentiles and the IQR | Lesson

Calculating and Interpreting Box-Plots and IQR

Calculating and Interpreting Box-Plots and IQR | Lesson part 1 – Quartiles and BoxPlot

Calculating and Interpreting Box-Plots and IQR | Lesson part 2 – Classifications

Calculating and Interpreting Box-Plots and IQR | Lesson part 3 – Percentiles

Calculating and Interpreting Box-Plots and IQR | Lesson Exercise

Standard Deviation

Standard Deviation | Lesson Part 1

Standard Deviation | Lesson part 2 – Measures of Skewness

Standard Deviation | Lesson part 3 – Using STD Deviation

Standard Deviation | Lesson part 4 – Detecting Outliers

Demonstration – Applying Descriptive Statistics

Applying Descriptive Statistics | Demonstration part 1

Applying Descriptive Statistics | Demonstration part 2 – Calculating Rank

Applying Descriptive Statistics | Demonstration part 3 – STD Deviation

Data Analytics Assignment – Kickstarter

Practical Assignment Instructions

Kickstarter | Assignment Brief

Kickstarter | Assignment Submission

Data Analysis with Excel | Final Quiz

Data Analysis with Excel | Final Quiz Resources

Data Analysis with Excel | Final Quiz

Login