Google Sheets - Beginner

Designed to teach students the fundamentals of Google Sheets.

4.95 (27 reviews)
Udemy
platform
English
language
Google
category
69
students
3 hours
content
Nov 2023
last update
$54.99
regular price

What you will learn

Import and Convert Spreadsheets to Sheets

Navigate the Sheets User Interface

Use the File Menu

Creating & Saving a Spreadsheet

Cells and Ranges

Formatting Values

Autofill Handle

Inserting Links

Creating Basic Formulas

Sharing a Spreadsheet

Inserting a Chart

Formatting a Chart

Description

This Intellezy course, taught by Ed McCrae, is designed to teach the student the basic fundamentals of Google Sheets. This course is the first course in a two-part series. The optional continuation of this course is Google Sheets – Advanced. Google Sheets is one of the most widely used programs in GSuite. In this course, students will learn how to create, save, and enter data in Google Sheets. Students will also learn how to review, polish, and print spreadsheets properly using a variety of options. Students will also learn how to create formulas and use functions to calculate in Sheets. Additionally, students will learn how to format spreadsheets, manipulate columns and rows, as well as prepare a spreadsheet for printing. Students will also learn how to create and format charts, insert various graphics and images, and find self-service help options and information on thousands of other topics and features that are available.

Like most of our courses, closed caption subtitles are available for this course in:  Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.


This course aligns with the CAP Body of Knowledge and should be approved for 2.75 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Content

Introduction

Introduction

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

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

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

Working with Graphics

Inserting Images
Creating Drawings

Conclusion

Course Recap

Assessment Quiz

Google Sheets Beginner Assessment Quiz

Screenshots

Google Sheets - Beginner - Screenshot_01Google Sheets - Beginner - Screenshot_02Google Sheets - Beginner - Screenshot_03Google Sheets - Beginner - Screenshot_04

Charts

Price

Google Sheets - Beginner - Price chart

Rating

Google Sheets - Beginner - Ratings chart

Enrollment distribution

Google Sheets - Beginner - Distribution chart

Related Topics

2760816
udemy ID
1/15/2020
course created date
1/22/2020
course indexed date
Bot
course submited by