2 in 1: Complete Excel + Data Analysis Application & Theory
4.4 (515 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,633 students enrolled

2 in 1: Complete Excel + Data Analysis Application & Theory

University lecturers, Practical, Fast certification, Certified Microsoft Excel Data Analyst (Dutch BKO Accredited)
4.4 (515 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,633 students enrolled
Last updated 12/2019
English
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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

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.


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
Expand all 47 lectures 04:49:19
+ Basics of MS Excel
18 lectures 01:17:00
Basics (sorting, formatting, pattern recognition)
05:20
Analysis Toolpak and Translator Option
03:43
Data file for exercises
03:41
Locking cells + dropdown menu
05:43
Cross sheet referencing
03:48
EXERCISE: Absolute, relative and cross sheet references
04:45
Conditional formatting
01:58
Freeze Panes
01:37
Filter function
01:12
AND function
02:56
EXERCISE: AND function
02:54
IF function
03:13
Nested IF function
05:42
EXERCISE: Nested IF functions
07:39
Combining IF & AND functions
08:01
Vlookup function
07:59
+ Pivot tables & charts
3 lectures 11:26
Pivot charts
03:15
EXERCISE: Pivot tables
04:11
+ Graphs
8 lectures 44:35
Choosing the right type of chart
10:55
(Multiple) line chart
03:51
Logarithmic scale
06:28
Bar chart
03:49
Pie chart
02:55
Histogram
04:25
EXERCISE: Chart building
06:30
+ Measurement scales
1 lecture 07:55
Measurement scales
07:55
Measurement scales quiz
3 questions
+ Standard deviation
4 lectures 34:39
THEORY: Standard deviation Part 1
14:46
THEORY: Standard deviation Part 2
12:05
Standard deviation
06:15
EXERCISE: Standard deviation
01:33
+ Correlation
4 lectures 26:47
THEORY: Correlation
12:55
Correlation part 1
06:06
Correlation part 2
06:27
EXERCISE: Correlation
01:19
+ Regression
8 lectures 01:24:21
THEORY: Single OLS regression
17:55
Single OLS regression
06:39
EXERCISE: Single OLS regression
01:15
Single non-linear regression
15:36
THEORY: Multiple OLS regression part 2
06:01
EXERCISE: Multiple OLS regression
12:04