Microsoft Excel – Excel Data Analysis Expert (Accredited)

Microsoft Excel – Excel Data Analysis Expert (Accredited), available at $79.99, has an average rating of 4.56, with 116 lectures, 5 quizzes, based on 2728 reviews, and has 13761 subscribers.

You will learn about 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. This course is ideal for individuals who are Business professionals or IT professionals or Healthcare professionals or Financial professionals or Basically anyone who is dealing with information and has the need to structure and analyse that info It is particularly useful for Business professionals or IT professionals or Healthcare professionals or Financial professionals or Basically anyone who is dealing with information and has the need to structure and analyse that info.

Enroll now: Microsoft Excel – Excel Data Analysis Expert (Accredited)

Summary

Title: Microsoft Excel – Excel Data Analysis Expert (Accredited)

Price: $79.99

Average Rating: 4.56

Number of Lectures: 116

Number of Quizzes: 5

Number of Published Lectures: 116

Number of Published Quizzes: 5

Number of Curriculum Items: 121

Number of Published Curriculum Objects: 121

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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

Target Audiences

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 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.

Course Curriculum

Chapter 1: Basics of MS Excel

Lecture 1: How this Microsoft Excel course is set up

Lecture 2: Microsoft Excel versions

Lecture 3: Giuseppe, from rags to riches!

Lecture 4: Certificate

Lecture 5: Microsoft Excel data file for exercises

Lecture 6: Cell relationships in Microsoft Excel

Lecture 7: Formatting in Microsoft Excel

Lecture 8: Conditional formatting in Microsoft Excel

Lecture 9: EXERCISE MICROSOFT EXCEL 1

Lecture 10: Don Balboa's demand!

Lecture 11: Find and replace in Microsoft Excel

Lecture 12: Sort in Microsoft Excel

Lecture 13: Keyboard shortcuts in Microsoft Excel

Lecture 14: Filter in Microsoft Excel

Lecture 15: EXERCISE MICROSOFT EXCEL 2

Lecture 16: Worksheets in Microsoft Excel

Lecture 17: Cousin Tony's surprise

Lecture 18: Protection in Microsoft Excel

Lecture 19: Freeze panes in Microsoft Excel

Lecture 20: Patterns in Microsoft Excel

Lecture 21: Absolute and relative references in Microsoft Excel

Lecture 22: EXERCISE MICROSOFT EXCEL 3

Lecture 23: Sky pirate Pete's dizziness

Chapter 2: FUNCTIONS

Lecture 1: Functions in Microsoft Excel: The mystery box

Lecture 2: Regional settings of Microsoft Excel

Lecture 3: Analysis Toolpak and Translator Option for Microsoft Excel

Lecture 4: AND function in Microsoft Excel

Lecture 5: AND function continued in Microsoft Excel

Lecture 6: EXERCISE: AND function

Lecture 7: Content surprise box 1

Lecture 8: IF function in Microsoft Excel 1

Lecture 9: IF function in Microsoft Excel 2

Lecture 10: Nested IF function in Microsoft Excel 1

Lecture 11: Nested IF function in Microsoft Excel 2

Lecture 12: EXERCISE: Nested IF functions

Lecture 13: Combining IF & AND functions in Microsoft Excel

Lecture 14: VLOOKUP function in Microsoft Excel

Lecture 15: Content surprise box 2

Chapter 3: SCENARIOS WITH MICROSOFT EXCEL

Lecture 1: Marcus Aurelius

Lecture 2: GOAL SEEK in Microsoft Excel

Lecture 3: EXERCISE GOAL SEEK IN MICROSOFT EXCEL

Lecture 4: Unlocking SOLVER in Microsoft Excel

Lecture 5: SOLVER 1 in Microsoft Excel

Lecture 6: SOLVER 2 In Microsoft Excel

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

Lecture 1: Section Intro: Ed Wood

Lecture 2: Measurement scales introduction

Lecture 3: Measurement scales 1

Lecture 4: Measurement scales 2

Lecture 5: Ed Wood DIY movie making

Lecture 6: THEORY: Mode

Lecture 7: THEORY: Median

Lecture 8: THEORY: Mean Vs Median

Lecture 9: Our Microsoft Excel File

Lecture 10: Mean, Mode, Min, Max in Microsoft Excel

Lecture 11: Median in Microsoft Excel

Lecture 12: THEORY: (Geometric) Mean I

Lecture 13: THEORY: (Geometric) Mean II

Lecture 14: Raising To Power in Microsoft Excel

Lecture 15: Geometric Mean in Microsoft Excel

Lecture 16: EXERCISE: Geometric Mean, Mode, Median

Lecture 17: Ed Wood's flying saucers

Chapter 5: PIVOT TABLES AND CHARTS WITH MICROSOFT EXCEL

Lecture 1: Pivot tables in Microsoft Excel

Lecture 2: Pivot charts in Microsoft Excel

Lecture 3: EXERCISE: Pivot tables in Microsoft Excel

Chapter 6: GRAPHS WITH MICROSOFT EXCEL

Lecture 1: Choosing the right type of chart in Microsoft Excel

Lecture 2: (Multiple) line chart in Microsoft Excel

Lecture 3: Logarithmic scale in Microsoft Excel

Lecture 4: Pareto chart in Microsoft Excel

Lecture 5: Bar chart in Microsoft Excel

Lecture 6: Pie chart in Microsoft Excel

Lecture 7: Common chart mistakes

Lecture 8: EXERCISE: Chart building in Microsoft Excel

Chapter 7: STANDARD DEVIATION WITH MICROSOFT EXCEL

Lecture 1: Intro Coca Cola

Lecture 2: Histograms and standard deviation in Microsoft Excel

Lecture 3: Histogram in Microsoft Excel

Lecture 4: Standard Deviation Rules Of Thumb

Lecture 5: Kelly Hepburn and Santa

Lecture 6: Standard Deviation in Microsoft Excel

Lecture 7: Normality Assumption

Lecture 8: Nuances Standard Deviation

Lecture 9: Our Microsoft Excel file

Lecture 10: NORM.DIST Function in Microsoft Excel

Lecture 11: EXERCISE: NORM.DIST Function in Microsoft Excel

Lecture 12: Santa's new look

Chapter 8: DASHBOARD

Lecture 1: Dashboard Introduction

Lecture 2: Our Microsoft Excel Excel file

Lecture 3: Dashboard in Microsoft Excel 1

Lecture 4: Dashboard in Microsoft Excel 2

Lecture 5: Dashboard in Microsoft Excel 3

Instructors

Six Sigma Academy Amsterdam (SSAA)
ACCREDITED TEACHING BY ACADEMICS

Rating Distribution

1 stars: 9 votes
2 stars: 27 votes
3 stars: 288 votes
4 stars: 999 votes
5 stars: 1405 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu