Google Sheets – Beginner

Google Sheets – Beginner, available at $54.99, has an average rating of 4.8, with 55 lectures, 1 quizzes, based on 32 reviews, and has 82 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wishes to learn the fundamentals of Google Sheets It is particularly useful for Anyone who wishes to learn the fundamentals of Google Sheets.

Enroll now: Google Sheets – Beginner

Summary

Title: Google Sheets – Beginner

Price: $54.99

Average Rating: 4.8

Number of Lectures: 55

Number of Quizzes: 1

Number of Published Lectures: 55

Number of Published Quizzes: 1

Number of Curriculum Items: 56

Number of Published Curriculum Objects: 56

Original Price: $24.99

Quality Status: approved

Status: Live

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

Who Should Attend

Anyone who wishes to learn the fundamentals of Google Sheets

Target Audiences

Anyone who wishes to learn the fundamentals of Google Sheets

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Getting Started with Google Sheets

Lecture 1: What is Google Sheets?

Lecture 2: Opening Google Sheets

Lecture 3: Importing and Converting Spreadsheets to Sheets

Lecture 4: Navigating the Sheets User Interface

Lecture 5: Understanding Sheet Components

Lecture 6: Using the File Menu

Lecture 7: Creating a Spreadsheet

Lecture 8: Saving a Spreadsheet

Lecture 9: Accessing Help

Chapter 3: Entering Data

Lecture 1: Navigating a Spreadsheet by Mouse or Keyboard

Lecture 2: Working with Cell and Ranges

Lecture 3: Using Various Data Selection Techniques

Lecture 4: Working with Common Sheet Commands

Lecture 5: Working with Copy and Paste

Lecture 6: Understanding Data Types

Lecture 7: Formatting Values

Lecture 8: Using Autofill Handle

Lecture 9: Inserting Links

Chapter 4: Understanding Formula Basics

Lecture 1: What are Formulas and Functions?

Lecture 2: Understanding the Components of a Formula

Lecture 3: Understanding Calculation Hierarchy and the Order of Operations

Lecture 4: Creating Basic Formulas

Lecture 5: Working with Basic Functions and Autosum

Lecture 6: Using Cell References

Lecture 7: Using Explore

Chapter 5: Formatting a Spreadsheet

Lecture 1: Formatting and Aligning Data

Lecture 2: Modifying Columns and Rows

Lecture 3: Using Borders and Fill

Lecture 4: Using Paint Format

Lecture 5: Inserting Notes or Comments

Lecture 6: Inserting Checkboxes

Lecture 7: Applying a Theme

Chapter 6: Managing Spreadsheets

Lecture 1: Using Zoom Tools

Lecture 2: Working with Sheets

Lecture 3: Working with Spreadsheet Tabs

Lecture 4: Hiding and Unhiding Spreadsheets

Lecture 5: Sorting Sheets Data

Lecture 6: Filtering Sheets Data

Lecture 7: Using Filter Views

Lecture 8: Using Freeze Panes

Chapter 7: Printing a Spreadsheet

Lecture 1: Using Find and Replace

Lecture 2: Using Spell Check

Lecture 3: Preparing a Spreadsheet for Printing

Lecture 4: Changing Spreadsheet Settings

Lecture 5: Finalizing Printing

Lecture 6: Downloading and Emailing Files

Lecture 7: Sharing a Spreadsheet

Chapter 8: Creating Charts

Lecture 1: Inserting a Chart

Lecture 2: Formatting a Chart

Lecture 3: Moving and Sizing a Chart

Lecture 4: Creating a Scorecard Chart

Chapter 9: Working with Graphics

Lecture 1: Inserting Images

Lecture 2: Creating Drawings

Chapter 10: Conclusion

Lecture 1: Course Recap

Chapter 11: Assessment Quiz

Instructors

Intellezy Trainers
Multi-Award-Winning eLearning Specialists

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 6 votes
5 stars: 23 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu