Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel - Excel Data Analysis Expert (Accredited)

Name: Microsoft Excel - Excel Data Analysis Expert (Accredited)
Rating: 4.3 (3574 reviews)

Microsoft Excel Data Analysis Expert | Dashboards | Microsoft Excel 2016, Microsoft Excel 2019, MS Excel 365 Compatible

Created bySix Sigma Academy Amsterdam (SSAA)

Last updated 10/2025

English

What you'll learn

You will learn Microsoft Excel from the ground up.
Use Microsoft Excel to find patterns and relationships.
Understand Microsoft Excel data analysis techniques in plain and simple terms.
You will learn Microsoft Excel by stories that will take you on a journey through history, pop culture and fiction.

Course content

11 sections • 119 lectures • 7h 33m total length

How this Microsoft Excel course is set up1:57
Microsoft Excel versions2:46
Giuseppe, from rags to riches!1:20
Certificate0:34
Microsoft Excel data file for exercises3:41
Cell relationships in Microsoft Excel2:50
Formatting in Microsoft Excel2:44
Conditional formatting in Microsoft Excel2:18
EXERCISE MICROSOFT EXCEL 14:19
Don Balboa's demand!2:08
Find and replace in Microsoft Excel1:58
Sort in Microsoft Excel1:56
Keyboard shortcuts in Microsoft Excel0:39
Learn three ways to copy data in Excel—the icon button, right-click copy, and the Ctrl+C keyboard shortcut—plus access to a complete list of keyboard shortcuts.
Hell Week2:54
Filter in Microsoft Excel1:17
EXERCISE MICROSOFT EXCEL 23:26
Worksheets in Microsoft Excel3:48
Cousin Tony's surprise1:21
Protection in Microsoft Excel3:57
Freeze panes in Microsoft Excel2:08
Master freeze panes in Microsoft Excel to keep the top row or first column visible as you scroll through large data sets, and learn how to unfreeze when needed.
Patterns in Microsoft Excel2:13
Absolute and relative references in Microsoft Excel6:28
Infinite formulas in Microsoft Excel5:14
Master infinite formulas in Microsoft Excel by quickly copying a formula across entire columns and rows using keyboard shortcuts (Ctrl+Shift+Down, Ctrl+D, Ctrl+Shift+Right, Ctrl+R, Ctrl+L) for huge data sets.
EXERCISE MICROSOFT EXCEL 33:42
Freeze the top row to keep headers visible while scrolling. Convert dvd sales from dollars to yen using an absolute reference to the exchange rate at $B$2, ensuring drag-down calculations.
Sky pirate Pete's dizziness2:16

Functions in Microsoft Excel: The mystery box1:53
Regional settings of Microsoft Excel4:53
Analysis Toolpak and Translator Option for Microsoft Excel3:43
AND function in Microsoft Excel2:55
AND function continued in Microsoft Excel2:54
EXERCISE: AND function2:05
Content surprise box 11:25
IF function in Microsoft Excel 12:41
IF function in Microsoft Excel 22:31
Nested IF function in Microsoft Excel 12:35
Nested IF function in Microsoft Excel 25:32
EXERCISE: Nested IF functions7:39
Combining IF & AND functions in Microsoft Excel8:01
VLOOKUP function in Microsoft Excel7:59
Content surprise box 21:30

Section Intro: Ed Wood2:05
Measurement scales introduction0:14
Measurement scales 17:47
Measurement scales 24:59
Measurement scales quiz
Ed Wood DIY movie making0:47
THEORY: Mode2:04
Identify the mode as the most frequent rating in data, illustrated by one and five appearing most often, including bimodal cases, and note its role alongside the mean.
THEORY: Median1:45
THEORY: Mean Vs Median3:42
Compare mean and median to understand when to use each, and demonstrate how extreme values distort the mean, recommending reporting both to reveal central tendency.
Our Microsoft Excel File0:36
Mean, Mode, Min, Max in Microsoft Excel3:08
Median in Microsoft Excel0:57
THEORY: (Geometric) Mean I3:58
THEORY: (Geometric) Mean II4:39
Raising To Power in Microsoft Excel0:49
Geometric Mean in Microsoft Excel3:37
EXERCISE: Geometric Mean, Mode, Median7:18
Ed Wood's flying saucers0:42

