Practical Microsoft Excel + Microsoft Excel data analysis

Focused View

Six Sigma Academy Amsterdam

4:19:17

64 View

01 - Basics of MS Excel

001 Introduction.mp4

04:55

002 Basics (sorting, formatting, pattern recognition).mp4

05:20

003 Analysis Toolpak and Translator Option.mp4

03:43

004 Data file for exercises.mp4

03:41

004 Movies-kopie.xlsx

005 Locking cells + dropdown menu.mp4

05:43

006 Relative and absolute cell references.mp4

04:17

007 Cross sheet referencing.mp4

03:49

008 Conditional formatting.mp4

01:58

009 EXERCISE Absolute, relative and cross sheet references.mp4

04:45

009 Movies-kopie.xlsx

010 Freeze Panes.mp4

01:37

011 Filter function.mp4

01:13

012 AND function.mp4

02:57

013 EXERCISE AND function.mp4

02:54

013 Movies-kopie.xlsx

014 IF function.mp4

03:13

015 Nested IF function.mp4

05:42

016 EXERCISE Nested IF functions.mp4

07:39

016 Movies-kopie.xlsx

017 Combining IF & AND functions.mp4

08:01

018 Vlookup function.mp4

07:59

02 - Pivot tables & charts

001 Pivot tables.mp4

04:00

002 Pivot charts.mp4

03:15

003 EXERCISE Pivot tables.mp4

04:11

003 Movies-kopie.xlsx

03 - Graphs

001 Choosing the right type of chart.mp4

10:56

002 (Multiple) line chart.mp4

03:51

003 EXTRA-EXPLANATION-LOGARITHMIC-SCALES-kopie.pdf

003 Logarithmic scale.mp4

06:30

004 Pareto chart.mp4

05:42

005 Bar chart.mp4

03:49

006 Pie chart.mp4

02:55

007 Histogram.mp4

04:25

008 Common chart mistakes.mp4

05:10

009 EXERCISE Chart building.mp4

06:30

009 Movies-kopie.xlsx

04 - Measurement scales

001 Part 2 Data analysis.html

002 Measurement scales.mp4

07:56

05 - Correlation

001 THEORY Correlation part 1.mp4

06:46

002 THEORY Correlation part 2.mp4

05:42

003 Correlation part 1.mp4

06:06

004 Correlation part 2.mp4

06:27

005 EXERCISE Correlation.mp4

01:19

005 Movies-kopie.xlsx

06 - Regression

001 THEORY Single OLS regression.mp4

17:55

002 Single OLS regression.mp4

06:39

003 EXERCISE Single OLS regression.mp4

01:15

003 Movies-kopie.xlsx

004 Single non-linear regression.mp4

15:36

005 THEORY Multiple OLS regression part 1.mp4

13:46

006 THEORY Multiple OLS regression part 2.mp4

06:01

007 Multiple OLS regression.mp4

11:05

008 EXERCISE Multiple OLS regression.mp4

12:04

008 File-for-multiple-regression-exercise-kopie-1-kopie.xlsx

07 - How to proceed

001 Bonus lecture.html

001 certificate-excel-and-data-analysis-course-Copy.pptx

Description

Practical Microsoft Excel + Data Analysis With Microsoft Excel For Data Sciences. Accredited

What You'll Learn?

In part 1 we will teach you the Excel skills that are in demand in practice.
In part 2 we will teach you data analysis skills so you to find patterns and relationships in data that you can use to improve your business.
How to apply the statistical theory for data analysis in MS Excel 2016 (other versions are also fine)
You will learn by cases. We use cases from television shows, famous supermarkets, food history , famous rock bands etc.

Who is this 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 Need to Know?

Preferably you have the 2016 Windows MS Excel installed on your laptop.

More details

Description
2 in 1: Microsoft Excel: Practical MS Excel + MS Excel data analysis
WHYÂ CHOOSEÂ US?
Hi there! How are you? Thanks for considering our Microsoft Excel course. There are at least 100 MS Excel courses out there. Why choose our MS Excel? Because of the following reasons:
We pre-selected the important Microsoft Excel elements that are highly used in practice. So you do not spend 40 hours on a massive MS Excel course, only to find that what you really need 99% of the time, could be explained in a fraction of that time. We respect your time.
We mix the MS Excel course with story telling. We integrate interesting stories to give Microsoft Excel some context. So do not expect a boring ride. Instead, expect an exciting ride. So expect context about for instance:
Kellog's cornflakes' weird history
Dutch Christmas traditions
Tasty Brazilian fast food
Albrecht brothers who founded Aldi supermarkt
Atari and NintendoÂ
The Navy SEALs
Dutch theme park 'The Efteling'
And much much more....
STRUCTURE
This course is 2 courses in 1.Â
PART 1
In the first part you learn how MS Excel works. What exactly?
MS Excel: Pivot charts and pivot tables
MS Excel: Nested IF functions
MS Excel: AND function
MS Excel: Combining IF & AND function
MS Excel: Cross sheet referencing
MS Excel: Vlookup
MS Excel: Freeze panes
MS Excel: List functions
MS Excel: Absolute and relative cell references
MS Excel: Histograms
MS Excel: Pareto charts
MS Excel: Multiple line charts
MS Excel: Bar charts
Chart theory
PARTÂ 2
In part two, you will learn statistics techniques for data analysis. You do not need any statistics or math background. Subsequently, you learn how to execute these statistics data analysis theories in Excel. The tools of data analytics which you will learn include for instance:
Correlation with MS Excel
Single OLS regression with MS Excel
Multiple OLS regression with MS Excel
Non linear regression with MS Excel
At the end of this course, you obtain a certification of completion.
Note: We use Microsoft Excel 2016, but other versions are fine too.
Thanks for considering us. Have a great day, wherever you are.
Team SSAA
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

User Reviews

Rating

average 0

Total votes0

Focused display

Six Sigma Academy Amsterdam started when a number of university lecturers from the Netherlands decided to make expensive Lean Six Sigma education more affordable, practical, time efficient and entertaining. Yes, education should not be punishment. It should be fun too. Education should not waste your time with knowledge that is only useful in an exam. It should make you better in practice.All course developers and lecturers involved are Six Sigma Master Black Belts and as such able to train students and future instructors. All the Lean Six Sigma programs we offer are accredited based on the Dutch BKO standards and our student experience shows that the degrees are globally accepted and respected.We have trained and certified more 100,000+ students in the Netherlands, Germany, US, India and UAE, both online and offline. Furthermore, our course designers have supervised projects for companies like Audi, the Dutch military and Lufthansa.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.