Back to course list
- Level: Beginner
- Duration: 01h 52m
- Release date: 2021-04-13
- Author: Sally Norred
- Provider: Lynda
Google Sheets Essential Training
Description
Content
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 you. Whether you’re new to spreadsheets or you’re a longtime Excel user looking for ways to share and collaborate, this web-based spreadsheet offering from Google may be just the app for you.
- Introduction02m 47s
- Get organized with Google Sheets01m 02s
- Importing exercise files to Google Sheets01m 45s
- 1. Getting Started with Google Sheets11m 48s
- What is Google Sheets?03m 19s
- Accessing Google Sheets with your account02m 29s
- Navigating Google Sheets06m
- 2. Creating and Managing Spreadsheets16m 09s
- Creating, naming, and saving a spreadsheet03m 52s
- Copying and renaming a spreadsheet02m 29s
- Moving a spreadsheet02m 04s
- Deleting a spreadsheet02m 31s
- Importing spreadsheets from Excel and OpenOffice03m 36s
- Importing data files01m 37s
- 3. Editing Spreadsheets21m 32s
- Entering and editing cell data05m 35s
- Inserting, deleting, and clearing rows and columns02m 32s
- Moving or copying rows, columns, and cells03m 02s
- Working with multiple sheets03m 44s
- Creating a series of numbers, letters, or dates02m 27s
- Inserting images and hyperlinks04m 12s
- 4. Viewing Spreadsheets11m 29s
- Freezing rows and columns02m 05s
- Hiding rows, columns, and sheets02m
- Using filters and creating filter views04m 04s
- Sorting data on a spreadsheet03m 20s
- 5. Formatting, Printing, and Publishing Spreadsheets11m 17s
- Formatting cells, rows, and columns05m 05s
- Using conditional formatting03m 01s
- Printing a spreadsheet03m 11s
- 6. Working with Spreadsheet Data23m 11s
- See the Sum, Average, Min, Max, or Count03m 48s
- Using formulas and functions05m 52s
- Using IF and nested functions in formulas04m 32s
- Creating charts and graphs04m 12s
- Using pivot tables04m 47s
- 7. Collaborating with Google Sheets12m 43s
- Sharing a spreadsheet with other people04m 45s
- Collaborating and commenting on a spreadsheet04m 41s
- Working with spreadsheet revisions03m 17s
- Conclusion01m 07s
- Additional resources01m 07s
Random courses
- Ethical Hacking: System Hacking
- Quick Start Guide to SQL
- Advanced Agile: The Team's Mindset
- Build an Object Detection Solution with Microsoft Azure Custom Vision Service
- PMI-PBA certification for Business Analyst
- Derivatives - CFA Level 1
- Flutter application ui design with getX
- Governance, Risk, and Compliance for CompTIA Security+
- The Complete Credit Score Strategy (Deluxe)
- S/4 Finance: Fiori Accounts Payable Analytics
Latest courses
- Ember.js: The Documentary
- GraphQL: The Documentary
- AWS Certified Solutions Architect - Professional (SAP-C01) Cert Prep: 1 Design for Organizational Complexity
- CCSP Cert Prep: 4 Cloud Application Security
- What Business Leaders Need to Know about Web3 (+ Metaverse)
- Building No-Code Apps with AppSheet: Implementation
- Automation Anywhere: The Big Picture
- Protective Technology with Apache Kafka
- Coding for Visual Learners: Learning JavaScript from Scratch
- StringBuilder Internals