Google Sheets Tutorial 2023 - Beginner To Expert in 6 Hours

Focused View

Todd McLeod

5:55:48

46 View

1. Course information

1.1 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

1. Welcome.mp4

06:54

2.1 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

2.2 Here is a Google Drive folder with all of the files..html

2. Using the course files.mp4

04:16

3.1 All of the files for this google sheets course can be found here.html

3.2 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

3. All of the course files are here.html

4.1 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

4. Getting your certificate.mp4

01:56

2. An introduction to Google Sheets

1.1 All course files.html

1.2 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

1. Understanding Google Sheets.mp4

06:12

2.1 All course files.html

2. Two essential skills files And moving files.mp4

04:11

3.1 All of the course files.html

3. Opening Google Sheets and creating a file.mp4

06:45

4.1 All of the course files.html

4. File operations with Google Sheets.mp4

05:41

5.1 All of the course files.html

5. A brief preview of sharing a Google Sheet.mp4

03:14

6.1 All of the course files.html

6. Google drive, sheets, excel, And file extensions.mp4

03:40

7.1 All of the course files.html

7. Exploring Google Sheets interface.mp4

06:51

8.1 All of the course files.html

8. Keyboard shortcuts.mp4

03:48

3. Hands-on exercises

1.1 All of the course files.html

1.2 Here is a link to the file!.html

1. Hands-on exercise #1.mp4

02:49

4. Getting started with Google Sheets

1.1 All of the course files.html

1. A cool preview of Google Docs.mp4

02:04

2.1 All of the course files.html

2. Managing files in Google Drive.mp4

05:07

3.1 All of the course files.html

3. Mouse pointer awareness.mp4

04:31

4.1 All of the course files.html

4. Adding data to Google Sheets.mp4

07:26

5.1 All of the course files.html

5. Formatting numbers in Google Sheets.mp4

07:34

6.1 All of the course files.html

6. Making selections in Google Sheets.mp4

03:08

7.1 All of the course files.html

7. Using the status bar for quick answers.mp4

02:33

8.1 All of the course files.html

8. Managing files in Google Drive.mp4

02:56

5. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercise #2.mp4

06:33

2.1 All of the course files.html

2. Hands-on exercise #3.mp4

03:18

6. The fundamentals of spreadsheets

1.1 All of the course files.html

1. Writing a formula.mp4

05:02

2.1 All of the course files.html

2. Relative And absolute references.mp4

06:16

3.1 All of the course files.html

3. Creating a gradebook.mp4

04:55

4.1 All of the course files.html

4. Creating charts.mp4

05:33

7. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercise #4.mp4

05:10

2.1 All of the course files.html

2. Hands-on exercise #5.mp4

04:39

8. Working with functions in Google Sheets

1.1 All of the course files.html

1. An introduction to functions.mp4

03:13

2.1 All of the course files.html

2. The sum function And range notation.mp4

04:43

3.1 All of the course files.html

3. Exploring functions and documentation.mp4

08:53

4.1 All of the course files.html

4. Using the average function And documentation.mp4

03:50

5.1 All of the course files.html

5. Creating a gradebook with the functions.mp4

03:22

6.1 All of the course files.html

6. Using the max and min functions, And documentation.mp4

06:59

7.1 All of the course files.html

7. Using the rand and randbetween functions, And documentation.mp4

04:47

8.1 All of the course files.html

8. Comparing concat and concatenation, And documentation.mp4

06:11

9.1 All of the course files.html

9. Using the textjoin function And documentation.mp4

06:48

10.1 All of the course files.html

10. Splitting text on a delimiter and using textjoin.mp4

03:45

11.1 All of the course files.html

11. Using xlookup, and not using vlookup And hlookup.mp4

06:37

9. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercises #6.mp4

05:49

2.1 All of the course files.html

2. Hands-on exercises #7.mp4

02:59

3.1 All of the course files.html

3. Hands-on exercise #8.mp4

02:11

4.1 All of the course files.html

4.2 Here is a poem.html

4. Hands-on exercise #9.mp4

02:42

5.1 All of the course files.html

5. Hands-on exercise #10.mp4

02:12

6.1 All of the course files.html

6. Hands-on exercises #11.mp4

02:42

10. Progressing with Google Sheets

1.1 All of the course files.html

1. Inserting And deleting columns And rows.mp4

03:27

2.1 All of the course files.html

2. Moving columns, rows, ranges, and cells.mp4

