Google Sheets eLearning Bundle Course

Course Details:

Length: 6 courses

Access Length: 6 months

Price: $225/person (USD)

Bundle & Save: View Bundle

Bulk Pricing: 10+ Contact Us

Course Features:

Instant Access After Purchase

Lecture by Recorded Video

Stop and Start as Needed

Certificate of Completion

Software Lab Included?: N/A
(Cloud Based Software)

Delivery Method:

Self-Paced Online

Individuals and Groups
@ Your Location


Course Overview

Transform Your Data Skills: Master Google Sheets and Become a Spreadsheet Wizard!

This comprehensive Google Sheets eLearning Bundle takes you from beginner to advanced, equipping you with the skills to streamline your work, make data-driven decisions, and automate tedious tasks.

Key Benefits
  • Master Spreadsheet Fundamentals: Effortlessly create, navigate, and format spreadsheets to handle any data you encounter.
  • Unleash Data Insights: Use formulas, functions, and PivotTables to analyze data, uncovering trends and patterns.
  • Unlock Data Insights: Analyze complex datasets with logic, lookups, PivotTables, and visualizations.
  • Collaborate Effectively: Share and collaborate on spreadsheets, manage access controls, and streamline workflows.
  • Save Time and Effort: Discover tips, tricks, and automation tools to boost your spreadsheet workflow.
Bundle Courses:
  • Google Sheets: Beginner: Conquer the fundamentals with this foundation-building course. Start building, formatting, and using Sheets like a pro. What You'll Learn:
    • Interface navigation
    • Data entry and formatting
    • Basic formulas and functions
    • Chart creation
  • Google Sheets: Advanced: Dive deep into advanced formulas, data manipulation, PivotTables, macros, scripting, Forms, and more. What You'll Learn:
    • Logical functions (IF, AND, OR)
    • Lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH)
    • Data manipulation with text functions
    • Date calculations
    • PivotTables for analysis
    • Data validation and conditional formatting
    • Macros and scripts for automation
    • Forms integration
    • Data linking and protection

Ready to simplify your work life? Enroll in the Google Sheets eLearning Bundle today and master the essential spreadsheet tool for the modern workplace!

Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.


Course Notes

Important Course Information
This is a Lecture-Only eLearning Course. If you would like to practice any hands-on activities, you must use your own software.

eLearning Training Delivery Method

How It Works

This self-paced online course lets you learn independently at your own pace through Certstaffix Training's easy-to-use platform.

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screenshots
  • 6-month subscription length
  • Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

Learning Objectives:
  • Mastery of Spreadsheet Fundamentals:
    • Effortlessly navigate the Google Sheets interface.
    • Enter, manipulate, and format data with efficiency.
    • Construct basic formulas and understand common functions.
    • Create various chart types for data visualization.
  • Data Analysis Expertise:
    • Apply logical functions (IF, AND, OR, Nested IF) for conditional calculations.
    • Utilize lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH) to retrieve data efficiently.
    • Manipulate text using specialized text functions.
    • Perform calculations with dates and time intervals.
    • Build and interpret PivotTables to uncover insights within large datasets.
  • Workflow Efficiency and Collaboration
    • Implement data validation and conditional formatting for input control and visual cues.
    • Automate tasks using macros and gain a basic understanding of scripting.
    • Integrate Google Forms for streamlined data collection.
    • Link data between spreadsheets and manage protection settings.
    • Collaborate effectively through sharing controls and commenting.
Target Audience
  • Professionals across industries: Anyone who regularly works with data and needs to track, analyze, and report on information.
  • Students: Those seeking to develop spreadsheet skills.
  • Individuals seeking career advancement: Those looking to upskill and demonstrate proficiency in Google Sheets.
  • Anyone wanting to streamline personal workflows: For budgeting, organizing household data, or managing personal projects.
Key Features
  • Audio Narration
  • Video
  • Inline Activities
  • Supplemental Resources
  • Post-Assessment
  • Audio/Video/Course Text: English.
  • Subtitles (Closed Caption): American English, Arabic, Brazilian Portuguese, Canadian French, Chinese (Simplified), Chinese (Traditional), Dutch, French, German, Hindi, Indonesian, Italian, Japanese, Korean, Latin American Spanish, Russian, Spanish, Thai, Turkish, and Vietnamese.
Course Duration
  • Google Sheets Bundle: 4 hrs 15 min
  • Essential Career Skills Pack: 2 hrs 23 min


Course Topics

Google Sheets: Beginner

Course Duration - 2 hrs

