Google Sheets from Pluralsight

In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace.

In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace. With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types. Formulas and functions allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet. Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes and manage versions of your Google Sheets spreadsheets. Google Workspace makes it easy to collaborate with your team, clients, and others wherever they are. We will look at some of the collaboration options available to you in Google Sheets. Examples include commenting, action items, and notifications.

What's inside

Syllabus

Course introduction

Introduction to Google Sheets

Manage data using Google Sheets

Format a Google Sheets spreadsheet

Basic formulas, functions, and charts

Share your Google Sheets spreadsheets

Collaborate with Google Sheets

Business challenge

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Ideal for business professionals needing a comprehensive overview of Google Sheet's fundamental functions

Provides a strong foundation for spreadsheet software users

Great entry-level course for students or individuals new to Google Sheets

Teaches foundational skills and concepts for creating and managing spreadsheets

Provides practical guidance on sharing and collaborating on Google Sheets spreadsheets

Introduces core spreadsheet concepts such as formatting, formulas, and charting

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 with these activities:

Review Linux Command Line

Show steps

Reviewing Linux command line will strengthen foundational knowledge of the terminal prior to this course's coverage of Google Sheets

Browse courses on File Permissions

Show steps

Review basic commands such as ls, cd, mkdir, and rm
Practice navigating the file system and creating and deleting directories
Go over file permissions and how to change them

Organize Google Sheets Course Materials

Show steps

Organizing materials can help students stay more organized and improve knowledge retention

Show steps

Create a system for organizing your notes, assignments, and other course materials
Review your materials regularly to reinforce your understanding of the course content
Summarize key concepts and create study guides for easier review

Google Sheets Practice Exercises

Show steps

Practice exercises will provide students with repetitive opportunities to apply and reinforce the Google Sheets skills they learn

Show steps

Find online practice exercises or create your own set of exercises
Work through the exercises, focusing on accuracy and efficiency
Review your answers and identify areas where you need improvement

Four other activities

Expand to see all activities and additional details

Show all seven activities

Google Sheets YouTube Tutorials

Show steps

YouTube tutorials will offer supplemental instruction and allow students to learn Google Sheets in a hands-on manner

Show steps

Search and select YouTube tutorials that cover topics relating to Google Sheets and your skill level.
Follow along with the tutorials and take notes on key concepts and techniques
Practice the techniques demonstrated in the tutorials by creating your own Google Sheets spreadsheet

Google Sheets Study Group

Show steps

Study groups can facilitate collaboration, knowledge sharing, and a space for students to resolve knowledge gaps

Show steps

Form a study group with 2-3 other students taking the same course
Meet regularly to discuss course material, share notes, and work through problems together
Take turns leading the discussion and presenting on different topics

Create a Google Sheets Tutorial

Show steps

Creating a tutorial will encourage students to solidify their understanding of Google Sheets concepts and improve their teaching skills

Show steps

Choose a specific topic within Google Sheets that you want to cover
Create an outline for your tutorial, including an introduction, body, and conclusion
Write the content for your tutorial, ensuring that it is clear, concise, and engaging
Record yourself delivering your tutorial or create a screencast
Share your tutorial with others for feedback and improvement

Google Sheets Project

Show steps

Projects can encourage students to apply their knowledge and develop valuable problem-solving and critical-thinking skills

Show steps

Identify a real-world problem or challenge that can be solved using Google Sheets
Develop a plan for your project, including the scope, objectives, and timeline
Create a Google Sheets spreadsheet and populate it with the necessary data
Use Google Sheets functions and formulas to analyze the data and generate insights
Present your findings and recommendations based on your analysis

Career center

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

Data Analyst

Data Analysts design data collection systems, build and implement data models, and analyze data to develop insights for better decision-making. This course on Google Sheets can help the Data Analyst by teaching them how to manage, format, and analyze data using Google Sheets, which is a widely used tool for data analysis. The course will also provide a strong foundation in basic formulas, functions, and charts, which are essential for data analysis.

See salaries and explore the career path for Data Analyst

Statistician

