# Data Analysis with Excel

The Data Analyst course will provide you with the core skills required to transform unprocessed data into insights that can enable decision making. With the mantra 'learn by doing', this course teaches the fundamentals of data analysis through interactive and practical content. You will walk away from the course with the ability to apply statistical analysis to real-world problems using Excel.
In this course, you’ll learn how to:

- Solve problems using data by utilising the 4 step Data Analyst method
- Transform and manipulate data, including cleaning and joining
- Conduct exploratory analysis to identify trends in data
- Calculate measures of spread, measuring an individual value against the whole
- Deliver a practical assignment using real world data

Course

Materials

Prerequisites: | Data Foundations Course |

Course hours: | 40-50 |

Assessments: | 1 graded assessment plus quizzes |

Certificate: | WYWM Data Analyst Certificate |

Instructor Support: | Yes |

Difficulty: | Intermediate |

This is the second course in a three-part course series comprising of Data Foundations, Data Analysis with Excel and Data Visualisation with PowerBI.

Join us on WYWM Data discord chat here!

## Course Content

Expand All

Introduction

Course Introduction
1 Topic

Expand

Lesson Content

0% Complete
0/4 Steps

Transform

Transforming Data
3 Topics

Expand

Lesson Content

0% Complete
0/3 Steps

Text Manipulation
3 Topics

Expand

Lesson Content

0% Complete
0/3 Steps

Lesson Content

0% Complete
0/3 Steps

Lesson Content

0% Complete
0/2 Steps

Analyse

Lesson Content

0% Complete
0/3 Steps

Lesson Content

0% Complete
0/4 Steps

Correlation in Excel

Assessment

Preview this Course

+1528 enrolled

Not Enrolled

This course is currently closed

#### Course Includes

- 17 Lessons
- 34 Topics
- 5 Quizzes
- Course Certificate

Login

Accessing this course requires a login, please enter your credentials below!