Microsoft Excel: Practical MS Excel + MS Excel data analysis
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)
Requirements
- Preferably you have the 2016 Windows MS Excel installed on your laptop
Description
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 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.
Team SSAA
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
Instructor
![Six Sigma Academy Amsterdam](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.6 Instructor Rating
- 33,673 Reviews
- 83,742 Students
- 8 Courses
Six Sigma Academy Amsterdam started when a number of university lecturers from the Netherlands decided to make expensive Lean Six Sigma 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 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.
We have trained and certified more 100,000+ students in the Netherlands, Germany, US, India and UAE, both online and offline. Furthermore, our course designers have supervised projects for companies like Audi, the Dutch military and Lufthansa.