Statisticians collect, analyze, interpret, and present data. They use statistical methods to develop models, make predictions, and draw conclusions. This course on Google Sheets can help the Statistician by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in statistics. The course will also help them develop skills in using formulas, functions, and charts to analyze and present statistical data.

See salaries and explore the career path for Statistician

Risk Manager

Risk Managers identify, assess, and manage risks to organizations. They develop and implement risk management plans and policies, and work with stakeholders to mitigate risks. This course on Google Sheets can help the Risk Manager by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in risk management. The course will also help them develop skills in using formulas, functions, and charts to analyze and present risk data.

See salaries and explore the career path for Risk Manager

Market Research Analyst

Market Research Analysts gather and analyze market data to understand customer behavior and trends. They use this information to develop marketing strategies and make recommendations to businesses. This course on Google Sheets can help the Market Research Analyst by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in market research. The course will also help them develop skills in using formulas, functions, and charts to analyze and present market data.

See salaries and explore the career path for Market Research Analyst

Project Manager

Project Managers plan, execute, and close projects. They work with stakeholders to define project scope, develop project plans, and manage project resources. This course on Google Sheets can help the Project Manager by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in project management. The course will also help them develop skills in using formulas, functions, and charts to analyze and present project data.

See salaries and explore the career path for Project Manager

Data Scientist

Data Scientists apply scientific methods, processes, algorithms, and systems to extract knowledge and insights from data in various forms, both structured and unstructured. This course on Google Sheets can help the Data Scientist by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in data science. The course will also help them develop skills in using formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts use data analysis and problem-solving skills to help businesses improve their performance. They work with stakeholders to understand their needs and then use data to develop solutions. This course on Google Sheets can help the Business Analyst by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is a widely used tool in business analysis. The course will also help them develop skills in using formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Business Analyst

Operations Research Analyst

Operations Research Analysts use mathematical and analytical techniques to solve problems and improve efficiency in business operations. They analyze data, develop models, and make recommendations to businesses. This course on Google Sheets can help the Operations Research Analyst by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in operations research. The course will also help them develop skills in using formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Operations Research Analyst

Data Engineer

Data Engineers design, build, and maintain data pipelines and infrastructure to support data analysis and machine learning applications. This course on Google Sheets can help the Data Engineer by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, a tool that is widely used in data engineering. The course will also help them develop skills in using formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Data Engineer

Financial Analyst

Financial Analysts use financial data to evaluate and make recommendations on investments, financial products, and other financial matters. This course on Google Sheets can help the Financial Analyst by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is widely used in financial analysis. The course will also help them develop skills in using formulas, functions, and charts to analyze and present financial data.

See salaries and explore the career path for Financial Analyst

Systems Analyst

Systems Analysts design, develop, and implement information systems. They work with stakeholders to understand their business needs and then develop and implement information systems solutions. This course on Google Sheets may be useful to the Systems Analyst by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is widely used in systems analysis. The course will also teach them how to use formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Systems Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. They work with stakeholders to understand their needs and then develop and implement software solutions. This course on Google Sheets may be useful to the Software Engineer by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is widely used in software development. The course will also teach them how to use formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Software Engineer

Database Administrator

Database Administrators design, implement, and maintain databases. They work with stakeholders to understand their data needs and then develop and implement database solutions. This course on Google Sheets may be useful to the Database Administrator by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is widely used in database administration. The course will also teach them how to use formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Database Administrator

Web Developer

Web Developers design, develop, and maintain websites and web applications. They work with stakeholders to understand their needs and then develop and implement web solutions. This course on Google Sheets may be useful to the Web Developer by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is widely used in web development. The course will also teach them how to use formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Web Developer

Business Intelligence Analyst

Business Intelligence Analysts collect, analyze, and interpret data to provide insights to businesses. They develop and deliver reports, dashboards, and other data-driven insights to help businesses make better decisions. This course on Google Sheets may be useful to the Business Intelligence Analyst by providing them with a strong foundation in data management, analysis, and visualization using Google Sheets, which is widely used in business intelligence. The course will also teach them how to use formulas, functions, and charts to analyze and present data.

See salaries and explore the career path for Business Intelligence Analyst