YoVDO

Microsoft Excel - Excel Data Analysis Expert (Accredited)

Offered By: Udemy

Tags

Microsoft Excel Courses Statistics & Probability Courses Data Analysis Courses Correlation Courses Histograms Courses Pivot Charts Courses VLOOKUP Courses Nonlinear Regression Courses

Course Description

Overview

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

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.

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


Taught by

Six Sigma Academy Amsterdam

Related Courses

Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera
Case Study: Net Revenue Management in Excel
DataCamp
Case Study: Net Revenue Management in Google Sheets
DataCamp
Data Analysis in Excel
DataCamp
Data Analysis in Google Sheets
DataCamp