Google Cloud Skills Boost

Use Functions, Formulas, and Charts in Google Sheets

3 hours Introductory universal_currency_alt Free
Earn a skill badge by completing the Use Functions, Formulas and Charts in Google Sheets quest, where you analyze data with functions and visualize data using charts. In this intermediate-level quest, you learn to search, validate, format and display data.

A skill badge is an exclusive digital badge issued by Google Cloud in recognition of your proficiency with Google Cloud products and services and tests your ability to apply your knowledge in an interactive hands-on environment. Complete the skill badge quest, and final assessment challenge lab, to receive a digital badge that you can share with your network.

Badge for Use Functions, Formulas, and Charts in Google Sheets

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

  • Lab

    Use Charts in Google Sheets

    Create charts using Google Sheets to share your data in an interesting way. Learn to create pie charts, column charts, combo charts and scatter charts. You also create sparklines and progress bars and learn how to share your spreadsheet in Google Slides and over the web.

  • Lab

    Validate Data in Google Sheets

    Ensure that your data is valid and prepared for analysis using Google Sheets features and functions to organize, standardize, and clean data.

  • Lab

    Finding Data in Google Sheets

    Finding specific content in large spreadsheets can be tricky. Learn to manipulate, search and substitute values in Google Sheets using features and functions like VLOOKUP, SUBSTITUTE and QUERY.

  • Lab

    Use Google Forms with Google Sheets

    With Google Forms, you can create a survey, validate responses, and add custom logic that shows questions based on answers. In this lab, you create a Google Form and analyze the responses in Google Sheets using functions with conditional logic.

  • Lab

    Pivot Tables in Google Sheets

    Create pivot tables to quickly summarize large amounts of data and reference data using named ranges. Use functions and formulas to calculate descriptive statistics.

  • Lab

    Use Functions, Formulas, and Charts in Google Sheets: Challenge Lab

    In this challenge lab you demonstrate your knowledge of Google Sheets that you learned from the Use Functions, Formulas and Charts in Google Sheets quest.

  • info
    Quest Info
    Available languages
    English
    What do I do when I finish this quest?
    After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.
    What badges can I earn?
    Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.