Google Sheets Basic to Advance – Hindi
Google Sheets Basic to Advance – Hindi
From data collection, automation, to proper data analysis and visualization.
Created by Ajay Parmar
Course Description
- This course will educate you about how to work with Google sheets and you shall know every small & big features, formulas 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 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.
Course Curriculum
Let us start
-
Create, Save, move, access spreadsheet
40:21 -
Cell Referencing and other basic but important features
46:58 -
Vlookup with Match – basic to advance
01:06:31 -
What is Hlookup and how it is different from Vlookup
15:48 -
All Count & Sum family functions
20:44 -
SumIF, Filter, Sort & Data Validation-its amazing
50:58 -
IF function with Vlookups & Error Handlers – V important for MIS
01:08:37 -
Text Functions for data extraction
49:45 -
Sorting and Filtering with other features
57:54 -
Indirect function and Name Range concept – mind blowing
37:14 -
Conditional formatting
14:10 -
Index with dynamic drop down
01:19:56 -
Charts part1
38:53 -
Charts – Part2
42:37 -
Pivots for Reports and data summarization
40:21 -
Query Function
26:49
Google Sheets Basic to Advance – Hindi
Course Description
- This course will educate you about how to work with Google sheets and you shall know every small & big features, formulas 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 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.
Course Curriculum
Let us start
-
Create, Save, move, access spreadsheet
40:21 -
Cell Referencing and other basic but important features
46:58 -
Vlookup with Match – basic to advance
01:06:31 -
What is Hlookup and how it is different from Vlookup
15:48 -
All Count & Sum family functions
20:44 -
SumIF, Filter, Sort & Data Validation-its amazing
50:58 -
IF function with Vlookups & Error Handlers – V important for MIS
01:08:37 -
Text Functions for data extraction
49:45 -
Sorting and Filtering with other features
57:54 -
Indirect function and Name Range concept – mind blowing
37:14 -
Conditional formatting
14:10 -
Index with dynamic drop down
01:19:56 -
Charts part1
38:53 -
Charts – Part2
42:37 -
Pivots for Reports and data summarization
40:21 -
Query Function
26:49