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

Excel 2010
Miríadax Excel Avanzado
Miríadax Problem Solving with Excel
PwC via Coursera Excel: gestión de datos
Universitat Politècnica de València via edX Excel によるデータの分析と可視化
Microsoft via edX