Linkedin Learning
Linkedin Learning Logo

Google Sheets Essential Training 

  • Offered byLinkedin Learning

Google Sheets Essential Training
 at 
Linkedin Learning 
Overview

Duration

2 hours

Total fee

1,400

Mode of learning

Online

Difficulty level

Beginner

Credential

Certificate

Google Sheets Essential Training
 at 
Linkedin Learning 
Highlights

  • Earn a sharable certificate
  • 1 exercise file
  • 7 quizzes
  • Access on tablet and phone
Read more
Details Icon

Google Sheets Essential Training
 at 
Linkedin Learning 
Course details

More about this course
  • Learn how to organize and analyze data in Sheets, the popular spreadsheet tool from Google
  • Instructor Sally Norred starts with a tour of the Sheets interface, then shows how to enter and work with data
  • Sally demonstrates the formatting and formula/function features, shows off the collaboration tools in Sheets, and provides smart ways to make your data work for learner

Google Sheets Essential Training
 at 
Linkedin Learning 
Curriculum

Introduction

Get organized with Google Sheets

Importing exercise files to Google Sheets

Getting Started with Google Sheets

What is Google Sheets?

Accessing Google Sheets with your account

Navigating Google Sheets

Creating and Managing Spreadsheets

Creating, naming, and saving a spreadsheet

Copying and renaming a spreadsheet

Moving a spreadsheet

Deleting a spreadsheet

Importing spreadsheets from Excel and OpenOffice

Importing data files

Editing Spreadsheets

Entering and editing cell data

Inserting, deleting, and clearing rows and columns

Moving or copying rows, columns, and cells

Working with multiple sheets

Creating a series of numbers, letters, or dates

Inserting images and hyperlinks

Viewing Spreadsheets

Freezing rows and columns

Hiding rows, columns, and sheets

Using filters and creating filter views

Sorting data on a spreadsheet

Formatting, Printing, and Publishing Spreadsheets

Formatting cells, rows, and columns

Using conditional formatting

Printing a spreadsheet

Working with Spreadsheet Data

See the Sum, Average, Min, Max, or Count

Using formulas and functions

Using IF and nested functions in formulas

Creating charts and graphs

Using pivot tables

Collaborating with Google Sheets

Sharing a spreadsheet with other people

Collaborating and commenting on a spreadsheet

Working with spreadsheet revisions

Conclusion

Additional resources

Other courses offered by Linkedin Learning

– / –
1 hours
Intermediate
899
1 hours
Intermediate
– / –
1 hours
Advanced
1.85 K
1 hours
Intermediate
View Other 504 CoursesRight Arrow Icon
qna

Google Sheets Essential Training
 at 
Linkedin Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...