Please complete the following activities:

• Enter date data into rows & columns: https://uviclibraries.github.io/excel/basics-data-cleaning.html
• Name and identify rows & columns: https://smallbusiness.chron.com/give-name-columns-excel-73447.html
• Sort data, using the filter button: http://bit.ly/2I3qI6N
• Change categorical data (e.g., male, female) into numerical data (e.g., 1, 2): https://uviclibraries.github.io/excel/basics-data-cleaning.html
• Use the following functions: SUM, SUMIF, INT, COUNTA, COUNTIF, VLOOKUP, CONCATENATE, VALUE, LEN: https://uviclibraries.github.io/excel/intro-functions.html
• Track changes in Excel: https://support.microsoft.com/en-us/office/track-changes-in-a-shared-workbook-22aea671-cac7-4fa3-845d-eeb23725bd15
• Use these statistical functions: AVERAGE (Mean), Standard Deviation, MEDIAN, MODE, COUNT, Standardize, Sample Variance, Kurtosis, Skew, MIN, MAX, Range: https://uviclibraries.github.io/excel/statistical-functions.html
• Produce basic graphs, histograms and scatterplots and edit them (e.g., add title, change axes names, colours, sizing etc): https://uviclibraries.github.io/excel/charting-graphs.html

Live Demonstrations

• Copy and paste a bunch of rows and columns into another worksheet (maybe the same as #1 on the list above?)
• With 2 open workbooks, move a tab/worksheet from one workbook to another (they will export a file and then add it to a template workbook – they should understand copying a worksheet/tab versus/and moving a worksheet/tab), move a tab within a workbook, rename a tab
• Create a new tab/worksheet
• Set up formulas that cross tabs/worksheets, i.e. link to another sheet using “=”
• Understand how an “IFS” statement works. They will not need to set one up, but they will use a template that has an IFS function: https://uviclibraries.github.io/excel/intro-functions.html