Getting Comfortable with Data : Part 2 Introduction to Spreadsheets

Introduction to Spreadsheets | Create Sheet

Introduction to Spreadsheets | Upload .CSV

Finding Data Part 2: A crash-course in less official ways to find data

Finding Data | Google Advanced Search | site:

Finding Data | Google Advanced Search | filetype:

Finding Data | Google Advanced Search | –

Finding Data | Google Advanced Search | Double Modifiers

Finding Data | Google Advanced Search | Advanced Search Tool

Finding Data | Google Tables

Finding Data | Google Public Data Explorer

Getting Comfortable with Data : Part 3 Troubleshooting Messy Data

Troubleshooting Messy Data | Clear Formatting

Troubleshooting Messy Data | Resize Columns and Text Wrapping

Troubleshooting Messy Data | Find and Replace

Troubleshooting Messy Data | TRIM

Troubleshooting Messy Data | Text to Column

Troubleshooting Messy Data | LEFT / RIGHT Functions

Troubleshooting Messy Data | OpenRefine

Getting Comfortable with Data : Part 4 Finding Insights in Data

Finding Insights in Data | Sort

Finding Insights in Data | Filter

Finding Insights in Data | Conditional Formatting

Finding Insights in Data | Basic Statistics

Finding Insights in Data | Calculate Percentage / Rate

Finding Insights in Data | Decimal Points

Finding Insights in Data | IFS Function

Finding Insights in Data | Pivot Tables

Data Visualisation Tools Creating simple data visualisations

Data Visualisation | Infogram

Data Visualisation | Datawrapper

Data Scraping – Scraping data from pdfs and websites

Data Scraping | Tabula

Data Scraping | Cometdocs

Our Mission

To boost analytical, evidence-based public discussion
by giving citizens, journalists and civil society
access to the data, digital tools, and computational skills
necessary for transforming our societies into digital democracies.