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!

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Define the process to create and set up a new Gmail account as a prerequisite to accessing Google Sheets, ensuring all required fields and parameters are correctly completed.
  • Demonstrate how to navigate and access Google Sheets using various methods, including Gmail, search engines, Google Apps, and direct download on Android devices, to enhance usability and productivity.
  • Define the function of common tools in the Google Sheets toolbar, such as Undo, Redo, Print, and Paint Format.
  • Demonstrate the ability to open, name, and create copies of spreadsheets in Google Sheets on both a computer and an Android device.
  • Customize a Google Sheets template by modifying text and images to fit personal or professional needs, including font adjustments and image replacements.
  • Demonstrate how to open a new blank spreadsheet or template from within an existing Google Sheets document, using the File menu options.
  • Demonstrate the process of adding, renaming, and changing the color of spreadsheets within a workbook in Google Sheets by completing three tasks accurately.
  • Recognize and differentiate between a spreadsheet and a workbook in Google Sheets by identifying their unique characteristics within 15 minutes.
  • Demonstrate the process of entering various data types into Google Sheets, including text, values, and formulas, and explain how to adjust cell formatting for accurate data representation.
  • Identify and describe the three types of data in Google Sheets, demonstrating how to differentiate between text, values, and formulas within a cell.
  • Define the process of cutting, copying, and pasting cells, rows, or columns in Google Sheets and apply it to relocate data efficiently.
  • Demonstrate the steps to insert, lock, and group rows and columns in Google Sheets to organize data effectively.
  • Demonstrate the ability to change font type, size, and attributes in Google Sheets by formatting a selected cell range according to specified criteria.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
Motives for Taking this Course 2 points
Lesson 1 Quiz 10 points
Lesson 2 Quiz 10 points
Lesson 3 Quiz 10 points
Lesson 4 Quiz 10 points
Lesson 5 Quiz 10 points
Lesson 6 Quiz 10 points
Lesson 7 Quiz 9 points
Lesson 8 Quiz 9 points
Lesson 9 Quiz 10 points
Lesson 10 Quiz 9 points
Lesson 11 Quiz 10 points
Lesson 12 Quiz 8 points
Lesson 13 Quiz 10 points
Lesson 14 Quiz 10 points
Lesson 15 Quiz 9 points
Lesson 16 Quiz 10 points
The Final Exam 60 points
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
Marketing Strategies with Blogging
Marketing Strategies with Blogging
MySQL Administration: Managing Users and Privileges
MySQL Administration: Managing Users and Privileges
QuickBooks Courses
QuickBooks Courses
How to Manage Loans in QuickBooks Online Version
How to Manage Loans in QuickBooks Online Version
Computer Literacy Level 3 - Living and Working Online
Computer Literacy Level 3 - Living and Working Online
Business Writing Courses
Business Writing Courses
Communications Courses
Communications Courses
Benefits and Setting Up MySQL Replication
Benefits and Setting Up MySQL Replication
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Microsoft Outlook Level 1
Microsoft Outlook Level 1
Paying Expenses and Bills in QuickBooks Online Version
Paying Expenses and Bills in QuickBooks Online Version
Computer Literacy Level 1 - Computer Basics
Computer Literacy Level 1 - Computer Basics
Operations Management Courses
Operations Management Courses
MySQL
MySQL
Microsoft Word Courses
Microsoft Word Courses
Using Stored Procedures in SQL
Using Stored Procedures in SQL
Microsoft Excel Courses
Microsoft Excel Courses