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
Requrirements
Requirements
Preferably you have the 2016 Windows MS Excel installed on your laptop
