All Tutorials Excel Tutorials

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

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

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

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

What you’ll learn

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

  • 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
  • Nonlinear 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 analyze that info
  • Content From: http://www.udemy.com/course/complete-excel-2016-data-analytics-theory-bko-accredited/
  • Master Tableau in Data Science Course

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

Download Tutorial (Size: 3.0 GB)

Advertisement

Categories