Navigating Google Sheets

Introduction to Google Sheets

James Chapman

Curriculum Manager, DataCamp

Google Sheets

 

  • Millions of users worldwide
  • Intuitive interface
  • Extract insights with a few clicks!

The Annual financial data template, available on Google Sheets.

1 Annual financial data template from Google Sheets
Introduction to Google Sheets

Coming Up...

 

Chapter 1

 

  • Adding data to spreadsheets
  • Creating formulas
  • Formatting cells

 

Chapter 2

 

  • Cell references
  • Including cell references in formulas
  • Absolute references
Introduction to Google Sheets

Opening Google Sheets

  • To open an existing spreadsheet: File > Open

The open button inside the File menu in the toolbar.

Introduction to Google Sheets

Importing data

  • To import data: File > Import
  • Can import many different file types, including: .csv, .txt, .tsv, .xlsx

The importing data menu.

Introduction to Google Sheets

Navigating Google Sheets

  • Google Sheets store tabular data
  • Data is stored in individual cells
  • Cells can contain data or perform calculations

A spreadsheet showing financial information, where cell B3 is highlighted, and contains the value 2000 dollars.

Introduction to Google Sheets

Cell addresses

  • Cells can be uniquely identified by a column (letters) and row label (numbers)
  • Cell addresses combine the column and row label
  • Example: the value of $2,000 is found in cell B3

A spreadsheet showing financial information, where cell B3 is highlighted, and contains the value 2000 dollars.

Introduction to Google Sheets

Adding and amending data

  • Select the cell to add or amend, and type the new value

Adding data to a blank cell, then amending data in an existing cell.

Introduction to Google Sheets

Cell ranges

  • A cell range defines a rectangular group of cells
  • Example: Column C between rows 2 and 5 → C2:C5

The cell range C2 to C5 is highlighted in the spreadsheet.

Introduction to Google Sheets

Cell ranges

  • For groups across columns, define the range from top-left to bottom-right
  • Example: Columns C and D between rows 2 and 5 → C2:D5

The cell range C2 to D5 is highlighted in the spreadsheet.

Introduction to Google Sheets

Cell ranges

  • For groups across columns, define the range from top-left to bottom-right
  • Example: Columns C and D between rows 2 and 5 → C2:D5

The cell range C2 to D5 is highlighted in the spreadsheet, and the box in the top-left corner of the spreadsheet shows the correct range.

Introduction to Google Sheets

Let's practice!

Introduction to Google Sheets

Preparing Video For Download...