Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started

Google Sheets for Beginners

HomeHome > CoursesCourses> Work Productivity > Google Sheets for Beginners
Share
Share this course
Facebook Linkedin Twitter

Google Sheets for Beginners

Chapter name: Lesson name

Google Sheets for Beginners

Ready to watch the complete course?

Become a member and get unlimited access to the entire software training library of over 8,000 video tutorials

Start Your Membership
Loading the player ...

Contents

  • 1. Introduction
    • Free Course Introduction
      05m 01s
    • Free Accessing Google Sheets
      07m 49s
    • Free It's Just Google
      04m 39s
  • 2. Start It
    • Free Orientation
      04m 19s
    • Free Cells
      06m 34s
    • Rows & Columns - Part 1
      05m 40s
    • Rows & Columns - Part 2
      06m 20s
    • Theme
      07m 10s
    • Formatting - Part 1
      06m 27s
    • Formatting - Part 2
      08m 32s
    • Exercise 01
      06m 19s
  • 3. Insert It
    • Insert Links
      05m 36s
    • Insert Images
      08m 36s
    • Insert Drawings
      09m 43s
    • Insert Checkboxes
      09m 04s
    • Insert Notes & Comments
      08m 36s
    • Exercise 02
      04m 07s
  • 4. Organize It
    • Data Cleanup
      06m 26s
    • Conditional Formatting: Part 1
      07m 47s
    • Conditional Formatting: Part 2
      06m 50s
    • Drop-down in Cells
      09m 40s
    • Data Validation
      04m 31s
    • Exercise 03
      05m 18s
  • 5. Work with It
    • Sort & Filter
      09m 09s
    • Basic Formulas
      07m 40s
    • Basic Functions
      08m 33s
    • Query Function
      09m 06s
    • Multiple Sheets
      04m 01s
    • Exercise 04
      03m 52s
  • 6. Graph It
    • Types of Charts & Graphs
      09m 23s
    • Edit & Customize Charts: Part 1
      05m 26s
    • Edit & Customize Charts: Part 2
      06m 59s
    • Exercise 05
      06m 57s
  • 7. Share It
    • Share & Collaborate: Part 1
      07m 04s
    • Share & Collaborate: Part 2
      05m 05s
    • Download, Print or Publish
      02m 47s
    • Exercise 06
      02m 21s
  • 8. Closing
    • Course Wrap Up
      02m 07s
  • Description
  • Course Resources
  • Shortcode Not working

Google Sheets for Beginners

  • DURATION: 4.5 hours
  • VIDEOS: 38
  • LEVEL: Beginner

Discover how to use Google’s popular online spreadsheet application with this comprehensive beginner-level course for Google Sheets. This application is perfect for collaboration as it allows you and other users to work on the same spreadsheet at once and to save all your changes in real time. No more conflicting changes and lost work! Think of it as using Excel, only better.

In this Google Sheets for Beginners course, we start from the very beginning, where we teach you how to create a spreadsheet from scratch. We’ll work through rows and columns, themes, formatting, and a handful of keyboard shortcuts. We’ll also cover inserting images, checkboxes, and comments as well as using Google Drawings.

This course also discusses data cleanup and data validation, including how to create dropdown menus. We then move on to basic formulas and functions, sorting and filtering, working with multiple sheets, adding graphs and charts, and sharing your sheet.

This is a beginner-level course designed for Google Sheets novices who are just starting out with spreadsheets; it is suitable for both PC and Mac users. We’ve also included accessible exercise and instructor files—the same Google Sheets files that the instructor uses in the tutorial—so you can follow along.

This course covers:

  • Multiple ways to access Google Sheets
  • Getting familiar with the Google Sheets interface
  • Working with cells, rows, and columns, including group and merge functions
  • Keyboard shortcuts (for both PC and Mac)
  • Applying themes, formatting, and conditional formatting
  • How to insert links, images, checkboxes, notes, and comments
  • Using Google Drawings to insert drawings and videos
  • Adding data validations and dropdowns in cells
  • Sorting and filtering data
  • Using basic formulas and functions
  • All about the Query function
  • How to work with multiple sheets
  • Adding charts and graphs and the different types available
  • Editing and customizing charts
  • How to share your sheet and collaborate with other users
  • Downloading, printing, and publishing your Google Sheets file

Google Sheets for Beginners

The course comes with course instructor and exercise files. You will need to download the word files containing the links to access the Google Sheets.

Click on the below links to download the files.

  • Google Sheets Basics Exercise Files
  • Google Sheets Basics Instructor Files

Get immediate access to the entire library!

Annual Membership

$ 197 /per year

This is an annual membership to SimonSezIT.com with access to all online training courses.  You will be charged again when your membership expires. You can cancel at any time.

Sign Up

Monthly Membership

$ 25 /per month

This is a monthly membership to SimonSezIT.com with access to all online training courses. You will be charged each month. You can cancel at any time.

Sign Up

Related courses

Asana for Employees and Managers - Simon Sez IT

Asana for Employees and Managers

Introduction to Confluence simon sez it

Introduction to Confluence

Getting Started in Monday.com Online Course

Getting Started in Monday.com

Getting Started in Jira Online Course

Getting Started in Jira

Introduction to Asana Online Course

Introduction to Asana

Trusted by

  • Guitar Center
  • Honeywell
  • Charter
  • SIU carbondale
  • College of
  • Clean Harbors
  • Wyle
  • fareva

Start Your Membership

Simon Sez: “Let’s make you a software superstar!”

From Excel to photo editing, experience quality courses that ensure easy learning.

START YOUR MEMBERSHIP
Learn More

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)