Online Class: Google Sheets
-
16Lessons
-
18Exams &
Assignments -
2,872Students
have taken this course -
7Hours
average time -
0.7CEUs
-
Video Audit
Available
Course Description
Mastering the Art of Google Sheets: Unleashing the Power of Spreadsheets
In today's digital age, data management and analysis have become paramount. Enter Google Sheets, the contemporary and highly accessible cousin of Microsoft Excel. Crafted by Google, this spreadsheet tool is not only intuitive but also designed for the modern user, ensuring access from any corner of the world as long as there's an internet connection. While Google Sheets might not parade every single feature found in traditional spreadsheet tools, it triumphs with its sleek simplicity, laser-focused on delivering impactful, professional results without the clutter.
Embark on a transformative journey with our comprehensive course that delves deep into the universe of Google Sheets. From its foundational bricks to the soaring towers of advanced functionalities, we've got you covered. For those new to the Google ecosystem, fret not! We'll initiate with the essentials of setting up your Google account and seamlessly traversing the mobile application.
Our curriculum promises a rich tapestry of skills:
- Crafting meticulous spreadsheets
- Aesthetically formatting for data clarity
- Seamless data input
- Unraveling the magic of formulas and functions
- Visualizing data with dynamic charts
- Building interactive forms
- Harnessing the power of pivot tables & charts
- Exploring the world of ready-to-use templates
- ...and a treasure trove of features waiting to be unveiled.
Each module is articulated with precision, accompanied by vibrant illustrations, ensuring you grasp every nuance. Our lessons are not mere lectures but immersive experiences, walking with you, hand-in-hand, through every procedure. Whether you're a novice with no prior spreadsheet exposure or someone looking to switch from another platform, our course is tailored for all. With our meticulously crafted modules, illustrative screenshots, and HD video guides, you're set to elevate your skills and emerge as a Google Sheets maestro. Dive in and watch your data dance to your tunes!
Course Lessons
Lesson 1: Introduction to Google Sheets
This first lesson will introduce this topic. This course was developed to teach you how to access and use Google Sheets, starting with the basics before working its way into the more advanced features.Lesson 2: Navigating Google Sheets
In this lesson, we are going to discuss how to start using Google Sheets. We will talk about navigating Google sheets on both a computer an Android device, then get started opening and importing files into the app.Lesson 3: Getting Started in Google Sheets
This lesson will continue to focus on different uses for opening and beginning this program.Lesson 4: Spreadsheets and Workbooks
In this lesson, we'll learn all about spreadsheets and workbooks.Lesson 5: Entering Information into Google Sheets
This lesson will focus on entering information into Google SheetsLesson 6: Introduction to Working with Cells, Rows, and Columns
This lesson will provide an introduction to working with Cells, Rows, and ColumnsLesson 7: Formatting Data and Cells
Formatting a spreadsheet can change the look and feel of it.Lesson 8: Formatting Cells, Rows, and Columns
In addition to formatting data in a spreadsheet, Google Sheets also gives you the ability to apply formatting to cells, rows, and columns.Lesson 9: Introduction to Formulas and Calculations
This lesson will provide an introduction to Formulas and CalculationsLesson 10: Working with Formulas and Functions
This lesson will focus on working with Formulas and Function.Lesson 11: Working with Data Using Pivot tables and Data Validation
In this lesson, we are going to discuss the methods that Google Sheets gives you to filter, sort, and summarize data.Lesson 12: Inserting Images into a Spreadsheet
This lesson will discuss how to insert images into a SpreadsheetLesson 13: Inserting Additional Elements into Google Sheets
This lesson will focus on inserting additional elements in Google SheetsLesson 14: Publishing and Printing Spreadsheets in Google Sheets
This lesson will focus on the procedures for publishing and printing spreadsheets in Google.Lesson 15: Sharing and Collaborating on Spreadsheets in Google Sheets
This lesson will focus on the process of sharing and collaborating on a Google Spreadsheet.Lesson 16: Other Helpful Tools in Google Sheets
This lesson will review other helpful tools in Google Sheets
Learning Outcomes
- Define what a spreadsheet is and what Google Sheets capabilities are.
- Demonstrate navigating google sheets.
- Demonstrate entering information into google sheets.
- Demonstrate working with cells, rows, and columns.
- Demonstrate formatting cells, rows, and columns.
- Demonstrate creating and using formulas and calculations.
- Demonstrate working with Data Using Pivot tables and Data Validation.
- Demonstrate inserting images into a spreadsheet.
- Demonstrate publishing and printing spreadsheets.
- Demonstrate sharing and collaborating on spreadsheets in Google Sheets.
- Demonstrate mastery of lesson content at levels of 70% or higher.
Additional Course Information
- Document Your Lifelong Learning Achievements
- Earn an Official Certificate Documenting Course Hours and CEUs
- Verify Your Certificate with a Unique Serial Number Online
- View and Share Your Certificate Online or Download/Print as PDF
- Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Student Testimonials
- "This course was very helpful to me. I had never heard of google sheets and I learned a lot of principles." -- Carolyn W.
- "Helpful information. I like the mix of videos, readings and quizzes." -- Laura D.
Related Courses
- 7 hours 0.7 CEUs Microsoft Visio Level 1 + More Info
- 17 hours 1.7 CEUs Introduction to SQL + More Info
- 5 hours 0.5 CEUs Microsoft Outlook Level 1 + More Info
- 6 hours 0.6 CEUs Google Docs + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
- 6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics + More Info
- 7 hours 0.7 CEUs Google Slides + More Info
- 8 hours 0.8 CEUs Quicken Tutorial: All Versions + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 2 + More Info
- 7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics + More Info
- 9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
- 8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 + More Info
- 7 hours 0.7 CEUs Microsoft Word Level 1 + More Info
- 6 hours 0.6 CEUs Cybersecurity 101 + More Info
- 4 hours 0.4 CEUs Slack + More Info
- 6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online + More Info
- 8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
- 8 hours 0.8 CEUs Microsoft Access Level 1 + More Info
- 14 hours 1.4 CEUs QuickBooks Online + More Info
- 6 hours 0.6 CEUs Microsoft Publisher Level 1 + More Info
- 8 hours 0.8 CEUs MySQL + More Info