2 in 1: Microsoft Excel: Practical MS Excel + MS Excel data analysis
WHY CHOOSE US?
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....
STRUCTURE
This course is 2 courses in 1.
PART 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
Chart theory
PART 2
In part two, you will learn statistics techniques for data analysis. You do not need any statistics or math background. Subsequently, you learn how to execute these statistics data analysis 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.
Team SSAA