This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
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 Overview
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:
-
Build custom solutions
-
Always work with fresh data
-
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, tricks and put them all in cool projects.
By taking this The Complete Google Sheets Course - Google Spreadsheet Tips you will be able to:
-
Create A Google Account
-
Work with Environment Of Google Sheets
-
Work Cells, Sheets, And Spreadsheets
-
Share Your Google Sheets For Someone
-
Work with Tools Of Google Sheets
-
Install and Create Shortcut For Google Sheets
-
Manages files in File Menu Of Google Sheets
-
Learn to edit stuff in Edit Menu Intro of Google Sheets
-
Change the view and all in View Menu In Google Sheets
-
Insert text, images, objects, tables, graphs in Google sheets
-
Insert Chart in Google Sheets
-
Create Pivot Table in Google Sheets
-
Use Functions in Google Sheets
-
Create 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 response in Google form and analyze
-
Collaborate and Send in Google Form
-
Quizzes Mode with Google Form
-
...
So don't hesitate anymore,
Join us now to make new experiences with The Complete Google Sheets Course - Google Spreadsheet Tips today!
This Google Sheets course is ideal for anyone searching for more info on the following: google sheet - google spreadsheet - sheets - data entry - spreadsheet. Plus, this course will be a great addition to anyone trying to build out their knowledge in the following areas: Google Workspace (G Suite) - Google Apps Script - Google Docs - Google Forms.
Pre-requisites
- No Previous Experience Necessary!
- Willingness to Learn :)
Target Audience
- Everyone
- Students
- Teachers
- Mentors
- Employee
- IT
Curriculum 54 Lectures 03:08:01
Section 1 : You Can Master Google Sheets
- Lecture 2 :
- Another Quick Win - How to work professionally in Google Sheets
- Lecture 3 :
- Another Quick Win - How to freeze a row or column in Google Sheets
Section 2 : Getting Started with Google Sheets
- Lecture 1 :
- What's Google Sheets-1
- Lecture 2 :
- How To Create A Google Account If You Don't Have Already-2
- Lecture 3 :
- Environment Of Google Sheets And Necessary Options
- Lecture 4 :
- Cells, Sheets And Spreadsheets
- Lecture 5 :
- Sharing Your Google Sheets For Someone
- Lecture 6 :
- Basic Of Tools Of Google Sheets Part 1
- Lecture 7 :
- Basic Of Tools Of Google Sheets Part 2
- Lecture 8 :
- Install And Creating Shortcut For Google Sheets
Section 3 : Google Sheets Menu
- Lecture 1 :
- File Menu Of Google Sheets
- Lecture 2 :
- Edit Full Guide with Paste Special
- Lecture 3 :
- View Menu In Google Sheets
- Lecture 4 :
- Extensions
- Lecture 5 :
- Insert Intro
- Lecture 6 :
- Insert Menu Chart in Google Sheets
- Lecture 7 :
- Macro
- Lecture 8 :
- Pivot Table in Google Sheets
- Lecture 9 :
- Insert Outro in Google Sheets
- Lecture 10 :
- Edit Menu Intro
- Lecture 11 :
- Functions in Google Sheets
- Lecture 12 :
- Format menu in Google Sheets
- Lecture 13 :
- Data menu in Google Sheets
- Lecture 14 :
- Google Tools Option
Section 4 : Classwork
- Lecture 1 :
- Date Validation
- Lecture 2 :
- Slicers Google Sheets in Piviot
- Lecture 3 :
- Piviot Table in Google Sheet
- Lecture 4 :
- Google Sheets Salary (Part 1)
- Lecture 5 :
- Google Sheets Currency Converter
- Lecture 6 :
- Basic Functions with Google Sheets
- Lecture 7 :
- Google Sheets Chart Example
- Lecture 8 :
- Google Sheets Salary (Part 2)
- Lecture 9 :
- Functions in Google Sheets
Section 5 : Google Sheets Template
- Lecture 1 :
- Google Sheets Template Intro
- Lecture 2 :
- Google Calendar in Google Sheets
- Lecture 3 :
- To do list in Google Sheets
- Lecture 4 :
- Annual budget in Google Sheets
- Lecture 5 :
- Monthly Budget in Google Sheets
- Lecture 6 :
- Google Finance Investment in Google Sheets
- Lecture 7 :
- Daily Schedule in Google Sheets
- Lecture 8 :
- Travel Planner in Google Sheets
- Lecture 9 :
- Conclusion of Template in Google Sheets
Section 6 : Google Forms
- Lecture 1 :
- Qucik win - change your google forum to quiz mode
- Lecture 2 :
- Quick win - make your Google Forum Cover personalized
- Lecture 3 :
- File Menu Of Google Sheets
- Lecture 4 :
- Google Forms Overview
- Lecture 5 :
- Creating A Form and Adding Questions
- Lecture 6 :
- Google Form Preview and Theme Customization
- Lecture 7 :
- Google Form Response
- Lecture 8 :
- Collaboration and Send in Google Form
- Lecture 9 :
- Google Form Gear Icon Settings
- Lecture 10 :
- Quizzes Mode with Google Form
Section 7 : Conclusion
- Lecture 1 :
- Conclusion
Our learners work at
Frequently Asked Questions
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.Is there any free trial?
Currently, we do not offer any free trial.Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
605022 Course Views
15 Courses