Upskill your data analytics and visualization capabilities in this advanced skills course for the online spreadsheet app Google Sheets.
Overview
Syllabus
Introduction
- Course introduction
- Agenda
- Advanced formatting in a Google Sheet
- Conditional formatting
- Activity 1 explained
- Advanced formulas and functions
- Using IF and IFS to analyze data
- Activity 2 explained
- Data validation and named ranges
- Activity 3 explained
- Analyze and report
- Exploring charts
- Activity 4 explained
- Pivot tables
- Create a pivot table
- Activity 5 explained
- Integration and publishing in Google Sheets
- Activity 6 explained
- Macros
- Apply a macro
- Populate data using a Google Form
- Activity 7 explained
- Form settings and sharing a Google Form
- Activity 8 explained
- Managing feedback
- Business challenge overview
- Business challenge explained
- Wrap-up
Taught by
Google Cloud