Practical Microsoft Excel + Microsoft Excel data analysis
What you'll learn
- In part 1 we will teach you the Excel skills that are in demand in practice.
- In part 2 we will teach you data analysis skills so you to find patterns and relationships in data that you can use to improve your business.
- How to apply the statistical theory for data analysis in MS Excel 2016 (other versions are also fine)
- You will learn by cases. We use cases from television shows, famous supermarkets, food history , famous rock bands etc.
- Preferably you have the 2016 Windows MS Excel installed on your laptop.
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....
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 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.
Who this course is for:
- Business professionals
- IT professionals
- Healthcare professionals
- Financial professionals
- Basically anyone who is dealing with information and has the need to structure and analyse that info
Six Sigma Academy Amsterdam or SSAA started when a number of university lecturers from the Netherlands decided to make expensive education more affordable, practical, time efficient and entertaining. Yes, education should not be punishment. It should be fun too. Education should not waste your time with knowledge that is only useful in an exam. It should make you better in practice.
All course developers and lecturers involved are qualified university lecturers as well as Six Sigma Master Black Belts and as such able to train students and future instructors. All the Lean Six Sigma programs we offer are accredited based on the Dutch BKO standards and our student experience shows that the degrees are globally accepted and respected.
SSAA has trained and certified more 100,000+ students in the Netherlands, Germany, US, India and UAE, both online and offline. Furthermore, SSAA lecturers have supervised projects for companies like Audi, the Dutch military and Lufthansa.