The Fundamentals of Data-driven Storytelling

An IntroduIf it worked for Ection to Data Literacy The Fundamentals of Data-driven Storytelling Procurement Data Crash Course

About this course
- Course Introduction
Module 1 - Find
Module 2 - Get
- 2.1 Turning websites and PDFs into machine readable data
  - Scraping data with Tabula
- 2.2 An introduction to spreadsheet software
Module 3 - Verify
- 3.1 Can I use this data in my work?
  - Initial steps for verification
  - What do these column headings mean?
Module 4 - Clean
- 4.1 What to do with disorganised data?
Module 5 - Analyse
- 5.1 What is the story within the data?
  - Spreadsheet rows, columns, cells and tabs
    Spreadsheet formats, forumlas and essential shortcuts
    Using the VLOOKUP Function
    Combine Data From Multiple Spreadsheets
- 5.2 How to turn numbers into stories
Module 6 - Visualise
Course Testing & Feedback

Powered by GitBook

On this page

Spreadsheet formats, forumlas and essential shortcuts

PreviousSpreadsheet rows, columns, cells and tabs NextUsing the VLOOKUP Function

Last updated 2 years ago

Useful spreadsheet shortcut

Control

Function

Useful spreadsheet formulas

Formula

Function

Ctrl+z

Undo

Ctrl+x

Cut

Ctrl+v

Paste

Ctrl+c

Copy

Shift+Ctrl+arrow

Expand the selection to the last populated cell in the direction of the arrow

=

Indicates the beginning a formula

*

Multiply

/

Divide

+

Add

-

Subtract

Select the top left corner

This will select the whole spreadsheet

=sum()

allows you to add values

=max()

find the maximum value

=min()

find the minimum value

=average()

calculate the average of a set of values

=median()

calculate the median of a set of values (the value in the middle ie half the values are lower than the median & half the values are higher than the median)

=mode()

the most commonly occurring value

=count()

counts the number of vaules