2 in 1: Complete Excel + Data Analysis Application & Theory
- 5 hours on-demand video
- 11 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business- How to work with Excel in general
- Statistical theory for data analysis
- How to apply the statistical theory for data analysis in MS Excel 2016
- Preferably you have the 2016 Windows MS Excel installed on your laptop
Certified Microsoft Excel Data Analyst
2 in 1: Complete Excel + Data Analysis Theory/Application (Dutch BKO Accredited) is 2 courses in 1.
In the first part, you will learn how to work with Excel in general. Among other things, you will learn:
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
In part two, you will learn the theory of statistical techniques for data analysis. Subsequently, you learn how to execute these theories in Excel. The tools of data analytics which you will learn include for instance:
Standard deviation
Single OLS regression
Multiple OLS regression
Non linear regression
At the end of this course, you obtain a certification of completion.
- 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