Data Analysis with Excel
- Pre-workshop activities: 10 min
- Introductory presentation: 10 min
- Hands-on activities - Introduction: 50-80min
- Hands-on activities - Intermediate: 30-60min
How can Excel make my life easier?
Excel is powerful tool which can help you collect data, analyse it, and visualize the resulting information. Excel can help you not only in a workplace, but also in your school work and research, as it can help you organize many types of information and data (such as financal, organizational or research data for example), and can help you quicly create a variety of reporting elements like tables, graphs and charts. The ability to use spreadsheets effectivlty will help you in your school work, research projects, jobe searches, and career.
Learning objectives
Introductory Excel
At the end of the Introductory portion of this workshop, you will be able to:
- Enter date data into rows & columns
- Name and identify rows & columns
- Sort data, using the filter button
- Find and replace data (data cleaning) & know when Open Refine would be a more appropriate tool.
- Change categorical data (e.g., male, female) into numerical data (e.g., 1, 2)
- Use the following functions: SUM, SUMIF, INT, COUNTA, COUNTIF, VLOOKUP, CONCATENATE, VALUE, LEN.
- Track changes in excel
- Use these statistical functions: AVERAGE (Mean), Standard Deviation, MEDIAN, MODE, COUNT, Standardize, Sample Variance, Kurtosis, Skew, MIN, MAX, Range.
- Produce basic graphs, histograms and scatterplots and edit them (e.g., add title, change axes names, colours, sizing etc)
Intermediate Excel
At the end of the Intermediate portion of this workshop, you will be able to:
- Create a basic pivot table and pivot chart
- Automate a series of tasks in a spreadsheet using a macro
- Create a Dashboard information summary sheet based on data from another sheet
NOTE: You can earn DSC Badges by completing the Introductory and/or the Intermediate portions of this workshop.