Home

All courses

Microsoft Excel - Excel Data Analysis Expert (Accredited)

Excel

Business

Business Analytics & Intelligence

Microsoft Excel - Excel Data Analysis Expert (Accredited)

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

4.5

(3348)

16399 enrolled on this course

Last updated 11/2021

Six Sigma Academy Amsterdam (SSAA)

₹ 3099.0

₹ 4599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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.
We present the Microsoft Excel course based on story telling.
.
STRUCTURE
This Microsoft Excel course can be seen as a 2 in 1 course. We teach you data analysis techniques with Microsoft Excel, but we also teach you how to work with Microsoft Excel in general. So if you have not touched Microsoft Excel before, you have nothing to worry about. 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

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.

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Basics of MS Excel

1.1-How this Microsoft Excel course is set up

1.2-Microsoft Excel versions

1.3-Giuseppe, from rags to riches!

1.4-Certificate

1.5-Microsoft Excel data file for exercises

1.6-Cell relationships in Microsoft Excel

1.7-Formatting in Microsoft Excel

1.8-Conditional formatting in Microsoft Excel

1.9-EXERCISE MICROSOFT EXCEL 1

1.10-Don Balboa's demand!

1.11-Find and replace in Microsoft Excel

1.12-Sort in Microsoft Excel

1.13-Keyboard shortcuts in Microsoft Excel

1.14-Filter in Microsoft Excel

1.15-EXERCISE MICROSOFT EXCEL 2

1.16-Worksheets in Microsoft Excel

1.17-Cousin Tony's surprise

1.18-Protection in Microsoft Excel

1.19-Freeze panes in Microsoft Excel

1.20-Patterns in Microsoft Excel

1.21-Absolute and relative references in Microsoft Excel

1.22-EXERCISE MICROSOFT EXCEL 3

1.23-Sky pirate Pete's dizziness

2-FUNCTIONS

2.1-Functions in Microsoft Excel: The mystery box

2.2-Regional settings of Microsoft Excel

2.3-Analysis Toolpak and Translator Option for Microsoft Excel

2.4-AND function in Microsoft Excel

2.5-AND function continued in Microsoft Excel

2.6-EXERCISE: AND function

2.7-Content surprise box 1

2.8-IF function in Microsoft Excel 1

2.9-IF function in Microsoft Excel 2

2.10-Nested IF function in Microsoft Excel 1

2.11-Nested IF function in Microsoft Excel 2

2.12-EXERCISE: Nested IF functions

2.13-Combining IF & AND functions in Microsoft Excel

2.14-VLOOKUP function in Microsoft Excel

2.15-Content surprise box 2

3-SCENARIOS WITH MICROSOFT EXCEL

3.1-Marcus Aurelius

3.2-GOAL SEEK in Microsoft Excel

3.3-EXERCISE GOAL SEEK IN MICROSOFT EXCEL

3.4-Unlocking SOLVER in Microsoft Excel

3.5-SOLVER 1 in Microsoft Excel

3.6-SOLVER 2 In Microsoft Excel

4-(GEOMETRIC) MEAN, MODE AND MEDIAN WITH MICROSOFT EXCEL

4.1-Section Intro: Ed Wood

4.2-Measurement scales introduction

4.3-Measurement scales 1

4.4-Measurement scales 2

4.5-Measurement scales quiz

4.6-Ed Wood DIY movie making

4.7-THEORY: Mode

4.8-THEORY: Median

4.9-THEORY: Mean Vs Median

4.10-Our Microsoft Excel File

4.11-Mean, Mode, Min, Max in Microsoft Excel

4.12-Median in Microsoft Excel

4.13-THEORY: (Geometric) Mean I

4.14-THEORY: (Geometric) Mean II

4.15-Raising To Power in Microsoft Excel

4.16-Geometric Mean in Microsoft Excel

4.17-EXERCISE: Geometric Mean, Mode, Median

4.18-Ed Wood's flying saucers

5-PIVOT TABLES AND CHARTS WITH MICROSOFT EXCEL

5.1-Pivot tables in Microsoft Excel

5.2-Pivot charts in Microsoft Excel

5.3-EXERCISE: Pivot tables in Microsoft Excel

6-GRAPHS WITH MICROSOFT EXCEL

6.1-Choosing the right type of chart in Microsoft Excel

6.2-(Multiple) line chart in Microsoft Excel

6.3-Logarithmic scale in Microsoft Excel

6.4-Pareto chart in Microsoft Excel

6.5-Bar chart in Microsoft Excel

6.6-Pie chart in Microsoft Excel

6.7-Common chart mistakes

6.8-EXERCISE: Chart building in Microsoft Excel

6.9-Quiz Chart types

7-STANDARD DEVIATION WITH MICROSOFT EXCEL

7.1-Intro Coca Cola

7.2-Histograms and standard deviation in Microsoft Excel

7.3-Histogram in Microsoft Excel

7.4-Standard Deviation Rules Of Thumb

7.5-Kelly Hepburn and Santa

7.6-Standard Deviation in Microsoft Excel

7.7-Normality Assumption

7.8-Nuances Standard Deviation

7.9-MS Excel Data Analysis: Quiz

7.10-Our Microsoft Excel file

7.11-NORM.DIST Function in Microsoft Excel

7.12-EXERCISE: NORM.DIST Function in Microsoft Excel

7.13-Santa's new look

8-DASHBOARD

8.1-Dashboard Introduction

8.2-Our Microsoft Excel Excel file

8.3-Dashboard in Microsoft Excel 1

8.4-Dashboard in Microsoft Excel 2

8.5-Dashboard in Microsoft Excel 3

9-CORRELATION

9.1-Mission to Mars

9.2-THEORY: Pearson correlation coefficient

9.3-Our Microsoft Excel data file

9.4-Visualizing in Microsoft Excel

9.5-Correlation in Microsoft Excel

9.6-Correlation matrix in Microsoft Excel

9.7-Inspecting the correlation matrix in Microsoft Excel

9.8-Nuclear war on Mars

9.9-EXERCISE CORRELATION IN MICROSOFT EXCEL

9.10-SOLUTION CORRELATION IN MICROSOFT EXCEL

9.11-THEORY: Correlation pitfalls 1

9.12-THEORY: Correlation pitfalls 2

9.13-THEORY: Correlation pitfalls 3

9.14-Respect outliers

9.15-Time lag in Microsoft Excel

9.16-EXERCISE time lag in Microsoft Excel

9.17-Solution time lag in Microsoft Excel

9.18-Quiz

9.19-Nuking Mars

10-REGRESSION WITH MICROSOFT EXCEL

10.1-THEORY: Single OLS regression

10.2-Single OLS regression in Microsoft Excel

10.3-EXERCISE: Single OLS regression in Microsoft Excel

10.4-Quiz

10.5-Single non-linear regression in Microsoft Excel

10.6-THEORY: Multiple OLS regression part 1

10.7-THEORY: Multiple OLS regression part 2

10.8-Multiple OLS regression in Microsoft Excel

10.9-EXERCISE: Multiple OLS regression in Microsoft Excel

11-How to proceed.

11.1-Bonus lecture

Course Categories

Popular Courses

Microsoft Excel - Excel Data Analysis Expert (Accredited)

Description

What you'll learn

Requirements

Course Content

You May Like