Explore

2 in 1: Complete Excel + Data Analysis

4.5 hours on-demand video

$ 9.99

Save Course

Go to Course

Brief Introduction

Complete Excel training and data analysis. Not boring... guaranteed! We use Excel 2016, but other versions are fine too.

Description

WHY CHOOSE US?

Hi there! How are you? Thanks for considering our course. There are at least 100 Excel and data analysis courses out there. Why choose ours? Because of the fact that we mix it with story telling. We integrate interesting stories to give Excel and data analysis some context. So do not expect a boring ride. Instead, expect an exciting ride. So expect context about for instance:

Kellog's cornflakes' weird history
Dutch Christmas traditions
Tasty Brazilian fast food
Albrecht brothers who founded Aldi supermarkt
Atari and Nintendo
The Navy SEALs
Dutch theme park 'The Efteling'

And much much more....

STRUCTURE

This course is 2 courses in 1.

PART 1

In the first part you learn how Excel works. What exactly?

Pivot charts and pivot tables
Nested IF functions
AND function
Combining IF & AND function
Cross sheet referencing
Vlookup
Freeze panes
List functions
Absolute and relative cell references
Histograms
Pareto charts
Multiple line charts
Bar charts
Chart theory

PART 2

In part two, you will learn the theory of statistical techniques for data analysis. You do not need any statistical or mathematical background. Subsequently, you learn how to execute these theories in Excel. The tools of data analytics which you will learn include for instance:

Standard deviation
Correlation
Single OLS regression
Multiple OLS regression
Non linear regression

At the end of this course, you obtain a certification of completion.

Note: We use Excel 2016, but other versions are fine too.

Thanks for considering us. Have a great day, wherever you are.

Team SSAA

Requirements

Requirements
Preferably you have the 2016 Windows MS Excel installed on your laptop

Recommended for you

Learn KPIs & Financial Metrics

Learn KPIs (Key Performance Indicators) with real life examples: GutBuddy Yogurt Inc. and SpaBooker Inc. KPIs are simple yet powerful tools to measure the health of any business...

Save Course

Data Science & Machine Learning(Theory+Projects)A-Z 90 HOURS

Mastering Data Science & Machine Learning using Python-A to Z-Learn Statistics, Preprocessing & Reinforcement Learning Comprehensive Course Description: Fast forward to today....

Save Course

Inclusive Analytic Techniques

Many policies, products, services or processes that we think of as gender-neutral actually have gendered outcomes. The question is, what can you do to change this?...

Save Course

Research Report: Delivering Insights

You have completed all the hard work of conducting your internal, secondary, and primary research. Getting Started & Synthesizing Findings and Deriving Insights...

Save Course