Hello and welcome to the Data Analysis with Excel course. It’s recommended you complete the Data Foundations (minimum: Basic Analysis Summary Lesson and Final Quiz) prior to starting this course.
Course Outline:
In this course you’ll learn the following skills:
Transform
- Clean and transform data
- Deal with missing and incomplete values
- Join data in excel
Analyse
- Exploratory Analysis with Pivot Tables
- Introduction to Power Query
- Quartiles, percentiles and the IQR
- Histograms and Boxplots
- Calculating and interpreting Standard Deviation
Course Principles:
- Skills over software
We aim to provide you with a base of understanding which will allow you to apply yourself to any tool and many different situations. While this course is Data Analytics using Excel, Excel is just the tool that helps you learn the skills.
- Learn by doing
The best way to gain skills in Data is through practice. Course content is designed with a focus on practical lessons. In practical lessons you’ll follow along with the video, and there are additional exercises for you to practice your skills.
Lesson Structure:
- Video Lesson
- What, how, why and when of a skill
- Lesson Exercise
- Follow along with the video to practice
- Exercise
- Test your skills
- Quiz
- Test your knowledge
And at the end of the course there is a marked assessment. Thanks for joining the Data Analytics with Excel course!