This course provides a quick start to this application and is designed to teach students how to use the Google App and Google Sheets to create sophisticated spreadsheets for tracking, analyzing, and storing data.

Course Objectives:
Course Objectives:
  • Identify the core components of the Google Sheets interface and explain their purposes.
  • Create a new Google Sheets spreadsheet, import data from other file formats, and save work in various locations.
  • Navigate efficiently within a spreadsheet using both the keyboard and mouse for cell selection and data manipulation.
  • Enter various data types (text, numbers, dates) into cells and apply appropriate formatting for clarity and accuracy.
  • Construct basic formulas using mathematical operators and cell references, demonstrating an understanding of calculation order.
  • Utilize common functions (SUM, AVERAGE, etc.) to perform calculations and summarize data.
  • Format cells, rows, and columns to improve the visual presentation of a spreadsheet, including alignment, borders, and themes.
  • Organize a spreadsheet by sorting and filtering data, applying freeze panes, and managing multiple sheets.
  • Create basic charts (column, line, pie) to visually represent data within a spreadsheet.
  • Collaborate effectively on a spreadsheet by controlling sharing settings and leaving comments for other contributors.
Detailed Course Outline:
Detailed Course Outline:

Getting Started with Google Sheets
  • What is Google Sheets?
  • Opening Google Sheets
  • Importing and Converting Spreadsheets to Sheets
  • Navigating the Sheets User Interface
  • Understanding Sheet Components
  • Using the File Menu
  • Creating a Spreadsheet
  • Saving a Spreadsheet
  • Accessing Help
Entering Data
  • Navigating a Spreadsheet by Mouse or Keyboard
  • Working with Cell and Ranges
  • Using Various Data Selection Techniques
  • Working with Common Sheet Commands
  • Working with Copy and Paste
  • Understanding Data Types
  • Formatting Values
  • Using the Autofill Handle
  • Inserting Links
Understanding Formula Basics
  • What are Formulas and Functions?
  • Understanding the Components of A Formula
  • Understanding Calculation Hierarchy and the Order of Operations
  • Creating Basic Formulas
  • Working with Basic Functions and Autosum
  • Using Cell References
  • Using Explore
Formatting a Spreadsheet
  • Formatting and Aligning Data
  • Modifying Columns and Rows
  • Using Borders and Fill
  • Using Paint Format
  • Inserting Notes or Comments
  • Inserting Checkboxes
  • Applying a Theme
Managing Spreadsheets
  • Using Zoom Tools
  • Working with Sheets
  • Working with Spreadsheet Tabs
  • Hiding and Unhiding Spreadsheets
  • Sorting Sheets Data
  • Filtering Sheets Data
  • Using Filter Views
  • Using Freeze Panes
  • Printing a Spreadsheet
Printing a Spreadsheet
  • Using Find and Replace
  • Using Spell Check
  • Preparing a Spreadsheet for Printing
  • Changing Spreadsheet Settings
  • Finalizing Printing
  • Downloading and Emailing Files
  • Sharing a Spreadsheet
Creating Charts
  • Inserting a Chart
  • Formatting a Chart
  • Moving and Sizing a Chart
  • Creating a Scorecard Chart
Working with Graphics
  • Inserting Images
  • Creating Drawings


Google Sheets: Advanced

Course Duration - 2 hrs 15 min

This course will teach students advanced concepts and formulas in Google Sheets. Students will learn to use logical statements, lookup functions, and date and text functions. Additionally, students will learn how to link spreadsheets and Sheets files, work with range names, learn the options for spreadsheet protection, create PivotTables, and work with macros and scripts. Students will also learn about conditional formatting, inserting graphics, and creating Forms.

Course Objectives:
Course Objectives:
  • Link data between separate Sheets files and control protection settings to safeguard specific cells, ranges, or entire sheets.
  • Apply logical functions (IF, AND, OR, nested IF) to create conditional formulas for decision-making within spreadsheets.
  • Utilize advanced lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH) to retrieve data from other spreadsheets or tables efficiently.
  • Manipulate text strings using functions like CONCATENATE, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, LEN, and others for data cleaning and formatting.
  • Calculate dates, workdays, and time intervals using date-specific functions (TODAY, NOW, NETWORKDAYS, YEARFRAC)
  • Employ data validation rules and advanced conditional formatting to control input, highlight patterns, and visualize data.
  • Construct and manipulate PivotTables to summarize large datasets, identifying trends and relationships.
  • Automate repetitive tasks by recording macros and introduce the basics of scripting to customize Sheets behavior.
  • Design Google Forms to collect data, link them to Sheets for automatic updates, and send forms for response collection.
  • Implement approval workflows within Sheets to track requests and streamline collaborative processes.
