Introduction into Exploring Data

Curriculum

4 Sections
16 Lessons
Lifetime

Expand all sectionsCollapse all sections

A gentle introduction to exploring and understanding your data
What if we told you, there is a quick way, your computer can help you to summarize and understand data? Wouldn’t this be great? Check this course to learn how to use pivot tables to do this!
5
Advanced Spreadsheet Formulas
It's time to go beyond the basics and learn advanced formula tricks. This module will introduce you, among other things, to Vlookup: one of the most powerful spreadsheet formula.
5
An introduction to SQL Databases for analysing data - Part 1
Spreadsheets are really useful, but sometimes they're too limited for what you want to do. Like analysing a very big dataset quickly or gaining complex insights on your data. Here comes the SQL query.
3
An introduction to SQL Databases for analysing data - Part 2
Now that we know the basics of SQL language, we can explore how to use them to analyse a real dataset.
4

Introduction

Let’s continue our journey into spreadsheets. If you already know how to use basic formulas and make use of pivot table wizards, you’re already in a great shape for working with data. But sometimes, you need to be able to work with the data more directly.

In this tutorial, you’ll learn how to make use of rather more complex formulae, including how to join data from multiple spreadsheets into a single sheet as well as how to run database like queries over the data contained in a single spreadsheet.

Lesson objectives

Discover advanced uses of formulas
Learn Vlookup for joining sheets

Lesson requirements

Having followed the first part of the Getting Smart with Spreadsheets module.

And the following:

A google docs account
The spreadsheet with education budgets for local councils in Tanzania – create a working copy!

Adding charts to pivot tables

Introduction into Exploring Data

Curriculum

Introduction

Lesson objectives

Lesson requirements

Modal title