Course Summary
This course teaches you the basics of Google Sheets, including how to create and format spreadsheets, use formulas and functions, and collaborate with others. By the end of the course, you'll be able to use Google Sheets to manage data and make informed decisions.Key Learning Points
- Learn how to create and format spreadsheets in Google Sheets
- Discover how to use formulas and functions to manipulate data
- Collaborate with others in real time and share your spreadsheets
Related Topics for further study
Learning Outcomes
- Create and format spreadsheets in Google Sheets
- Use formulas and functions to manipulate data
- Collaborate with others in real time
Prerequisites or good to have knowledge before taking this course
- Access to a computer with internet connection
- Basic understanding of spreadsheets
Course Difficulty Level
BeginnerCourse Format
- Online self-paced course
- Video lectures
- Hands-on exercises
- Quizzes and assessments
Similar Courses
- Excel Skills for Business
- Data Analysis with Python
Related Education Paths
Notable People in This Field
- Chandoo
- SheetsCon
Related Books
Description
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. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.
Outline
- Welcome to Google Sheets: how to create, edit, and print your spreadsheet
- Meet the instructor
- Create a new spreadsheet
- Edit your spreadsheet
- Duplicate, print, or publish your spreadsheet
- Use some basic keyboard shortcuts
- Test time - now it's your turn!
- Movie Data Spreadsheet
- How to create, edit, and print your spreadsheet
- Test resources
- Test answer key
- Working with formulas and functions: how to import and analyze your data
- Welcome to “Working with formulas and functions”
- Import data to your sheet
- Analyze your data
- Use formulas & functions
- Use paste special in a spreadsheet
- Test time - now it's your turn!
- Sort & filter your data
- Relative and absolute references
- How to import and analyze your data
- Test resources
- Test answer key
- Telling stories with data: how to design your sheet to highlight trends
- Welcome to “Telling stories with data”
- Format cells, rows, and columns in your spreadsheet
- Highlight key data points in your spreadsheet
- Enter objects in your spreadsheet
- Test time - now it's your turn!
- How to design your sheet to highlight trends
- Test resources
- Test answer key
- Supercharge your sheet: how to create charts, pivot tables, and reports
- Welcome to “Supercharge your sheet”
- Dive deeper into your data
- Tell your story with your data
- Use the GOOGLETRANSLATE and GOOGLEFINANCE functions
- Analyze your trends alongside Big Data patterns
- Test time - now it's your turn!
- Create & use pivot tables
- How to create charts, pivot tables, and reports
- Test resources
- Test answer key
- Collaborating in Sheets: how to share your data with your team
- Welcome to “Collaborating in Sheets”
- Share a spreadsheet
- Maintain control of your data
- Troubleshoot error messages
- Collaborate with your team
- Track changes and activity
- Test time - now it's your turn!
- How to use Google Forms
- View the activity on your Google Sheets
- How to share your data with your team
- Test resources
- Test answer key
Summary of User Reviews
Learn how to use Google Sheets with this beginner's course from Coursera. Users have praised the course for its practical lessons and easy-to-follow instructions. Overall, the course has received positive reviews from learners.Key Aspect Users Liked About This Course
Many users have praised the practicality of the lessons and the easy-to-follow instructions.Pros from User Reviews
- Practical lessons that can be applied in real-world scenarios
- Easy-to-follow instructions for beginners
- Interactive quizzes and assignments that help reinforce learning
- Flexible schedule allows learners to complete the course at their own pace
Cons from User Reviews
- Some users wished there were more advanced topics covered
- Limited interaction with instructors
- Content may be too basic for some users with prior experience in Google Sheets
Google Cloud Training
4.7 Raiting
Youtube Channel SEO and Growth Hacking : Ranking #1 in 2021
- 5
-
![]()
![]()
![]()
![]()
![]()
Youtube SEO Secrets to Rank your Videos #1 in 2020 with Proven Youtube Marketing Growth Hacking Strategies or services. you have to do it right....
Young Adult Fiction Writing Workshop
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Turn your idea into a published novel in today's hottest genre. Young Adult Fiction is today's top-selling category. Have you started a novel, only to get stuck?...
Sell Ebooks on Amazon Kindle and Global Retailers
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Self publishing made easy. Sell ebooks at Amazon, Apple, Google, B&N, Kobo, Smashwords, Scribd and major retailers. Amazon Apple iBooks Store...
Digital Marketing Course 2021: Be a Digital Marketing Nomad
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn Digital Marketing, Copywriting, Ads, SEO, Video Creation. Become a Digital Marketing Nomad. Freelance and Travel. What is Digital Marketing? What is Social Media?...
