YoVDO

Connected Sheets: Qwik Start

Offered By: Google via Google Cloud Skills Boost

Tags

Google Sheets Courses Data Analysis Courses Data Visualization Courses BigQuery Courses Pivot Tables Courses Calculated Columns Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Connected Sheets, you can analyze billions of rows and petabytes of data in Google Sheets without specialized knowledge of computer languages like SQL. In this hands-on-lab, you will learn how to connect a BigQuery dataset to Google Sheets and analyze your data.

Syllabus

  • GSP870
  • Overview
  • Setup and requirements
  • Task 1. Open Google Sheets
  • Task 2. Connect to a BigQuery dataset
  • Task 3. Formulas
  • Task 4. Charts
  • Task 5. Pivot tables
  • Task 6. Using Extract
  • Task 7. Calculated columns
  • Task 8. Refresh all / Scheduled refresh
  • Congratulations!

Tags

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX