Data Management & Analysis using MS-Excel

COURSE DESCRIPTION

The two-day training program on Statistical Data Management & Analysis using MS-Excel is part of Sambodhi’s endeavor to enhance understanding of research in general and data analysis in particular among practitioners and scholars.

An enormous amount of data is generated by corporations, institutions, and governments every day. However, this data by itself in its raw form is of limited utility. If analyzed properly and transformed into relevant information it can provide valuable insights and facilitate effective strategies and actions. Managers in the modern-day organization have to be well versed in the art and science of evidence-based decision-making – using data for knowledge discovery. As the most commonly used spreadsheet, MS-Excel is the handiest tool for managers in facilitating everyday data analysis. Professionals well versed in MS-Excel can greatly enhance the effectiveness of data-based analytics in a cost-efficient manner.

TRAINING AIMS

1. Develop a shared understanding of the fundamentals of data and data analysis
2. Develop skills to understand what type of analysis is used in which circumstances.
3. Develop skills for using various MS-Excel functions for undertaking basic and advanced data analysis.
4. Develop skills for effective presentation and visualization of data in MS-Excel.

LEARNING OBJECTIVE

1. Describe the fundamentals of data and data analysis.
2.  Undertake data validation using MS-Excel.
3.  Create pivot tables and pivot charts using a relevant dataset.
4.  Perform descriptive analysis, correlation, and regression using the Formula bar and Analysis ToolPak.
5.  Use other common functions in MS-Excel.
6.  Interpret and Present analysis in a simple and intelligible manner for informed decision making