Google Sheets Essential Training: Free Online Course from LinkedIn Learning

Discover how to use Google Sheets to edit spreadsheets and analyze data.

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.

Syllabus

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
- Customizing your printed 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
- Automating tasks with recorded macros
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 Sheets mobile app
- Working with spreadsheets on the Google Sheets mobile app
Conclusion
- Helpful resources

Google Sheets Essential Training

ANIMATIONs

Adobe Lightroom Classic Fundamentals

Build, Train, and Deploy ML Pipelines using BERT

English for Research Publication Purposes

English for Research Publication Purposes

Introduction to Bohemian Watercolor Techniques