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
Neural Networks in Python from Scratch: Complete guide
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn the fundamentals of Deep Learning of neural networks in Python both in theory and practice! Are you ready to take the next step in your professional career?...
Hands-On Writing: Tips, Tools, and Real Content Examples
- 4
-
![]()
![]()
![]()
![]()
![]()
Using web writing to take your business to Google's first page in 2019 and increase your sales - NO EXPERIENCE REQUIRED!...
Smart Analytics, Machine Learning, and AI on GCP
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Incorporating machine learning into data pipelines increases the ability of businesses to extract insights from their data. For little to no customization, this course covers AutoML....
Introduction into Facebook Marketing & Facebook Advertising
- 4.5
-
![]()
![]()
![]()
![]()
![]()
SETUP Efficient Facebook Advertising Strategy. OPTIMISE Facebook Ads Budget. MASTER Facebook Marketing & Facebook Ads. "The BEST, authentic, great and very precise course on Facebook Marketing and Facebook Advertising....
