30-days Money-Back Guarantee
In-depth study of Functions, features and everything about Google sheets
Updated on Sep, 2026
Office Productivity, Google, Google Sheets
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
This course, as of date, has 14 Sections - A complete training on G sheets.
You will learn everything about Google SHEETS- What are the fundamentals and how is it different from the Microsoft Excel application.
You will learn Basic, intermediate, and advanced functions like sum, average, count, sumif, sumifs, countif,countifs, indirect, offset, vlookup, match,hlookup.
You will learn text functions from basic to advanced, including their practical use -Left, Right, Mid, Find, Search, Substitute, Split, concatenate, and Join functions.
How to share the sheets with others - how to provide read-only or read-write rights.
You will be able to do simple, complex data structuring and analysis using Features like filtering, sorting the data, and filtering views.
How to use SORT, UNIQUE functions with Filter.
How to use Data Validations, Data Importing, CHARTS, Conditional Formatting, PIVOTS, Date and Time functions.
There are quizzes included in the course from time to time to help you get ready for real data challenges.
How to use one function inside another function and create long, complex formulas like vlookup with the match function, Index with the match functions.
How to use mix Text functions with index or Vlookup. How to use the CountIFs function with lookup functions and any type of combination you can think of.
Create surveys for the team, collect data via Google Forms, and take your data analysis to a new level.
How to use the Query function and retrieve data like a pro using Select SQL Syntax.
How to do web scraping using Google Functions ImportXML, ImportHTML - It is amazing.
You need to have internet and a Gmail ID, nothing else is required.
Check out the detailed breakdown of what’s inside the course
I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.