01:55

3.1 All of the course files.html

3. Managing your worksheets in Google Sheets.mp4

01:07

4.1 All of the course files.html

4. Freezing rows And columns.mp4

02:21

5.1 All of the course files.html

5. Hiding rows And columns.mp4

01:57

6.1 All of the course files.html

6. Working with versions.mp4

04:05

11. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercise #12.mp4

03:33

12. Formatting in Google Sheets

1.1 All course files.html

1. Formatting And feeling.mp4

05:12

2.1 All course files.html

2. Changing font formatting.mp4

05:51

3.1 All course files.html

3. Adding border And fill formatting.mp4

06:17

4.1 All course files.html

4. The paintbrush formatting tool.mp4

02:13

5.1 All course files.html

5. Alternating colors (row striping).mp4

01:43

6.1 All course files.html

6. Conditional formatting.mp4

02:47

7.1 All course files.html

7. Table formatting.mp4

04:47

13. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #13.mp4

04:53

14. Importing And exporting files with Google Sheets

1.1 All course files.html

1. Converting Microsoft Excel files to Google Sheets.mp4

03:56

2.1 All course files.html

2. Exporting Google Sheets to Microsoft Excel.mp4

01:49

3.1 All course files.html

3.2 Gapminder Data.html

3.3 Gapminder Tools.html

3. Importing other files types into Google Sheets.mp4

04:01

4.1 All course files.html

4.2 GapMinder Tools.html

4. My favorite statistical site.mp4

02:22

15. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #14.mp4

01:21

16. Working with data in Google Sheets

1.1 All course files.html

1. Gathering data with a form.mp4

04:24

2.1 All course files.html

2. Generating data - The Outdoor Gear Coop.mp4

03:17

3.1 All course files.html

3. Generating data - the name generator.mp4

04:57

4.1 All course files.html

4. Removing duplicates.mp4

02:12

5.1 All course files.html

5. Filtering data.mp4

03:52

6.1 All course files.html

6. Sorting data.mp4

05:48

17. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #15.mp4

02:23

18. Pivot tables

1.1 All course files.html

1. An introduction to pivot tables.mp4

03:07

2.1 All course files.html

2. Exploring different pivot tables.mp4

03:51

3.1 All course files.html

3. Pivot charts.mp4

02:28

4.1 All course files.html

4. Pivot tables, charts, and slicers.mp4

02:31

19. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #16.mp4

02:03

20. Macros

1.1 All course files.html

1. Introduction to macros.mp4

05:17

2.1 All course files.html

2. Another macro example.mp4

04:15

21. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #17.mp4

03:10

22. Printing, sharing, And collaborating in Sheets

1.1 All course files.html

1. Printing your Google Sheets.mp4

06:57

2.1 All course files.html

2. Sharing a Google sheet.mp4

03:50

3.1 All course files.html

3. Working with others on a Google Sheet.mp4

05:21

4.1 All course files.html

4. Protecting a Google Sheet.mp4

04:33

5.1 All course files.html

5. Using data validation to ensure valid data.mp4

02:32

23. Congratulations

1. Great work!.mp4

01:55

2. Bonus lecture.mp4

00:43

Description

Google Sheets Made Easy - Expert Instructor with 25 Years of Experience - Quickly Learn The Fundamentals of Spreadsheets

What You'll Learn?

The Ultimate Google Sheets Course - Master Google Sheets - formulas and functions - shortcuts and tips - charts and graphs - for beginners to advanced users
Taught by a best-selling Udemy author, Udemy Instructor Partner, & Tenured College Professor with 25 years of experience teaching people how to use spreadsheets
From the fundamentals to advanced features, this training will give you a strong foundation in Google Sheets: formulas, functions, pivot tables, and macros
Presented in high-quality video lectures, this Google Sheets course will allow you to master Google Sheets and be skilled with all spreadsheets everywhere
A comprehensive 53 page course outline is included in the course, along with lifetime access, allowing you to review material any time and learn new material
Hands-on exercises with video solutions, including all Google Sheets files, allow you to apply what you are learning and grow your skills with Google Sheets
Master using Google Sheets functions including range references, sum, min, max, average, rand, randbetween, concat, textjoin, and xlookup (the new vlookup)
Included in the course are Google Sheets charts, graphs, formatting, relative and absolute references, creating a gradebook, and conditional formatting
Also included in the course: managing Google sheets, freezing rows and columns, hiding rows and columns, working with versions, tables, and row striping
Collaborating in Google Sheets is also covered in this course along with sharing Google Sheets and protecting Google Sheets at various levels of security
Gathering data from external sources using Google Forms is also covered along with importing and exporting files, generating mock data, and removing duplicates
Working with data in Google Sheets is covered also along with filtering data, sorting data, freeze panes, pivot tables, pivot charts, slicers, and macros
Over 400,000 students taught, Lifetime course access, Hands-on exercises with solutions
100% satisfaction guaranteed, Learn at your own pace, This course is tested and proven

