Practical Microsoft Excel + Microsoft Excel data analysis

Practical Microsoft Excel + Data Analysis With Microsoft Excel For Data Sciences. Accredited

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.
Requirements
Preferably you have the 2016 Windows MS Excel installed on your laptop.
Description
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
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



More Info