Choosing the right type of chart in Microsoft Excel10:55
(Multiple) line chart in Microsoft Excel3:51
Learn to create and customize a two-line chart in Excel to compare Holland and Belgium profits over years, with proper data selection, axes, and axis titles in US dollars.
Logarithmic scale in Microsoft Excel6:30
Pareto chart in Microsoft Excel5:42
Bar chart in Microsoft Excel3:49
Pie chart in Microsoft Excel2:55
Common chart mistakes1:43
EXERCISE: Chart building in Microsoft Excel6:30
Quiz Chart types

Intro Coca Cola2:02
Explore how Coca-Cola shaped the Santa Claus image through the 1920s campaigns and 1931 Sundblom illustrations, then apply standard deviation theory to an Excel file about Coca-Cola.
Histograms and standard deviation in Microsoft Excel0:50
Histogram in Microsoft Excel5:35
Standard Deviation Rules Of Thumb2:41
Learn how standard deviation measures data dispersion and, with the mean, applies the three standard deviation rules of thumb to bound data within 88–92, 86–94, and 84–96.
Kelly Hepburn and Santa0:50
Standard Deviation in Microsoft Excel5:49
Excel computes standard deviation for plant A and B, using population vs. sample options, showing plant B has greater spread while means stay near 30 cm.
Normality Assumption1:30
Nuances Standard Deviation4:53
MS Excel Data Analysis: Quiz
Our Microsoft Excel file0:52
NORM.DIST Function in Microsoft Excel3:57
EXERCISE: NORM.DIST Function in Microsoft Excel2:00
Santa's new look0:47

Mission to Mars2:10
THEORY: Pearson correlation coefficient7:35
Our Microsoft Excel data file1:39
Visualizing in Microsoft Excel3:47
Correlation in Microsoft Excel2:38
Correlation matrix in Microsoft Excel3:21
Inspecting the correlation matrix in Microsoft Excel3:18
Inspect a correlation matrix in Excel to see which variables relate to passenger numbers, noting negative links with income and positive links with inflation, ticket price, and Mars living space.
Nuclear war on Mars0:28
EXERCISE CORRELATION IN MICROSOFT EXCEL1:44
SOLUTION CORRELATION IN MICROSOFT EXCEL3:07
THEORY: Correlation pitfalls 14:17
THEORY: Correlation pitfalls 23:10
Explains that correlation coefficients capture only linear patterns, so non-linear relationships may show weak correlations. A low correlation does not prove the absence of a relationship.
THEORY: Correlation pitfalls 35:28
Respect outliers7:23
Explore how to respect outliers in data analysis, examining how outliers affect the correlation coefficient between temperature and visitors, and when to remove or keep them based on context.
Time lag in Microsoft Excel8:01
Explore how time lag affects data relationships by testing delayed correlations, using unemployment rate and revenue as examples, and learn to shift data to reveal stronger insights.
EXERCISE time lag in Microsoft Excel2:39
Solution time lag in Microsoft Excel5:25
Quiz
Nuking Mars0:42

THEORY: Single OLS regression17:55
Single OLS regression in Microsoft Excel6:39
EXERCISE: Single OLS regression in Microsoft Excel1:15
Perform a single ols regression in Microsoft Excel to practice data analysis techniques and strengthen skills for the Excel Data Analysis Expert accreditation.
Quiz
Single non-linear regression in Microsoft Excel15:36
THEORY: Multiple OLS regression part 113:46
Explore the theory of multiple OLS regression and learn how Excel calculates it to isolate the pure effects of experience and training on mistakes, guided by R squared.
THEORY: Multiple OLS regression part 26:01
Explore the rules of multiple ols regression, including parametric scales for y and preferably x, avoiding high-cardinality nominals and multicollinearity, with Excel-based calculations in part 3.
Multiple OLS regression in Microsoft Excel11:05
EXERCISE: Multiple OLS regression in Microsoft Excel12:04

