Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Microsoft Excel: Practical MS Excel + MS Excel data analysis

via Udemy

Overview

Practical MS Excel. Fast MS Excel mastery. Fun MS Excel. Data analytics with Microsoft Excel. All MS Excel versions OK.

What you'll learn:
  • How to work with Excel in general (version is not very important)
  • Statistical theory for data analysis
  • How to apply the statistical theory for data analysis in MS Excel 2016 (other versions are also fine)

WHYCHOOSEUS?

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:

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

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

PART2

In part two, you will learn the theory of statistical techniques for data analysis. You do not need any statistical or mathematical background. Subsequently, you learn how to execute these 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

Taught by

Six Sigma Academy Amsterdam

Reviews

Start your review of Microsoft Excel: Practical MS Excel + MS Excel data analysis

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.