Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Google Sheets-Basic to Super Advance with Practical’s(15hrs)

In-depth study of Functions, features and everything about G sheets
5.0
☆☆☆☆☆ 5.0/5
(4 reviews)
35 students
Created by
ajay parmar

10.0

Classbaze Grade®

9.9

Freshness

9.7

Popularity

9.7

Material

Detailed Analysis »

In-depth study of Functions
Go to course »
Platform: Udemy
Price: check current price
Video: 15h 20m
Language: English
Next start: On Demand

Best Google Sheets classes:

Skillshare_logo_2020
Best Google Sheets classes on Skillshare »
Coursera Logo
Best Google Sheets classes on Coursera »
Pluralsight Logo
BestGoogle Sheets classes on PluralSight »
Udemy logo
Best Google Sheets classes on Udemy »
linkedin
Best Google Sheets classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

10.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

9.9 / 10
This course was last updated on 3/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

9.7 / 10
We analyzed factors such as the rating (5.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.7 / 10
Video Score: 9.9 / 10
The course includes 15h 20m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.7 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
1 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

•This course will educate you about how to work with Google sheets. It has 14 sections as on date covering every minute detail about Sheets.
•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 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, SMALL function 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 infact 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 time to time to monitor your preference
•How to do data analysis using Charts – Basic to advance – 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 which uses above all functions and features.
•How to use SQL Query in Google sheets
•How to work with websites to import their data into sheets. Webscraping 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.
•24*7 Support is available to answer your queries

What can you learn from this course?

✓ This course as on 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 advance functions like sum, average, count, sumif,sumifs, countif,countifs,indirect, offset, vlookup,match,hlookup
✓ You will learn text functions from basic to advance 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 analayis using Features like Filter, 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 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 team and collect data via google forms and take your data analysis onto a new level
✓ How to use Query function and retrieve data like a pro using Select SQL Synatax
✓ How to do WebScraping using Google Functions ImportXML, ImportHTML – Its amazing

What you need to start the course?

• You need to have internet and gmail id . Nothing else is required.

Who is this course is made for?

• Students who work with data all the day and create reports and do the analysis on different levels.
• Google Sheet is now emerging as a favorite spreadsheet among Data analysts and because it is a free spreadsheet and can update online , it is much in demand than ever before.

Are there coupons or discounts for Google Sheets-Basic to Super Advance with Practical's(15hrs) ? What is the current price?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $19.99. So you save $5 if you enroll the course now.

Will I be refunded if I'm not satisfied with the Google Sheets-Basic to Super Advance with Practical's(15hrs) course?

YES, Google Sheets-Basic to Super Advance with Practical’s(15hrs) has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Google Sheets-Basic to Super Advance with Practical's(15hrs) course, but there is a $5 discount from the original price ($19.99). So the current price is just $14.99.

Who will teach this course? Can I trust ajay parmar?

ajay parmar has created 52 courses that got 841 reviews which are generally positive. ajay parmar has taught 3,256 students and received a 4.5 average review out of 841 reviews. Depending on the information available, we think that ajay parmar is an instructor that you can trust.

Learn everything about

ajay parmar

Instructor – Advance Excel, Excel Vba ,Access, Access Vba
I have been teaching online from 10 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.
ajay parmar's full profile and courses »
Go to class »

10.0

Classbaze Grade®

9.9

Freshness

9.7

Popularity

9.7

Material

Detailed Analysis »

In-depth study of Functions
Go to course »
Platform: Udemy
Price: check current price
Video: 15h 20m
Language: English
Next start: On Demand

Classbaze recommendations for you

Go to class »