Detailed Course Outline:
Detailed Course Outline:

Linking and Protecting Data
  • Importing Data
  • Linking Sheets
  • Linking to Another Spreadsheet
  • Protecting Sheets and Ranges
  • Working with Versions
  • Reviewing Accessibility Settings
  • Working with Range Names
Analyzing Data with Logical Functions
  • Understanding Logical Functions
  • Using Logical Statements
  • Using AND and OR Functions
  • Working with Nested IF Statements
  • Using the IFERROR Function
  • Working with Lookup Functions
Working with Lookup Functions
  • Understanding Lookup Functions
  • Using VLOOKUP
  • Using HLOOKUP
  • Using INDEX and MATCH
  • Comparing Two Lists with VLOOKUP and IFERROR
Working with Text Functions
  • Splitting Text to Columns
  • Using LEFT, RIGHT, and MID Functions
  • Using UPPER, LOWER, and PROPER Functions
  • Using the LEN Function
  • Removing Duplicates and Trimming White Space
Working with Date Functions
  • Understanding Date Functions
  • Using TODAY, NOW, and DAY Functions
  • Calculating YEARFRAC and NETWORKDAYS
  • Using Named Functions
  • Importing Named Functions
Working with Data
  • Using Data Validation
  • Adding Conditional Formatting
  • Grouping and Ungrouping Data
Understanding PivotTables
  • What is a PivotTable?
  • Creating a PivotTable
  • Working with PivotTables
  • Creating a Chart from a PivotTable
  • Filter Charts and Tables with Slicers
Introduction to Macros and Scripts
  • What are Macros?
  • Creating a Macro
  • Working with Scripts
Working with Forms
  • Creating a Form
  • Working with Forms
  • Sending a Form
Working with Timeline View
  • Creating a Timeline View
Working with Approvals
  • Requesting Approval
  • Approving Sheets



Essential Career Skills Pack

Productivity and Time Management

Course Duration - 30 min

It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.

Course Objectives:
Course Objectives:
  • Set your priorities to better manage your time
  • Improve your productivity by sharpening your focus and multitasking effectively
Detailed Course Outline:
Detailed Course Outline:
  • Productiity & Time Management
  • Prioritization
  • Getting Things Done
  • Procrastination
  • Multitasking & Focus
  • Summary


Basic Digital Skills

Course Duration - 13 min

With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.

Course Objectives:
Course Objectives:
  • Recall the essential digital skills framework
  • Elaborate on the toolkit of essential digital skills
  • Identify how to develop or improve your digital skills
Detailed Course Outline:
Detailed Course Outline:
  • The Essential Digital Skills Framework
  • The Toolkit of Essential Digital Skills
  • Developing Digital Skills
  • Summary


4 Ways to Boost Creativity

Course Duration - 30 min

The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.

Course Objectives:
Course Objectives:
  • Define creativity
  • Think outside the box
  • Develop the right mental attitude
  • Leverage the power of groups
  • Ensure managers make it happen
Detailed Course Outline:
Detailed Course Outline:
  • What is Creativity at Work?
  • Learn to Think Outside the box
  • Develop the Right Mental Capacity
  • Laverage the Power of Groups
  • Ensure Managers Make It Happen
  • Summary


The 11 Essential Career Soft Skills

Course Duration - 1 hr 10 min

Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?

This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.

Course Objectives:
Course Objectives:
  • Understand how to be a great communicator
  • Become a stronger listene
  • Appear professional to co-workers and bosses of all ages
  • Avoid common career blunders that often end careers
  • Manage expectations for bosses and colleagues
  • Position yourself for promotions
  • Make technology your asset, even if you are afraid of technology
  • Avoid the Not My Job Syndrome
  • Develop EQ to Match Your IQ
  • Develop leadership qualities
Detailed Course Outline:
Detailed Course Outline:
  • Introduction
  • The Soft Tech Savvy Way to Always Be Essential
  • Not My Job, And I Am Happy to Do It
  • You Can Become a Master Communicator
  • Feedback Video for The 11 Essential Career Soft Skills
  • Become a Leader Without the Title or Formal Authority
  • Your EQ Will Beat a Higher IQ
  • Building Your Winning Team
  • Make Every One of Your Seconds Count
  • Unleash Your Inner Anthony Robbins
  • Avoid Being Uncool
  • Clothes Can Still Make or Break Your Career
  • Conclusion The 11 Essential Career Soft Skills
  • Extra: Developing Your Career Secret Sauce



