Excel A-Z + Data Analytics Theory & Application (Accredited)

University lecturers, Practical, Fast, Excel A-Z + Data Analytics Theory & Application Theory (Dutch BKO Accredited).

What you'll learn

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

Requirements

Preferably you have the 2016 Windows MS Excel installed on your laptop

Description

Excel A-Z + Data Analytics Theory & Application (Accredited) course 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

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

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