excel data cleaning data pre-processing data analysis statistical analysis data visualization

• Excel Spreadsheets Basics
• Data Analysis in Nutshell
• Data Cleaning & Pre-Processing
• Data Analysis in Excel
  • Statistical Analysis
• Data Visualization

• Manipulation data
• Analyze data
• Visulize data
• Limited number of users
• Not for big data / large datasets but Hadoop or Spark can

• Tidy data (Tabular / meaningful data)
• Unique ID
• Remove duplicates
• Missing data
• Validate data types
• Homogeneity of data

• Data Manipulation
  • Updating, Sorting & Filtering data
• Statistics Functions in Excel
  • SUM/AVERAGE/MEDIAN/MODE
  • MIN/MAX/RANGE/IQR
  • VARIANC/STANDARD DEVIATION
  • Z.TEST, T.TEST
• Conditional Functions
  • COUNTIF/SUMIF/AVERAGEIF
  • VLOOKUP
• PIVOT Table may be a course alone

• Excel workbook is considered as a book includes sheets or pages.
• Tidy data how to arrange and organize data?
• Clear format
• Remove duplicates
• Unique IDs
• Validate data types
• Dealing with missing data
• Homogeneity of data التناغم
• GIGO Garbage In Grabage Out Concept So The data to enter analysis phase must be cleaned
• analyze data
• Sort data A-Z Or Z-A
• Filter data data tap
• Descriptive statistics
• Variance of population VARP

• Instructor Mustofa Osman
• course https://www.youtube.com/watch?v=9Z5MPeyuLhg