22NTC Session: IT
Spreadsheets Are Still Ok: Restructuring and Cleaning Data
Submitted by: Oz du Soleil

Description

Spreadsheets get a bad name, but the reality is a lot of data is still in spreadsheets. Alternatives like databases and external services can sometimes be overkill for certain tasks. It all depends on what you’re trying to do–and sometimes the challenge is to merge a lot of data from multiple spreadsheets to then load everything into a database.

Sometimes we download a report into a spreadsheet, and it’s easy for a human to read, but it can’t be sorted or filtered. How can the data be restructured and made useful?

In this session, we’ll go through some common, real world needs that can be solved inside a spreadsheet.


Session Type

30 minute session

Learning Outcomes

  • Restructure reports so that they can be sorted, filtered and analyzed.
  • Examine data for quality
  • Write formulas

Target Audience

Fundraisers, event planners, marketers, and anyone else working with data in spreadsheets
Details

Day

Friday
March 25, 2022

Time

12:15pm – 12:45pm PST