Who is this for?

This Google Sheets course is for beginner and intermediate spreadsheet users who want to master Google Sheets and spreadsheets!

What You Need to Know?

No prior experience is needed. This Google Sheets course is great for beginners!

More details

Description
This training provides you everything you need to know about Google Sheets.
From the fundamentals, to advanced features, after taking this online class you will be able to use Google Sheets at an expert level.
You can learn Google Sheets easily and quickly if it is taught correctly. Developed by a professor with over 25 years of experience teaching individuals of all ability levels "how to use" spreadsheets, Todd McLeod has designed, refined, and perfected this course to make it easy for you to master Google Sheets.
In only six hours of video lectures, provided to you in 88 separate lectures so that no one video is too long, you will learn all of the following about Google Sheets:
Learn to navigate around Google Sheets
Learn to enter and edit data in Google Sheets
Learn to adjust the way data and information are displayed in Google Sheets
Learn to write formulas quickly and easily with the point-and-click method
Learn to use relative, absolute, and mixed references in Google Sheets
Learn to create powerful calculations with Google Sheets functions
Learn to use documentation so that you can work with every function
Learn to visually represent your data with charts in Google Sheets
Learn to use Google Sheets data tools like sorting and filtering
Learn to "freeze columns and rows" with freeze panes in Google Sheets
Learn to remove duplicates from data in Google Sheets
Learn to use Google Sheets to leverage data with Pivot Tables & Slicers
Learn to format worksheets including conditional formatting
Learn to automate Google Sheets tasks with time-saving macros
Learn to use passwords in Google Sheets to protect your work in multiple scenarios
Learn tips, tricks, and shortcuts in Google Sheets
Learn to use printing and sharing in Google Sheets
Learn to gather data with Google Forms and have the data put into Google Sheets
Learn to create powerful random data generators
Learn to use freeze panes, sorting, and filtering
Learn to print your worksheets with various formatting
Access all of the Google Sheets files used in the videos!
This class is guaranteed to teach you Google Sheets.
Described as â€œfun,â€ â€œamazing,â€ and â€œlife changing,â€ this Google Sheets training will forever transform the way you work with spreadsheets. Try this course for yourself and see how easy it is to master Google Sheets.
Who this course is for:
This Google Sheets course is for beginner and intermediate spreadsheet users who want to master Google Sheets and spreadsheets!

User Reviews

Rating

average 0

Total votes0

Focused display

Google Sheets

Todd McLeod

Instructor's Courses

Fun, Quick, & EasyLearning can be fun, quick, and easy if you have the right teacher. I come from a family of teachers, I've taught at the college and university level for over 20 years, and I have been recognized as one of the top teachers in the California college system. I became a teacher because I love sharing knowledge and seeing how it transforms people's lives. Learning is the noblest of all endeavors. The more you learn, the more you improve your life.Learn Quickly & Effectively All of my courses include step-by-step tutorials and hands-on exercises. The tutorials show you what to do. The hands-on exercises allow you to practice what you have just seen. These hands-on exercises also come with all of the files you need and video solutions so that you can learn more quickly and effectively.Great Courses for BeginnersI work with beginners all of the time. I understand how to take topics and make them easy to understand.The Human ElementStudents do better in classes where they enjoy the teacher. I am a bit goofy at times but this keeps my courses fun, interesting, and engaging. When you are learning with me, you are guaranteed to have a few laughs.Traditional Credentials I am a tenured professor in California, an autodidact, and multidisciplinarian. I have taught at the graduate and undergraduate levels in business, information system, and computer science. I also have a lot of knowledge about mindfulness, meditation, psychology, and personal growth. I was born into a culture of mindfulness and meditation, and have been involved with mindfulness and meditation all of my life. I have authored 48 books and have experience with the publishing industry, literature, and film. As I said, I love learning and love sharing knowledge with others.I look forward to seeing you in class!

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.