Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Google Sheets Advanced Tips and Tricks

via LinkedIn Learning

Overview

Get advanced tips and tricks to boost your productivity in Google Sheets, from creating interactive charts and surveys to applying conditional formatting.

Get the most out of Google Sheets. Author Jess Stratton provides helpful tips and tricks to boost your productivity, from leveraging Google's wide array of templates and sharing spreadsheets to creating interactive charts and applying conditional formatting. Learn how to use powerful formulas and functions, add data validation, create surveys and charts, and expand the functionality of Google Sheets with add-ons.

Syllabus

Introduction
  • Welcome
  • What you should know before watching this course
1. Work with Spreadsheets
  • Browse the template gallery to get started
  • Download or email as a Microsoft Excel or PDF file
  • Protect the sheet against unwanted changes
  • Change a sheet name and reference data
2. Work with Columns, Rows, and Cells
  • Split and bring together names in columns
  • Resize, rearrange, and add columns and rows
  • Use conditional formatting in cells
  • Add data validation and dropdown lists
  • Use the image function to easily add images to cells
  • Add a line break in a cell
3. Work with Charts
  • Insert a gauge chart for status updates
  • Create an interactive geochart
  • Add estimate data to Google charts
  • Publish a chart to a website
  • Add an additional Y-axis to a chart
4. Use Google Sheets with Other Google Products
  • Use Google Forms to create surveys
  • Use IFTTT with Google Sheets
  • Browse the add-on library
  • Insert a drawing into a Google Sheet
  • Receive email notification when a change is made
  • Convert Excel files to Google Sheets from Drive
Conclusion
  • Next steps

Taught by

Jess Stratton

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Google Sheets Advanced Tips and Tricks

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free