Requirements

You should preferably have access to Microsoft Excel if you want to keep up well.

Description

Microsoft Excel 2024 - Microsoft Excel Data Analysis Expert

Thanks for considering our Microsoft Excel course. There are at least 100 Microsoft Excel courses out there. Why choose our Microsoft Excel course? Because of the following reasons:

This course does not require any previous knowledge about Microsoft Excel or data analysis.
This course is designed to be accessibele, regardless of your educational background.
We keep this Microsoft Excel course practical. You learn what is required in the job market in the AI driven world.
We present the Microsoft Excel course based on story telling.

STRUCTURE

We kickstart this This Microsoft Excel course by a very brief introduction to the inner working of Excel, so if you have never touched Excel, do not worry, we will teach you in a few minutes how the basics work. We immediately continue to the actual meat of this course, which is of course the data analysis skills and statistics. In concrete terms, you will learn:

Microsoft Excel Essentials: Absolute and relative referencing
Microsoft Excel Essentials: Freeze panes
Microsoft Excel Essentials: Graphs
Microsoft Excel Essentials: Keyboard shortcuts
Microsoft Excel Essentials: Securing a sheet
Microsoft Excel Essentials: VLOOKUP
Microsoft Excel Essentials: Filter Function
Microsoft Excel Essentials: AND Function
Microsoft Excel Essentials: (Nested) IF Function
Microsoft Excel Essentials: Pivot Charts
Microsoft Excel Essentials: Pivot Tables
Microsoft Excel Essentials: Dashboard function
Microsoft Excel Essentials: Dashboard variable choice
Microsoft Excel Essentials: Dashboard functionality
Microsoft Excel Essentials: Drop Down Menu
Microsoft Excel Essentials: Conditional Formatting
Microsoft Excel Essentials: Pattern Recognition
Microsoft Excel Data Analysis: Scenario analysis
Microsoft Excel Data Analysis: Goal Seek
Microsoft Excel Data Analysis: Solver
Microsoft Excel Data Analysis: Standard Deviation
Microsoft Excel Data Analysis: Normal Distribution
Microsoft Excel Data Analysis: (Geometric) Mean
Microsoft Excel Data Analysis: Median And Mode
Microsoft Excel Data Analysis: Descriptive statistics
Microsoft Excel Data Analysis: Correlation
Microsoft Excel Data Analysis: Single OLS Regression
Microsoft Excel Data Analysis: Non-linear Regression
Microsoft Excel Data Analysis: Multiple OLS Regression

EXTRAS

*Certificate of completion

*30 day money back guarantee

*Accredited course taught by qualified university lecturers

Note: We have tested this course on a test audience and they had little to no problems keeping up with various versions of Microsoft Excel, such as Microsoft Excel 2016, Microsoft Excel 2019 and the MS Office 365 version.

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

Microsoft Excel - Excel Data Analysis Expert (Accredited)

What you'll learn

Explore related topics

Course content

Basics of MS Excel25 lectures • 1hr 8min

FUNCTIONS15 lectures • 58min

SCENARIOS WITH MICROSOFT EXCEL6 lectures • 16min

(GEOMETRIC) MEAN, MODE AND MEDIAN WITH MICROSOFT EXCEL17 lectures • 49min

PIVOT TABLES AND CHARTS WITH MICROSOFT EXCEL3 lectures • 11min

GRAPHS WITH MICROSOFT EXCEL8 lectures • 42min

STANDARD DEVIATION WITH MICROSOFT EXCEL12 lectures • 32min

DASHBOARD6 lectures • 24min

CORRELATION18 lectures • 1hr 7min

REGRESSION WITH MICROSOFT EXCEL8 lectures • 1hr 24min

Requirements

Description

Who this course is for: