2014
Lynda
Sally Norred
2:50
English
Google Sheets is a feature-rich, cloud-based spreadsheet application that allows you to format and analyze all kinds of data. In this course, author Sally Norred shows you how to get the most from Google Sheets. Discover how to get around the interface, enter and work with data, and use formatting and function features, and learn smart ways to make your data work for you. Plus, see how to work with your spreadsheet data on the go with the Google Sheets mobile app.
Introduction
Welcome
Importing exercise files to Google Sheets
What's new in Google Sheets
1. Getting Started with Google Sheets
What is Google Sheets?
Accessing Google Sheets with your account
Understanding common Google Sheets terminology
Navigating Google Sheets
2. Creating Spreadsheets
Creating, naming, and saving a spreadsheet
Renaming a spreadsheet
Copying a spreadsheet
Moving a spreadsheet
Deleting a spreadsheet
Importing and converting Excel or OpenOffice spreadsheets
Importing and converting .csv, .tsv, .tab, and .txt data files
3. Editing Spreadsheets
Entering and editing cell content
Inserting, deleting, and clearing rows and columns
Moving rows, columns, and cells
Working with multiple sheets
Using keyboard shortcuts
Creating a series of numbers or dates
Using Find and Replace
Entering hyperlinks
Inserting images into spreadsheets
4. Viewing and Printing Spreadsheets
Using the View menu
Freezing rows and columns
Hiding rows, columns, and sheets
Publishing a spreadsheet to the web
Printing a spreadsheet
5. Formatting Spreadsheets
Formatting cell, row, and column data
Google Sheets formatting tips
Using conditional formatting
Creating a spreadsheet from a template
6. Working with Spreadsheet Data
Sorting data on a spreadsheet
Using Quick Sum
Using formulas and functions
Using IF functions and nested functions
Referencing data from other sheets
Creating charts in Google Sheets
Using filters and creating filter views
Using pivot tables
7. Collaborating with Google Sheets
Sharing a spreadsheet file with other people
Working with Google Sheets that are shared with you
Working with spreadsheet revisions
Commenting on a spreadsheet
Emailing spreadsheet collaborators
Collaborating simultaneously and using Google Chat
8. Using the Google Sheets Mobile App
Installing the Google Sheets mobile app
Navigating the Google Seets mobile app
Working with spreadsheets on the Google Sheets mobile app
Conclusion
Helpful resources
Download File Size:287.43 MB
|
