What you'll learn:
- How to work with Excel in general (version is not very important)
- Statistical theory for data analysis
- How to apply the statistical theory for data analysis in MS Excel 2016 (other versions are also fine)
Hi there! How are you? Thanks for considering our Microsoft Excel course. There are at least 100 MS Excel courses out there. Why choose our MS Excel? Because of the following reasons:
We pre-selected the important Microsoft Excel elements that are highly used in practice. So you do not spend 40 hours on a massive MS Excel course, only to find that what you really need 99% of the time, could be explained in a fraction of that time. We respect your time.
We mix the MS Excel course with story telling. We integrate interesting stories to give Microsoft Excel 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....
This course is 2 courses in 1.
In the first part you learn how MS Excel works. What exactly?
MS Excel: Pivot charts and pivot tables
MS Excel: Nested IF functions
MS Excel: AND function
MS Excel: Combining IF & AND function
MS Excel: Cross sheet referencing
MS Excel: Vlookup
MS Excel: Freeze panes
MS Excel: List functions
MS Excel: Absolute and relative cell references
MS Excel: Histograms
MS Excel: Pareto charts
MS Excel: Multiple line charts
MS Excel: Bar charts
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:
Correlation with MS Excel
Single OLS regression with MS Excel
Multiple OLS regression with MS Excel
Non linear regression with MS Excel
At the end of this course, you obtain a certification of completion.
Note: We use Microsoft Excel 2016, but other versions are fine too.
Thanks for considering us. Have a great day, wherever you are.