The Complete Google Sheets Course - Google Spreadsheet Tips
All LevelsOffice ProductivityGoogle Sheets

The Complete Google Sheets Course - Google Spreadsheet Tips

Learn Google Sheets from Beginner to Advanced - Learn Pivot Tables - Graphs -Dashboards - & More!

Created by TJ Walker, Jan Ekhteyari, Media Training Worldwide Digital
4 hours
Video Content
53
Lectures
40,779
Students
4.4
Rating
4.4
(40,779 students enrolled)

What you'll learn

βœ“Google Account Creation
βœ“Environment Of Google Sheets
βœ“Cells, Sheets, And Spreadsheets
βœ“Share Your Google Sheets
βœ“Tools Of Google Sheets
βœ“Shortcut For Google Sheets
βœ“Manages files in File Menu Of Google Sheets
βœ“Edit Stuff in Edit Menu Intro of Google Sheets
βœ“Change the view and all in View Menu In Google Sheets
βœ“Text, Images, Objects, Tables, Graphs in Google Sheets
βœ“Chart in Google Sheets
βœ“Pivot Table in Google Sheets
βœ“Functions in Google Sheets
βœ“Salary table in Google Sheets
βœ“Currency Converter in Google Sheets
βœ“Slicers Google Sheets in Pivot
βœ“Google Form
βœ“A Form and Adding Questions
βœ“Customize Google Form
βœ“View response in Google form and analyze
βœ“Collaborate and Send in Google Form
βœ“Quizzes Mode with Google Form

Course Content

7 sections β€’ 53 lectures β€’ 03:47:37 total length

You Can Master Google Sheets

6 lectures β€’ 04:10

You Can Master Google Sheets01:36
Quick Remainder - You Can Ask Me Always00:29
Another Quick Remainder - Join Your Facebook Support Community00:30
Quick Win - Open Google Sheets Instantly00:22
Another Quick Win - How to work professionally in Google Sheets00:38
+1 more lectures

Getting Started with Google Sheets

8 lectures β€’ 42:34

What's Google Sheets?04:16
How To Create A Google Account If You Don't Have Already04:23
Environment Of Google Sheets And Necessary Options07:13
Cells, Sheets And Spreadsheets04:52
Sharing Your Google Sheets For Someone03:39
+3 more lectures

Google Sheets Menu

10 lectures β€’ 01:17:11

File Menu Of Google Sheets08:52
Edit Menu Intro of Google Sheets05:52
Edit Full Guide with Paste Special01:50
Edit Full Guide with Paste Special08:59
View Menu In Google Sheets07:54
+5 more lectures

Classwork (Google Sheets)

8 lectures β€’ 49:09

Functions in Google Sheets09:14
Google Sheets Salary (Part 1)07:40
Google Sheets Salary (Part 2)07:24
Google Sheets Currency Converter06:29
Google Sheets Chart Example05:27
+3 more lectures

Google Sheets Tempalte

9 lectures β€’ 17:12

Google Sheets Template Intro01:18
Google Calendar in Google Sheets03:02
To do list in Google Sheets02:07
Annual budget in Google Sheets02:23
Monthly Budget in Google Sheets01:35
+4 more lectures

Google Forms

10 lectures β€’ 35:57

Quick Win - Change Your Google Forum to Quiz Mode00:27
Quick Win - Make Your Google Forum Cover Personalized02:01
File Menu Of Google Sheets08:52
Google Forms Overview02:11
Creating A Form and Adding Questions08:58
+5 more lectures

Conclusion

2 lectures β€’ 01:24

Congratulations00:25
Bonus Lecture00:59

Description

The Complete Google Sheets Course - Google Spreadsheet Tips: Learn Google Sheets from Beginner to Advanced - Learn Pivot Tables - Graphs -Dashboards - More!

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep. Wikipedia

We can do much cool stuff in Google Sheets, Collaborate on data, from anywhere Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.

Get to insights faster with built-in intelligence, Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors. And get insights quickly by asking questions about your data in simple language.

Seamlessly connect to other Google apps, Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.

Extend collaboration and intelligence to Excel files Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill. (Google)

Another three Google futures:

  1. Build custom solutions

  2. Always work with fresh data

  3. Seamlessly connect to critical data

In this course, IΒ focused on teaching stuff you need to know to understand for personal use and business use. We are going to learn all the options, and tricks and put them all into cool projects.

By taking this The Complete Google Sheets Course - Google Spreadsheet Tips you will be able to:


  • Create A Google Account

  • Work with the Environment Of Google Sheets

  • Work Cells, Sheets, And Spreadsheets

  • Share Your Google Sheets With Someone

  • Work with Tools Of Google Sheets

  • Install and Create Shortcut For Google Sheets

  • Manages files in the File Menu Of Google Sheets

  • Learn to edit stuff in the Edit Menu Intro of Google Sheets

  • Change the view and all in View Menu In Google Sheets

  • Insert text, images, objects, tables, and graphs in Google sheets

  • Insert Chart in Google Sheets

  • Create Pivot Table in Google Sheets

  • Use Functions in Google Sheets

  • Create a Salary table in Google Sheets

  • Create Currency Converter in Google Sheets

  • Create Slicers Google Sheets in Pivot

  • Google Form

  • Creating A Form and Adding Questions

  • Customize Google Form

  • View the response in Google form and analyze

  • Collaborate and Send in Google Form

  • Quizzes Mode with Google Form

  • ...



Don't wait any longer, join The Complete Google Sheets Course -
Google Spreadsheet Tips now and start learning and making new experiences!

Who this course is for:

  • Everyone
  • Students
  • Teachers
  • Mentors
  • Employee
  • IT

This course includes:

  • 4 hours on-demand video
  • 1 articles
  • 0
  • Access on mobile and TV
  • ∞Full lifetime access
  • Certificate of completion

Instructors

TJ Walker

Jan Ekhteyari

Media Training Worldwide Digital

Students also download

Explore related courses to expand your learning journey.