Related Google Workspace Information:

How Much Do Google Workspace Training Courses Cost?

Public instructor-led Google Workspace course prices start at $550 per student. Group training discounts are available.

Self-Paced Google Workspace eLearning courses cost $225 at the starting point per student. Group purchase discounts are available.

What Google Workspace Skills Should I Learn?

A: If you are wondering what Google Workspace skills are important to learn, we've written a Google Workspace Skills and Learning Guide that maps out Google Workspace skills that are key to master and which of our courses teaches each skill.

Read Our Google Workspace Skills and Learning Guide

Is there training for Google Workspace?

A: Yes, there is training for Google Workspace. You can find a variety of training options within the Google Workspace Admin console. From here, you can access training materials, video tutorials, and other resources to help you get the most out of your Google Workspace experience.

Certstaffix Training also offers self-paced eLearning courses on Google Docs, Slides, Sheets and Classroom. Browse our Google Workspace courses or contact us to find out more.

How do I learn to use Google Sheets?

A: There are a few different ways that you can learn to use Google Sheets. You can find many helpful tutorials and resources online, or you can sign up for a class through Certstaffix Training.

If you want to learn on your own, there are plenty of great tutorials available online. YouTube is a great place to start, as there are many step-by-step video guides that can walk you through the basics of using Google Sheets. Once you feel comfortable with the basics, you can start exploring more advanced features and functions.

Another option is to sign up for a class through Certstaffix Training. We offer self-paced eLearning that you attend in a web browser on your own schedule. Browse our Google Sheets courses or contact us today.

Is Google Slides easy to use?

A: Google Slides is a powerful and easy-to-use presentation tool that can help you create professional-looking presentations. It's also free to use, making it a great option for businesses and individuals on a budget. Whether you're new to Google Slides or just need a refresher, our Google Slides training classes can help you get the most out of this versatile program.

Browse our Google Slides courses to get started.

How do beginners use Google Docs?

A: There are a few different ways that beginners can use Google Docs. One way is to take advantage of the many training resources that are available online. Certstaffix Training provides Google Docs classes online for individuals and onsite for groups, which can be a great way to learn how to use Google Docs.

Another way for beginners to use Google Docs is to explore the various features and tools that are available. The Google Docs Help Center is a great resource for learning more about how to use this word processing software.

Finally, it can be helpful for beginners to ask questions and get help from more experienced users. The Google Docs community forums are a great place to start if you have any questions about using this software.

What are the top Google Workspace skills?

A: With more businesses using Google Workspace (formerly G Suite) to improve productivity and collaboration, there is a growing demand for workers with the skills to use these tools effectively. Here are some of the top Google Workspace skills that can help you get ahead in today’s competitive job market:

Top Google Workspace Skills

1. Google Docs: Google Docs is a versatile tool that can be used for everything from creating and editing documents to collaborating with team members in real-time. To be proficient in Google Docs, you should have a good understanding of how to use its various features, including commenting, suggest mode, and track changes.

2. Google Sheets: Google Sheets is a powerful spreadsheet application that can be used for everything from data analysis to creating complex financial models. To be proficient in Google Sheets, you should have a good understanding of how to use its various features, including formulas, functions, and pivot tables.

3. Google Slides: Google Slides is a versatile presentation tool that can be used for everything from creating slide decks to collaborating with team members in real-time. To be proficient in Google Slides, you should have a good understanding of how to use its various features, including transitions, animations, and speaker notes.

4. Google Forms: Google Forms is a powerful tool that can be used for everything from creating surveys to collecting data from team members. To be proficient in Google Forms, you should have a good understanding of how to use its various features, including question types, skip logic, and response validation.

5. Google Calendar: Google Calendar is a versatile tool that can be used for everything from managing your personal schedule to scheduling team meetings. To be proficient in Google Calendar, you should have a good understanding of how to use its various features, including event reminders, shared calendars, and event scheduling.

By possessing these top Google Workspace skills, you’ll be in a strong position to take advantage of the growing demand for workers who are proficient in using these powerful tools.

Where Can I Learn More About Google Workspaces?

Google Workspace Blogs

Google Workspace User Groups

Google Workspace Online Forums

Explore Google Workspace Training Classes Near Me:

Certstaffix Training provides Google Workspace classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Google Workspace concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Google Workspace skills. Start learning today and see how Certstaffix Training can help you reach your goals.


Have a Group?
Request Private Training

Online Class

Self-Paced eLearning

Start your training today!