Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy Coaching CBT Cognitive Behavioral Therapy
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing Startup YouTube Marketing
2022-06-04T12:48:51Z

BusinessBusiness Analytics & IntelligenceExcel

Microsoft Excel: Practical MS Excel + MS Excel data analysis

Practical MS Excel. Fast MS Excel mastery. Fun MS Excel. Data analytics with Microsoft Excel. All MS Excel versions OK.
Rating: 4.7 out of 54.7 (1,585 ratings)
8,437 students
Created by Six Sigma Academy Amsterdam
Last updated 6/2022
English
English

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)

Requirements

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

Description

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:

  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

PART 2

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

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

Instructor

Six Sigma Academy Amsterdam
BKO accredited university lecturers following ASQ guidelines
Six Sigma Academy Amsterdam
  • 4.6 Instructor Rating
  • 33,673 Reviews
  • 83,742 Students
  • 8 Courses

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.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.