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
Microsoft Word Courses
Microsoft Word Courses
Microsoft Excel Courses
Microsoft Excel Courses
Operations Management Courses
Operations Management Courses
How to Create VIEWs in SQL
How to Create VIEWs in SQL
How to Create Tables with HTML5
How to Create Tables with HTML5
How to Link Your Calendars with Slack
How to Link Your Calendars with Slack
Google Sheets
Google Sheets
Communications Courses
Communications Courses
How to Do Advanced Queries in MySQL
How to Do Advanced Queries in MySQL
Microsoft Access Level 1
Microsoft Access Level 1
QuickBooks Courses
QuickBooks Courses
Microsoft Excel Level 3
Microsoft Excel Level 3
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Overview of MySQL
Overview of MySQL
How to do Reports in QuickBooks Online
How to do Reports in QuickBooks Online
Business Writing Courses
Business Writing Courses
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
Learn HTML - Create Webpages Using HTML5
Learn HTML - Create Webpages Using HTML5