Monthly Subscription Starting at AED 99 + VAT

Doing more with Google Sheets
  • Level Foundation
  • المدة 5 ساعات hours
  • الطبع بواسطة Google Cloud
  • Offered by

عن

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk—or from your smartphone or tablet on-the-go—Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets, incorporating powerful functions and visualizations to accelerate your data analysis and share meaningful insights with your team. Follow along with exercises and a companion spreadsheet to practice new skills as you encounter them. About the Instructor Malia is a tech professional based in Los Angeles who uses Google Workspace and Google Sheets everyday to manage projects, collaborate with remote teams, and make data-driven decisions.

الوحدات

Welcome to the course!

    • 1 Videos
Show info about module content

1 Videos

  • Meet the instructor

Create a new spreadsheet

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Create a new spreadsheet

1 Readings

  • Movie Data Spreadsheet

Edit your spreadsheet

    • 1 Videos
Show info about module content

1 Videos

  • Edit your spreadsheet

Duplicate, print, or publish your spreadsheet

    • 1 Videos
Show info about module content

1 Videos

  • Duplicate, print, or publish your spreadsheet

Use some basic keyboard shortcuts

    • 1 Videos
Show info about module content

1 Videos

  • Use some basic keyboard shortcuts

Review your knowledge

    • 1 Readings
Show info about module content

1 Readings

  • How to create, edit, and print your spreadsheet

Test your knowledge

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • How to create, edit, and print your spreadsheet

1 Videos

  • Test time - now it's your turn!

2 Readings

  • Test resources
  • Test answer key

Check-in with the instructor

    • 1 Videos
Show info about module content

1 Videos

  • Welcome to “Working with formulas and functions”

Import data to your sheet

    • 1 Videos
Show info about module content

1 Videos

  • Import data to your sheet

Analyze your data

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Analyze your data

1 Readings

  • Sort & filter your data

Use formulas & functions

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Use formulas & functions
  • Use paste special in a spreadsheet

1 Readings

  • Relative and absolute references

Review your knowledge

    • 1 Readings
Show info about module content

1 Readings

  • How to import and analyze your data

Test your knowledge

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Working with formulas and functions

1 Videos

  • Test time - now it's your turn!

2 Readings

  • Test resources
  • Test answer key

Check-in with the instructor

    • 1 Videos
Show info about module content

1 Videos

  • Welcome to “Telling stories with data”

Format cells, rows, and columns in your spreadsheet

    • 1 Videos
Show info about module content

1 Videos

  • Format cells, rows, and columns in your spreadsheet

Highlight key data points in your spreadsheet

    • 1 Videos
Show info about module content

1 Videos

  • Highlight key data points in your spreadsheet

Enter objects in your spreadsheet

    • 1 Videos
Show info about module content

1 Videos

  • Enter objects in your spreadsheet

Review your knowledge

    • 1 Readings
Show info about module content

1 Readings

  • How to design your sheet to highlight trends

Test your knowledge

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Telling Stories with Data

1 Videos

  • Test time - now it's your turn!

2 Readings

  • Test resources
  • Test answer key

Check-in with the instructor

    • 1 Videos
Show info about module content

1 Videos

  • Welcome to “Supercharge your sheet”

Dive deeper into your data

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Dive deeper into your data

1 Readings

  • Create & use pivot tables

Tell your story with your data

    • 2 Videos
Show info about module content

2 Videos

  • Tell your story with your data
  • Use the GOOGLETRANSLATE and GOOGLEFINANCE functions

Analyze your trends alongside Big Data Patterns

    • 1 Videos
Show info about module content

1 Videos

  • Analyze your trends alongside Big Data patterns

Review your knowledge

    • 1 Readings
Show info about module content

1 Readings

  • How to create charts, pivot tables, and reports

Test your knowledge

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Supercharge your sheet

1 Videos

  • Test time - now it's your turn!

2 Readings

  • Test resources
  • Test answer key

Check-in with the instructor

    • 1 Videos
Show info about module content

1 Videos

  • Welcome to “Collaborating in Sheets”

Share a spreadsheet

    • 1 Videos
Show info about module content

1 Videos

  • Share a spreadsheet

Maintain control of your data

    • 1 Videos
Show info about module content

1 Videos

  • Maintain control of your data

Troubleshoot error messages

    • 1 Videos
Show info about module content

1 Videos

  • Troubleshoot error messages

Collaborate with your team

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Collaborate with your team

1 Readings

  • How to use Google Forms

Track changes and activity in Sheets

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Track changes and activity

1 Readings

  • View the activity on your Google Sheets

Review your knowledge

    • 1 Readings
Show info about module content

1 Readings

  • How to share your data with your team

Test your knowledge

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Collaborating in Sheets

1 Videos

  • Test time - now it's your turn!

2 Readings

  • Test resources
  • Test answer key

Auto Summary

"Doing More with Google Sheets" is a foundational course in Business & Management, taught by tech professional Malia. It focuses on creating advanced spreadsheets using Google Sheets, incorporating functions and visualizations for data analysis and team collaboration. The course includes practical exercises and lasts 300 minutes. Available through Coursera with Starter and Professional subscription options, it's perfect for anyone looking to enhance their spreadsheet skills.

Google Cloud Training
Instructor

Google Cloud Training