Part 2

This is the second part of the Excel workshop series. It is designed for intermediate users who feel comfortable with basic Excel commands (sorting, filtering, absolute and relative references, basic visualizations), but participants of all skill levels are welcomed. We will walk you through the process of importing, cleaning, and exploring a large dataset, while demonstrating some of the less known Excel’s capabilities, including OCR, macros, statistical analysis tool pack, and many other time-saving features.

Download data (.zip)

Microsoft 365 Office for UBC students

The first part of workshop series is recommended for people who are unsure about their Excel abilities:

Part 1 of the Excel series

Learning objectives

At the end of this workshop, you will be able to:

1. Work with non-standart data types (csv, data from images), several sheets and large datasets in Excel;
2. Use Excel’s capabilities for data cleaning and exploratory analysis;
3. Perform statistical tests (ANOVA and t-test), summarise and visualize your results

Schedule

Links:

• Data Description
• Tasks
  • Introduction
  • Data Operations
  • Data Exploration
  • Statistical Tests and Formulas
  • Summaries and Visuals

---

Table of contents

• Data Description
• Tasks

---