2 in 1: Complete 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 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
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
Course content
- Preview02:32
- 05:20Basics (sorting, formatting, pattern recognition)
- 03:43Analysis Toolpak and Translator Option
- 03:41Data file for exercises
- 05:43Locking cells + dropdown menu
- Preview04:17
- 03:48Cross sheet referencing
- 01:58Conditional formatting
- 04:45EXERCISE: Absolute, relative and cross sheet references
- 01:37Freeze Panes
- 01:12Filter function
- 02:56AND function
- 02:54EXERCISE: AND function
- 03:13IF function
- 05:42Nested IF function
- 07:39EXERCISE: Nested IF functions
- 08:01Combining IF & AND functions
- 07:59Vlookup function
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.5 Instructor Rating
- 16,745 Reviews
- 43,403 Students
- 5 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 lecturers have BKO/BKE accreditation (University Teaching & Testing Accreditation in the Netherlands).
We have trained and certified more than 90,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. Apart from training, we also offer consultancy.
We offer students the chance to also receive Lean Six Sigma Black Belt certification from us if they enroll and finish our four courses: Lean Management, Six Sigma White, Green and Black Belt. Please have a look at our courses to see the procedure.