Data skills workshop

Turn a messy spreadsheet into analysis-ready data.

A live, hands-on day for scholars, faculty and programme staff who collect data in Excel and lose hours cleaning it.

Live online
One day · 5–6 hours
Hands-on
Recording + e-certificate

Batches on request · ₹999 per participant

Request this workshop Ask a question

Built for people who need this on Monday.

Who it's for

PG, MD and PhD scholars with survey or hospital data
Faculty handling departmental data and reports
Public-health and NGO staff tracking programme indicators

What you leave with

A clean, validated dataset ready for SPSS, R or STATA
Pivot-table summaries you can rebuild in minutes
Publication-quality charts that follow journal style

What we cover, step by step.

1
Data entry done right
Tidy structure, data validation, drop-downs and codebooks that prevent errors at source.
2
Cleaning at speed
TRIM, PROPER, Text-to-Columns, Flash Fill, find-and-fix duplicates and missing values.
3
Formulas that do the work
IF, IFS, COUNTIFS, SUMIFS, XLOOKUP and date functions on real research data.
4
Pivot tables & summaries
Frequency tables, cross-tabs and grouped summaries — refreshed in one click.
5
Charts for papers
Clean bar, line and box-style charts; export at print resolution.
6
Hand-off to statistics
Descriptive statistics with the Analysis ToolPak and preparing files for SPSS / R / STATA.

Bring: A laptop with Microsoft Excel 2016 or later (Excel 365 recommended). Practice datasets are provided.

Your trainers.

Dr. Jyoti Ranjan Mohanty

Editor-in-Chief, UJHSE

15+ years in public-health programmes and M&E
State M&E Manager, HLFPPT–SSHAKTI (Global Fund)
PhD & M.Phil (Public Health) · MPH

Dr. Paramjot Panda

Founder, Utkarsh Research Network

Cochrane Collaborator
Contributor to the Global Burden of Disease study (The Lancet)
PhD · MPH (Manipal & Maastricht)

₹999 per participant

Live hands-on session with both trainers
Practice files and templates to keep
Session recording
E-certificate of participation

Batches run on request.

Request this workshop

No payment now — we reply within 24 hours with dates.

Questions.

How is the workshop delivered?

Live online in one day (about 5–6 hours with breaks). The joining link is emailed to you before the session.

Will I get a recording and certificate?

Yes. Registered participants receive the session recording and an e-certificate of participation.

What if I cannot attend after paying?

Tell us more than 7 days before the session for a 90% refund or a free move to the next batch; 3–7 days before for 50% or a move. Full terms are on the refund policy page.

Do I need to know Excel already?

Basic familiarity is enough — you should be able to open a file and type into cells. We build from there.

Will it work on a Mac?

Yes. Excel for Mac covers everything we teach; a few menu locations differ and we point them out.

Refund policy