YoVDO

Google Sheets Quick Tips

Offered By: LinkedIn Learning

Tags

Google Sheets Courses Data Visualization Courses Data Protection Courses Data Manipulation Courses

Course Description

Overview

Get quick, bite-sized answers that tell you exactly what you want to know about working with Google Sheets.

Syllabus

Introduction
  • Calculate data quickly with Google Sheets
1. Google Sheets Quick Tips
  • Text wrap
  • Add and reference sheets
  • Change view options
  • Freeze and lock panels
  • Fill in a series of data
  • Select specific rows or columns
  • Move rows or columns
  • Quickly insert multiple rows and columns
  • Rotate cell data
  • Copy cell formatting
  • Create a named range
  • Create and manage drop-down lists
  • Merge cells
  • Explore data
  • Hide and unhide columns, rows, and sheets
  • Protect an entire sheet
  • Summing rows
  • Adjust row height and column width
  • Apply conditional formatting
  • Insert a link into a cell
  • Change sort order
  • Align cells
  • Filter views
  • Download as Excel format
  • Convert an Excel file to Sheets
  • Rename and move a sheet
  • Share a file
  • View version history
  • Undo unwanted changes
  • Set alternating colors

Taught by

Jess Stratton

Related Courses

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent