BiggestSale: 17Courses in 3500Rs (500 Hrs), 10 Courses in 3000Rs

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

Material Includes

  • Lectures Files & HD video lectures with lifetime access on website

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:30
  • 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:59
  • 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:11
  • Index with dynamic drop down
    01:19:55
  • Charts part1
    38:53
  • Charts – Part2
    42:37
  • Pivots for Reports and data summarization
    40:21
  • Query Function
    26:49
899.00
899.00 2,800.00

Google Sheets Basic to Advance – Hindi

899.00
899.00 2,800.00

Material Includes

  • Lectures Files & HD video lectures with lifetime access on website

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:30
  • 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:59
  • 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:11
  • Index with dynamic drop down
    01:19:55
  • Charts part1
    38:53
  • Charts – Part2
    42:37
  • Pivots for Reports and data summarization
    40:21
  • Query Function
    26:49