Lesson 1
Google Sheets - Advanced Topics
This advanced Google Sheets course covers: themes, conditional formatting, advanced formulas, data validation, visualizations, and Google Forms integration for data collection and analysis.
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.
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.
Built in collaboration with
Google Cloud
Intermediate
2 hours
Completion Certificate
Last Updated March 15, 2024
Skills you'll learn:
Prerequisites:
Lesson 1
This advanced Google Sheets course covers: themes, conditional formatting, advanced formulas, data validation, visualizations, and Google Forms integration for data collection and analysis.
The Google Cloud Training team is responsible for developing, delivering and evaluating training that enables our enterprise customers and partners to use our products and solution offerings in an effective and impactful way.
Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.
Demonstrate proficiency with practical projects
Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.
Gain proven experience
Retain knowledge longer
Apply new skills immediately
Top-tier services to ensure learner success
Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.
Get help from subject matter experts
Learn industry best practices
Gain valuable insights and improve your skills
2 hours
, Beginner
2 hours
, Beginner
2 hours
, Beginner
2 hours
, Beginner
2 hours
, Beginner
4 hours
, Beginner
2 hours
, Beginner
2 hours
, Beginner
3 weeks
, Beginner
2 hours
, Beginner
1 hour
, Beginner
2 hours
, Beginner
1 hour
, Beginner
2 hours
, Beginner
2 hours
, Beginner
Dive deeper into Google Sheets with Udacity's advanced training course. Learn theme customization, conditional formatting, advanced formulas & more. Join now!