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

The Complete Business Plan Course (Includes 50 Templates)

Everything You Need to Make a Great Business Plan by an Award Winning Business School Prof, VC & Successful Entrepreneur  ...

Save Course

Pro Trader Network Excel Course 2.0

A Turn-key interactive Professional Trading Education Here’s a brief overview of what you can expect . . . The Excel Course 2....

Save Course

Mastering MS Excel

Master MS Excel 2010-2016 in 5hrs of easy to follow videos The Mastering MS Excel is aimed at MS Excel 2010 to 2016....

Save Course

Portfolio Selection and Risk Management

When an investor is faced with a portfolio choice problem, the number of possible assets and the various combinations and proportions in which each can be held can seem overwhelming....

Save Course