MS Excel for Research
Learn to organize, clean, and summarize your data in MS Excel.
How do I earn a meta-badge or badge?
To earn the MS Excel for Research meta-badge, you must earn both of the badges below and receive 85%+ on the summary assignment.
To earn a badge, you must attend 90%+ of the workshop session(s) and receive 85%+ on the assignment(s).
MS Excel for Research I
Learn to enter data directly into MS Excel or import data from an external file. Prepare data for analysis using statistical software (e.g. SPSS) and save data securely. Practise setting up your data set with proper variable names, format data values, and recode variables.
MS Excel for Research II
Learn to use mathematical formulas and statistical functions in MS Excel. Check for duplicate data records and create summary tables and graphs.