Excel for Data Analysis

Course Cover
compare button icon

Course Features

icon

Duration

4 weeks

icon

Delivery Method

Online

icon

Available on

Lifetime Access

icon

Accessibility

Mobile, Desktop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Effort

4 hours per week

icon

Teaching Type

Self Paced

Course Description

The second course in Data Analysis for Business ExpertTrack builds upon the basics and shows you how to organize your data and create databases that will enhance your business analytics. Learn how to apply critical thinking skills to data. Excel will be used to perform data analysis. You'll learn the most commonly used formulas and functions to combine and crunch data. This course will help you transform your knowledge into powerful techniques and tools for analysis.

Tidying data is the process of tying your data back to its original meaning. This includes matching rows, columns and tables with your variables and types. Tidy data is easier to use formulas and visualisations, and it tells a better story. As part of the creation process, you will need to explain how functions impact form. How easily data can be used will depend on how well the database is organized. SQLite will allow you to import tables and make adjustments according to your requirements. You can preview some of the steps in this course before you sign up.

Course Overview

projects-img

Alumni Network

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Articulate how to perform basic analysis in Excel

Outline the steps involved in tidying data

Identify the correct ERD for a dataset

Articulate how to create a database and import tables using SQLite

Target Students

This course is for anybody who needs data analytics skills at work, or would like to progress to a job where they're desirable or necessary

Course Instructors

Jacques Haasbroek

Instructor

As a certified Data Analyst and holder of a Chartered Global Management Accountant designation I provide a unique set of skills in the fields of data, analytics, finance, and accounting.
Course Cover