Data Exploratory and Data Handling using Pivot Table (1.5 hours)
The participants will be exposed to excel spreadsheets and will learn how to work with the formulas and functions. For exploring and data handling, participants will be introduced to pivot tables as a data summarization tool. It is one of the most important and widely used features available in Excel.
Descriptive Analysis and Excel Charting (2 hours)
In this session, participants will be guided to basic descriptive statistics such as statistics summary and how to visualize data as appropriate graphics.
Data Analysis (2.5 hours)
Participants will explore the data analysis tools available in Excel to conduct data analysis such as a simple hypothesis testing, correlation and regression analysis.