Super Tuesday Offer Hurry! Offer Ends In Learn More

Data Management & Analysis using MS-Excel

Data Management & Analysis using MS-Excel

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

Training aims

 

Training Aims

The overall aims of the programme are to:

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

Course Objectives

Upon completion of the training programme, the participants would be able to:

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

Why this training?

 

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.

The two-day training programme on Data management Analysis Using MS-Excel is part of Sambodhi's endeavor to enhance understanding of data handling, analysis, and interpretation among practitioners and scholars.

About Us

 

Sambodhi Research & Communications helps create high-impact knowledge to catalyse accountability in public domain. We offer project management, monitoring & evaluation and research solutions to implementers, federal and state governments, bilateral and multilateral aid agencies and corporate philanthropic foundations. Over the past decade, we have pioneered cutting-edge methodologies for evaluation of large-scale interventions across sectors and themes including public health, nutrition, sanitation, natural resources, renewable energy, livelihoods and microfinance.

Sambodhi also works towards enhancing appreciation of evidence-based functioning among development organisations and practitioners. As part of our field-building effort, we co-founded the Community of Evaluators-South Asia (CoE-SA); are home to the South Asian Journal for Evaluation in Practice (SAJEP) – first-of-its-kind peer reviewed journal on evaluation from this region; and have trained more than 5,000 professionals on M&E and related areas.

Course Content

 

  • Day 1
  • Data basics.
  • Data validation
  • Univariate data analysis using formula bar .
  • Bivariate data analysis using formula bar .
  • Day 2
  • Pivot tables and charts .
  • Analysis toolpalk
  • Other useful MS-Excel functions.
  • Data presentation.

Pedagogy

 

In consonance with the programme design, the overarching methodology for delivery of training is based on the principles of participatory adult learning that would build upon the experiential learning of participants. The programme pedagogy focuses on interactive group learning and aims both at knowledge development and skill upgradations through interactive and  peer  learning.  Reading  and  resource  material developed by leading subject experts augments the classroom experience. Training being a mutual learning process, the programme is built on the premise - I hear, I forget; I see, I remember; I do, I understand.

Fee

 

Indian Participants:      INR 10,000 per participant

Foreign Participants:     USD 400 per participant

(The fee covers tuition, reading and resource kit, certification, lunch and refreshments during the program. Participants need to make arrangements for travel and accommodation.)

Discount Structure

  • Early Bird Discounts
  • Registrations are done 30 days prior to commencement of the programme get a discount of 20%
  • Registrations are done 20 days prior to commencement of the programme get a discount of 10%
  • Group Discounts
  • 5 or more participants 20% discount
  • 3 or more participants 10% discount
  • Other Discounts
  • Individuals working with Not-for-profit organizations get an additional discount of 10%
  • Organizations & individuals who have participated in any of our past trainings get an additional discount of 10%

Note: As applicable, 2 or more discounts can be clubbed together.

Fee can be paid by Cheque /Demand Draft in favour of “Sambodhi Research and Communications Pvt. Ltd.” payable at par at New Delhi.

Contact Us

+91-9311291788 | +91-120-4056400-99

Classroom
USD

30 Mar
31 Mar
9:30AM - 5:30PM
400
Sambodhi Research and Communications Pvt Ltd. C-126, Sector-2 Noida

Customer Also Bought

10000 INR |
1020 Leaners
15000 INR |
1288 Leaners
15000 INR |
1005 Leaners
10000 INR |
1009 Leaners
15000 INR |
1274 Leaners
Drop Us a Query