Course Syllabus

 

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 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.
 
 

Assessment Guide

Assessment Points
Why this Course? 1 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
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Introduction to SQL
Introduction to SQL
Communications Courses
Communications Courses
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 1
Microsoft Excel Courses
Microsoft Excel Courses
Microsoft Visio Level 1
Microsoft Visio Level 1
A CSS3 and HTML5 Introduction to Responsive Web Design
A CSS3 and HTML5 Introduction to Responsive Web Design
Operations Management Courses
Operations Management Courses
HTML5 Videos and Graphics
HTML5 Videos and Graphics
Using HTML5 to Add Styles and Classes to Your Web Pages
Using HTML5 to Add Styles and Classes to Your Web Pages
Microsoft Word Courses
Microsoft Word Courses
What is Slack?
What is Slack?
QuickBooks Courses
QuickBooks Courses
How to Upload and Share Files in Slack
How to Upload and Share Files in Slack
Business Writing Courses
Business Writing Courses
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
Google Docs
Google Docs
Using the IN, NOT, and LIKE Operators in SQL
Using the IN, NOT, and LIKE Operators in SQL