Dr. Md. Mijanul Haque

Academic Data Analysis & Visualization in Excel

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Course overview:

  • CLASS 1 : Introduction to Excel
    • What is Excel
    • Excel interface
    • Excel functions & formulas
    • Pivot table & power pivot
  • Class 2 : Data Entry, Cleaning & Preparation 
    • Data entry
    • Data cleaning
    • Data preparation
  • Class 3 : Basic statistics for academic data analysis
    • Descriptive statistics
    • Inferential statistics
  • Class 4 : Descriptive Statistics 
    • Mean
    • Median
    • Mode
  • Class 5 : Inferential Statistics
    • t-test
    • Chi square test
    • ANOVA
  • Class 6 : Data Visualization Techniques
    • Table
    • Charts
    • Boxplot
  • Class 7 : Case Study & Hands-On Project
    • Project 1
    • Project 2
  • Class 8 : Use of AI in Excel

 

Course Content

Introduction to Excel
Introduction to excel for academic purpose.

  • Data cleaning

Student Ratings & Reviews

No Review Yet
No Review Yet