Get this course

Working with Data

Google Sheets Training


Description
Learn how to organize and analyze data in Sheets, the popular spreadsheet tool from Google. This 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.
Content
  • 1. Get organized with Google Sheets
  • 2. Importing exercise files to Google Sheets
  • 3. What is Google Sheets
  • 4. Accessing Google Sheets with your account
  • 5. Navigating Google Sheets
  • 6. Creating, naming, and saving a spreadsheet
  • 7. Copying and renaming a spreadsheet
  • 8. Moving a spreadsheet
  • 9. Deleting a spreadsheet
  • 10. Importing a spreadsheets from Excel and OpenOffice
  • 11. Importing data files
  • 12. Entering and editing cell data
  • 13. Inserting, deleting, and clearing rows and columns
  • 14. Moving or copying rows, columns, and cells
  • 15. Working with multiple sheets
  • 16. Creating a series of numbers, letters, or dates
  • 17. Inserting images and hyperlinks
  • 18. Freezing rows and columns
  • 19. Hiding rows, columns, and sheets
  • 20. Using filters and creating filter views
  • 21. Sorting data on a spreadsheet
  • 22. Formatting cells, rows, and columns
  • 23. Using conditional formatting
  • 24. Printing a spreadsheet
  • 25. See the Sum, Average, Min, Max, or Count
  • 26. Using formulas and functions
  • 27. Using IF and nested functions in formulas
  • 28. Creating charts and graphs
  • 29. Using pivot tables
  • 30. Sharing a spreadsheet with other people
  • 31. Collaborating and commenting on a spreadsheet
  • 32. Working with spreadsheet revisions
  • QUIZ
Completion rules
  • All units must be completed
Back