Google Sheets - Advanced Topics from Pluralsight

This course builds on some of the concepts covered in the earlier Google Sheets course.

This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet. Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization. This course explores the data visualization options in Google Sheets, such as charts and pivot tables. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. You will explore how Forms and Sheets work together by connecting collected Form data to a spreadsheet, or by creating a Form from an existing spreadsheet.

What's inside

Syllabus

Course introduction

Advanced formatting in a Google Sheet

Advanced formulas and functions

Analyze and report

Populate data using a Google Form

Business challenge

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Helps learners apply and customize themes and formatting options in their spreadsheets

Provides guidance on using conditional formatting to enhance data visualization

Covers advanced formulas and functions for efficient data analysis and manipulation

Introduces techniques for creating formulas using functions, referencing, and validating data

Explores data visualization options such as charts and pivot tables to help users effectively summarize and represent data

Provides an overview of Google Forms, enabling learners to create and integrate forms with spreadsheets for data collection and analysis

Taught by Google Cloud instructors, ensuring learners receive expertise from industry professionals

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Google Sheets - Advanced Topics with these activities:

Review foundational Google Sheets concepts

Show steps

Brush up on the basics of working with Google Sheets to ensure a smoother learning experience in this course.

Browse courses on Google Sheets

Show steps

Review the Google Sheets interface and explore its key features.
Practice creating and editing spreadsheets, adding and formatting data.
Experiment with basic formulas and functions to perform simple calculations.

Connect with experienced Google Sheets users

Show steps

Seek guidance and support from experienced Google Sheets users to enhance your learning and troubleshoot any challenges.

Browse courses on Mentorship

Show steps

Attend virtual or in-person meetups and workshops to connect with potential mentors.
Reach out to professionals in your network who have expertise in Google Sheets.
Use online platforms to find mentors who offer guidance and support.

Explore advanced formatting techniques

Show steps

Deepen your understanding of how to customize the appearance and functionality of your spreadsheets to enhance data presentation.

Browse courses on Advanced Formatting

Show steps

Follow online tutorials to learn about applying and customizing themes.
Practice using conditional formatting to highlight specific data based on predefined rules.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Explore Google Forms and its integration with Google Sheets

Show steps

Become familiar with the functionality of Google Forms and how to seamlessly connect it with Google Sheets for efficient data collection and analysis.

Browse courses on Google Forms

Show steps

Create and customize Google Forms to collect data from users.
Learn how to connect Google Forms to a Google Sheet to automatically populate the collected data.
Practice analyzing the collected data using Google Sheets' tools and features.

Master advanced formulas and functions

Show steps

Strengthen your ability to use Google Sheets' advanced formulas and functions for complex data analysis and calculations.

Browse courses on Advanced Formulas

Show steps

Complete online exercises and drills to reinforce your understanding of functions like VLOOKUP, HLOOKUP, and SUMIF.
Practice creating custom formulas to solve specific data analysis problems.

Create advanced charts and pivot tables

Show steps

Develop proficiency in creating customized charts and pivot tables to effectively summarize and visualize complex data.

Browse courses on Data Visualization

Show steps

Follow interactive tutorials on creating different types of charts, such as bar charts, line charts, and scatter plots.
Practice using pivot tables to summarize and analyze large datasets by grouping and aggregating data.

Build a spreadsheet to solve a practical problem

Show steps

Apply your skills to create a functional spreadsheet that addresses a real-world data analysis or organization problem.

Show steps

Define the problem and gather the necessary data.
Design and build a spreadsheet that includes relevant formulas, functions, and visualizations.
Test and refine your spreadsheet to ensure accuracy and efficiency.

Career center

Learners who complete Google Sheets - Advanced Topics will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts provide insights that can improve products or business practices. In this role, you will be able to apply the skills you learn in this Advanced Google Sheets course to creating pivot tables and charts that visually represent data. This can help identify trends and patterns that may otherwise go unnoticed.

See salaries and explore the career path for Data Analyst

Operations Research Analyst

Operations Research Analysts apply advanced analytical techniques to help organizations improve their efficiency and effectiveness. They use data visualization to identify inefficiencies and develop solutions that can save time and money.

See salaries and explore the career path for Operations Research Analyst

Financial Analyst

Financial Analysts help businesses make informed decisions about their finances. In addition to using advanced formulas and functions to create accurate financial models, they often use data visualization techniques, such as charts and graphs, to present their findings in a clear and concise manner.

See salaries and explore the career path for Financial Analyst

Market Research Analyst

Market Research Analysts gather and analyze data to understand consumer trends and preferences. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Market Research Analyst

Business Intelligence Analyst

Business Intelligence Analysts use data analysis to help businesses make better decisions. They use data visualization techniques, such as charts and graphs, to present their findings in a clear and concise manner.

See salaries and explore the career path for Business Intelligence Analyst

Statistician

Statisticians use advanced analytical techniques to collect, analyze, and interpret data. They often use data visualization techniques, such as charts and graphs, to present their findings in a clear and concise manner.

See salaries and explore the career path for Statistician

Data Scientist

Data Scientists use advanced analytical techniques to solve complex business problems. They often use data visualization techniques, such as charts and graphs, to communicate their findings to non-technical audiences.

See salaries and explore the career path for Data Scientist

Fraud Analyst

Fraud Analysts use advanced analytical techniques to identify and investigate fraud. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Fraud Analyst

Risk Analyst

Risk Analysts use advanced analytical techniques to identify and assess risks. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Risk Analyst

Actuary

Actuaries use advanced analytical techniques to assess risk and uncertainty. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Actuary

Auditor

Auditors use advanced analytical techniques to examine financial records and ensure accuracy. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Auditor

Compliance Analyst

Compliance Analysts use advanced analytical techniques to ensure that organizations comply with laws and regulations. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Compliance Analyst

Journalist

Journalists use advanced analytical techniques to research and write stories. They often use data visualization techniques, such as charts and graphs, to present their findings to readers.

See salaries and explore the career path for Journalist

Consultant

Consultants use advanced analytical techniques to help clients solve business problems. They often use data visualization techniques, such as charts and graphs, to present their findings to clients.

See salaries and explore the career path for Consultant

Teacher

Teachers use advanced analytical techniques to track student progress and identify areas where they need additional support. They often use data visualization techniques, such as charts and graphs, to present their findings to students and parents.

See salaries and explore the career path for Teacher