Google Sheets Basics: An Introduction to Google Sheets

Google Sheets Basics: An Introduction to Google Sheets, available at $69.99, has an average rating of 4.25, with 44 lectures, 7 quizzes, based on 20 reviews, and has 86 subscribers.

You will learn about Different ways of accessing Google Sheets and getting familiar with the Google Sheets interface Working with cells, rows, and columns, including group and merge PC and Mac keyboard shortcuts How to apply themes, formatting, and conditional formatting Inserting images, links, checkboxes, comments, and notes Making use of Google Drawings to insert videos and drawings Adding data validations and dropdown selections How to sort and filter data in Google Sheets and working with multiple sheets An overview of basic formulas and functions and how to use the Query function Creating charts and graphs, learning different chart types, editing, and customizing charts Sharing your sheet and collaborating with other users Publishing, downloading, and printing Google Sheets files This course is ideal for individuals who are Google Sheets novice or Those who want to use a web-based spreadsheet as an alternative to Excel. It is particularly useful for Google Sheets novice or Those who want to use a web-based spreadsheet as an alternative to Excel.

Enroll now: Google Sheets Basics: An Introduction to Google Sheets

Summary

Title: Google Sheets Basics: An Introduction to Google Sheets

Price: $69.99

Average Rating: 4.25

Number of Lectures: 44

Number of Quizzes: 7

Number of Published Lectures: 41

Number of Published Quizzes: 7

Number of Curriculum Items: 51

Number of Published Curriculum Objects: 48

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Different ways of accessing Google Sheets and getting familiar with the Google Sheets interface
Working with cells, rows, and columns, including group and merge
PC and Mac keyboard shortcuts
How to apply themes, formatting, and conditional formatting
Inserting images, links, checkboxes, comments, and notes
Making use of Google Drawings to insert videos and drawings
Adding data validations and dropdown selections
How to sort and filter data in Google Sheets and working with multiple sheets
An overview of basic formulas and functions and how to use the Query function
Creating charts and graphs, learning different chart types, editing, and customizing charts
Sharing your sheet and collaborating with other users
Publishing, downloading, and printing Google Sheets files

Who Should Attend

Google Sheets novice
Those who want to use a web-based spreadsheet as an alternative to Excel.

Target Audiences

Google Sheets novice
Those who want to use a web-based spreadsheet as an alternative to Excel.

**This course includes course instructor files and exercise files to work with and follow along.**

Discover how to use Google’s popular online spreadsheet application with this comprehensive beginner 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 have all your changes saved 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 sheet 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 Drawing.

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 would like to get started with spreadsheets and 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 used in the tutorial so you can follow along.

What you’ll learn from this course:

Different ways of accessing Google Sheets
Getting familiar with the Google Sheets interface
Working with cells, rows, and columns, including group and merge
PC and Mac keyboard shortcuts
How to apply themes, formatting, and conditional formatting
Inserting images, links, checkboxes, comments, and notes
Making use of Google Drawing to insert videos and drawings
Adding data validations and dropdown selections
How to sort and filter data in Google Sheets
An overview of basic formulas and functions
How to use the Query function
Working with multiple sheets
Creating charts and graphs and learning different chart types
Editing and customizing charts
Sharing your sheet and collaborating with other users
Publishing, downloading, and printing Google Sheets files

This course includes:

4 hours of video tutorials
38 individual video lectures
Course and exercise filesto follow along
Certificate of completion

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Exercise Files

Lecture 4: DOWNLOAD ME: Instructor Files

Lecture 5: Accessing Google Sheets

Lecture 6: It's Just Google

Chapter 2: Start It

Lecture 1: Orientation

Lecture 2: Cells

Lecture 3: Rows & Columns – Part 1

Lecture 4: Rows & Columns – Part 2

Lecture 5: Theme

Lecture 6: Formatting – Part 1

Lecture 7: Formatting – Part 2

Lecture 8: Exercise 01

Chapter 3: Insert It

Lecture 1: Insert Links

Lecture 2: Insert Images

Lecture 3: Insert Drawings

Lecture 4: Insert Checkboxes

Lecture 5: Insert Notes & Comments

Lecture 6: Exercise 02

Chapter 4: Organize It

Lecture 1: Data Cleanup

Lecture 2: Conditional Formatting: Part 1

Lecture 3: Conditional Formatting: Part 2

Lecture 4: Drop-down in Cells

Lecture 5: Data Validation

Lecture 6: Exercise 03

Chapter 5: Work with It

Lecture 1: Sort & Filter

Lecture 2: Basic Formulas

Lecture 3: Basic Functions

Lecture 4: Query Function

Lecture 5: Multiple Sheets

Lecture 6: Exercise 04

Chapter 6: Graph It

Lecture 1: Types of Charts & Graphs

Lecture 2: Edit & Customize Charts: Part 1

Lecture 3: Edit & Customize Charts: Part 2

Lecture 4: Exercise 05

Chapter 7: Share It

Lecture 1: Share & Collaborate: Part 1

Lecture 2: Share & Collaborate: Part 2

Lecture 3: Download, Print or Publish

Lecture 4: Exercise 06

Chapter 8: Closing

Lecture 1: Course Wrap Up

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 4 votes
4 stars: 8 votes
5 stars: 8 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