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

Cryptography II
Stanford University via Coursera
Microsoft Enterprise Mobility Suite
Microsoft via edX
Social Media - What No One has Told You about Privacy
openHPI
Windows 10 Features for a Mobile Workforce: Identity Management and Data Access
Microsoft via edX
Health Professional Teaching Skills – Level 3 - Professionalism
University of Toronto via edX