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
Google Sheets Essential Training at Linkedin Learning Course details
- 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