This course is designed to introduce students to the fundamental concepts of using Microsoft Excel for data analysis. Through a series of practical exercises and examples, students will learn how to use Excel to import, organize, clean, and analyze data to gain insights and make informed decisions.
What Will You Learn?
- Understand the basic features and functions of Excel for data
- Learn how to import and organize data in Excel.
- Learn how to clean and manipulate data for analysis.
- Learn how to perform basic statistical analysis and data visualization in Excel
Module 1: Introduction to data analysis
Introduction to data analysis22:36
Module 2: Importing data from different sources in excel, sorting, organizing & grouping data
Importing data from different sources in excel, sorting, organizing & grouping data09:17
Module 3: Handling Data Anomalies
Handling Data Anomalies14:50
Module 4: Basic Statistical Analysis
Basic Statistical Analysis (PDF)00:00
Creating Charts & Graphic in Excel23:28
Module 5: Data Modeling and Forecasting
Data Modelling in Excel11:18
Data modelling conclusion01:01
Data Analysis Bonuses
Answer the following questions