Academic Data Analysis & Visualization in Excel

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