Google Sheets Basics: An Introduction to Google Sheets

Focused View

Simon Sez IT

4:07:47

8 View

1. Introduction

1. Course Introduction.mp4

05:02

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Exercise Files [Google Sheets Basics].zip

3. DOWNLOAD ME Exercise Files.html

4.1 Instructor Files [Google Sheets Basics].zip

4. DOWNLOAD ME Instructor Files.html

5. Accessing Google Sheets.mp4

07:49

6. Its Just Google.mp4

04:39

7. Section Quiz.html

2. Start It

1. Orientation.mp4

04:19

2. Cells.mp4

06:34

3. Rows & Columns - Part 1.mp4

05:40

4. Rows & Columns - Part 2.mp4

06:20

5. Theme.mp4

07:10

6. Formatting - Part 1.mp4

06:27

7. Formatting - Part 2.mp4

08:32

8. Exercise 01.mp4

06:19

9. Section Quiz.html

3. Insert It

1. Insert Links.mp4

05:36

2. Insert Images.mp4

08:36

3. Insert Drawings.mp4

09:43

4. Insert Checkboxes.mp4

09:04

5. Insert Notes & Comments.mp4

08:36

6. Exercise 02.mp4

04:07

7. Section Quiz.html

4. Organize It

1. Data Cleanup.mp4

06:26

2. Conditional Formatting Part 1.mp4

07:47

3. Conditional Formatting Part 2.mp4

06:50

4. Drop-down in Cells.mp4

09:40

5. Data Validation.mp4

04:31

6. Exercise 03.mp4

05:18

7. Section Quiz.html

5. Work with It

1. Sort & Filter.mp4

09:09

2. Basic Formulas.mp4

07:40

3. Basic Functions.mp4

08:34

4. Query Function.mp4

09:06

5. Multiple Sheets.mp4

04:01

6. Exercise 04.mp4

03:52

7. Section Quiz.html

6. Graph It

1. Types of Charts & Graphs.mp4

09:23

2. Edit & Customize Charts Part 1.mp4

05:26

3. Edit & Customize Charts Part 2.mp4

06:59

4. Exercise 05.mp4

06:57

5. Section Quiz.html

7. Share It

1. Share & Collaborate Part 1.mp4

07:04

2. Share & Collaborate Part 2.mp4

05:05

3. Download, Print or Publish.mp4

02:47

4. Exercise 06.mp4

02:21

5. Section Quiz.html

8. Closing

1. Course Wrap Up.mp4

02:07

Description

Get started with Google Sheets with this comprehensive course for absolute beginners

What You'll 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 is this for?

Google Sheets novice

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

What You Need to Know?

A Google account to access Google Sheets

No previous knowledge of Google Sheets required. This course is created for absolute beginners.

More details

Description
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 files to follow along
Certificate of completion
Who this course is for:
Google Sheets novice
Those who want to use a web-based spreadsheet as an alternative to Excel.

User Reviews

Rating

average 0

Total votes0

Focused display

Google Sheets

Simon Sez IT

Instructor's Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.