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