1.00
(1 Rating)

Data, Statistical & Research Analysis with Microsoft Excel complete master class course.

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

A complete guide into statistical & research analysis.

Highlights:

Statistical calculations, Demographic analysis, Statistical charts, Research, Survey, Questionnaires, Inferences, Statistical tests, Hypothesis.

Statistical & Research analysis is the science of investigating trends, patterns, and relationships using quantitative data.
Also, It is an important and demanding skill used by scientists, governments, businesses, academic institutes, and other organizations.

In addition, this course provides the most complete, detailed, interactive, and practical training on Statistical & Research Analysis with Microsoft Excel.

The course is divided into six (6) practical sections;

1. Basic Statistical Calculations

2. Statistical Charts and maps

3. Demographic/Population Analysis/Dashboard

4. Descriptive statistics

5. Research analysis & Questionnaires

6. Statistical tests.

Serving as a Guardian for you to know how to make witted summation aiding your statistical efficiency.

Show More

What Will You Learn?

  • How to perform various statistical tests with the ability to understand when to reject or accept the Null and Alternative hypotheses
  • Perform descriptive statistics for surveys and questionnaires
  • Source and analyze web data and ability to administer online surveys
  • Transform demographic information into interactive dashboards.
  • Transform statistical data into meaningful charts and visualizations.
  • Ability to perform basic statistical calculations to draw meaningful inference
  • Understand the basic of Microsoft Excel for Statistical & Research Analysis

Course Content

INTRODUCTION TO DATA ANALYSIS
In This Free Course, You Will Learn How To Discuss strategies to deal with special and common cause variations Identify data performance tools like the Pareto chart, histogram, run chart, and control chart Explain the structures of performance management Differentiate between the "voice of the customer" and the "voice of the people" Describe how to use data to drive improvement in your business Explain special cases where the method for creating a control chart changes

  • Introduction to Data Analysis
    00:00
  • Agenda and Principles of Process Management
    06:28
  • The Voice of the Process
    04:36
  • Working as One Team for Improvement
    00:00
  • Exercise: The Voice of the Customer and the Voice of the Process
    00:00
  • An Introduction to Performance Data Tools for Data Analysis that Works
    00:00
  • The Pareto Chart: Highlighting Priorities
    00:00
  • The Histogram: Showing the Range Performance
    00:00
  • The Run Chart: Showing Performance Over Time
    00:00
  • Exercise: Presenting Performance Data
    00:00
  • Understanding Variation
    00:00
  • The Control Chart Highlighting the Variation in the Data
    00:00
  • Control Chart Example
    00:00
  • Control Chart Special Cases
    00:00
  • Interpreting the Control Chart
    00:00
  • Exercise: The Control Chart
    00:00
  • Strategies to Deal with Special Cause and Common Cause Variation
    00:00
  • Using Data to Drive Improvement
    00:00
  • A Structure for Performance Management
    00:00
  • Exercise: Data Analysis
    00:00
  • Project: Making a Start with Data Analysis and Performance Management
    00:00
  • Test your Understanding
    00:00
  • Introduction to Data Analysis
  • Module Summary
    00:00

MODULE 1: SORTING, FILTERS & PIVOTAL TABLES
PivotTables,cleaning and preprocessing raw & dynamic data analysis.

MODULE 2: VLOOKUP, HLOOKUP AND GOAL SEEK

MODULE 3: FORMULAS AND PIVOT TABLES
In This Free Course, You Will Learn How To List the most frequently used lookup and decision formulas Outline the methods for creating and applying formulas in a spreadsheet to locate specific data Identify the correct formula for calculating a specific value, counting cells, or adding the provided data Explain the syntax of several new Excel functions Discuss the concept of named ranges Outline the tools that can be used to customize the named ranges Recognize the range operators that appear in the formula syntax Describe the operations that may be performed within an Excel table Discuss the mechanics of a pivot table and its capabilities Summarize the steps for counting, averaging, and running totals with pivot tables Explain how to use filters, slicers, timelines, and pivot charts to display dynamic views of data Describe the process of creating a pivot chart

MODULE 4: ADVANCED EXCEL FORMULA TOOLS

MODULE 5: ADVANCED EXCEL PIVOT TABLES

MODULE 6: FORMULA FUNCTIONS IN EXCEL DASHBOARDS

MODULE 7: EXCEL TABLES AND FUNCTIONS

MODULE 8: CREATING AN INTERACTIVE DASHBOARD

MODULE 9: DATA VISUALIZATION IN EXCEL

Student Ratings & Reviews

No Review Yet
No Review Yet
Scroll to Top