Google Sheets-Basic to Super Advance with Practical (15hrs)
In-depth study of Functions, features and everything about Google sheets
Updated on Jun, 2025
Language - English
Office Productivity,Google,Google Sheets
Lectures -69
Resources -8
Duration -15 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
- This course will educate you about how to work with Google Sheets and you shall know every small & big feature, formula about using it
- How to begin with Google Sheets – from installing to using it.
- How to use features like Cut paste, copy paste, insert rows, insert columns, sort data, filter data
- How to insert sheets, delete, rename sheets, protect the data
- How to create duplicate copies of sheets or google sheet as a whole
- How to share sheets with other colleagues in the office
- How to set up the language based on your country
- How to use Filter Views
- Learn Sort and filter functions.
- How to lookup the data using VLOOKUP, MATCH, TRIM, and INDEX functions
- How to join more than one function and make a single large complex formula
- How to use LARGE, and SMALL functions with other functions like FILTER and SORT
- How to use logical functions like IF, IFAND, IFOR, and new function IFS with the difference between them
- How to use Error handlers like IFERROR & IFISERROR. – Use them with other lookup functions
- How to use VLOOKUP inside VLOOKUP and in fact more than 3 VLOOKUPs in one formula
- Know your Date and Time functions
- How to use INDIRECT Function – the most amazing and helpful function in sheets
- How to define Name range and their practical use in G sheets
- How to create drop-down and dynamic drop-down – two or three-level dynamic drop-down with the help of INDEX and FILTER
- How to restrict data from entering anything you do not want by using data validation features
- Practical Quizzes from time to time to monitor your preference
- How to do data analysis using Charts – Basic to advanced – column chart, line chart, pie, doughnut chart, combo chart, scorecard chart, table chart etc.
- How to control data using SLICERS
- How to summarize data using Pivots and Slicers
- Create an Awesome Dashboard that uses all functions and features.
- How to use SQL Query in Google Sheets
- How to work with websites to import their data into sheets. Web scraping without any programming. IMPORTXML/HTML
- Last but not least, there are so many projects for your help to understand how all of this knowledge is used in Google Sheets.
Who this course is for:
- Students who work with data all day create reports and do the analysis on different levels.
- Google Sheets is now emerging as a favorite spreadsheet among Data analysts and because it is a free spreadsheet and can be updated online, it is much in demand than ever before.
Goals
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 it is different from 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 function
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 filter 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 in getting ready for real data challenges.
How to use one function inside another function and create a long, complex formulas like vlookup with match function, Index with match functions
How to use mix Text functions with index or Vlookups. How to use 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 Synatax
How to do web scraping using Google Functions ImportXML, ImportHTML - It is amazing
Prerequisites
You need to have internet and gmail id . Nothing else is required.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction to Google Sheet Environment
3 Lectures
-
Get Inside the Google Sheet and Start working
32:54
32:54
-
First and Foremost Rule to learn- Use Dollar sign in locking the formulas
28:27
28:27
-
Basic Functions - Let us begin
19:34
19:34
Your LOOKUP Functions- Forward and Reverse
3 Lectures
Logical Functions - IF & New IFS function - Basic to Advance
4 Lectures
Error Handlers - Ignore errors and do meaningful things
2 Lectures
TEXT Functions - Helps in Data Extraction, replacements and Finding values
5 Lectures
Sort and Filters - Useful for Data Reporting
8 Lectures
Name Ranges & Data Validation - Data Control and Data Restrictions
4 Lectures
Count & Sum Family Functions - Complex Calculations made Easy
6 Lectures
CHARTS - A wonderful way to visualize your Data
8 Lectures
Excellent PIVOTS- Create Dashboards and Summaries of reports
9 Lectures
QUERY - Fetch Data Using SQL Syntax -Its awesome
5 Lectures
Sharing the files and integration with other applications
4 Lectures
Languages and Translations - Unite the World under one roof.
1 Lectures
WebScraping Using IMPORTXML and HTML - What a great Function created by Google.
6 Lectures
Case Study - One example -Import excel data into Google sheets
1 Lectures
Instructor Details
ajay parmar
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.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now