CENTER FOR ANALYTICS SERVICES
1
INTRO TO EXCEL, GOOGLE SHEET AND DATA PREPARATION
Overview
Center for analytics services
In this module, we focus on developing essential data and spreadsheet skills in Google Sheets.
Before we can start our exploration of data, we will need to do the following:
The tool we will be using in Preparing data:
2
Log into our existing Google account.
Create a new Google account.
OR
Access the data for the specific walk-throughs and learning activities.
Download and access all data for Preparing data.
OR
Google account
Center for analytics services
Logging into an existing Google account:
In order to use Google Sheets, we will need to have a Google account since our spreadsheets will be created and edited in the Google Drive linked to this account.
3
03.
|
Google account
Center for analytics services
Creating a new free Google account:
4
02.
Accessing the data
Center for analytics services
There are multiple ways to access the data we need for this module, but all of the methods will require you to add the CSV and XLSX files to our Google Drive.
Accessing a ZIP, CSV, or XLSX (spreadsheet) file for a specific walk-through:
5
01.
|
Accessing the data
Module overview: Preparing data
Downloading or opening CSV files:
6
03.
04.
05.
Accessing the data
Center for analytics services
Downloading or opening XLSX (spreadsheet) files:
7
03.
05.
06.
Accessing the data
Center for analytics services
Downloading the entire module’s datasets and spreadsheets as a ZIP archive:
8
01.
02.
Navigating Google Drive
Center for analytics services
Google Drive is a cloud-based file storage service that allows us to store, access, and manage files in real-time. Our Google Sheet files are saved on Drive, which means any updates we make automatically get synced and saved in the cloud.
9
03.
04.
|
Navigating Google Drive
Center for analytics services
Uploading and accessing the entire module’s datasets and spreadsheet files:
10
01.
03.