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

Google Sheets Basic to Advance- English

Google Sheets Basic to Advance- English

How to work on Google Spreadsheet and Share your reports free

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

Course begins

  • Get Inside the Google Sheet and Start working
    32:55
  • First and Foremost Rule to learn- Use Dollar sign in locking the formulas
    28:28
  • Basic Functions – Let us begin
    19:35
  • VLOOKUP And Match Functions
    42:03
  • VLOOKUP and Match- Super fun and Versatile formula
    13:05
  • INDEX with Match function – Another super awesome combination
    31:49
  • Begin with IF Function
    00:00
  • Challenges for you- IF Fx
    11:18
  • New way of writing with IFS
    00:00
  • What is IFERROR
    22:47
  • What is IF(ISERROR)
    00:00
  • FIND ,SEARCH.LEFT ,RIGHT & MID Functions
    00:00
  • Questions -Practical use of Functions
    29:51
  • More unique and practical examples
    12:00
  • SPLIT Text function
    11:31
  • Know your Join Text Function
    08:00
  • Explore your SORT Feature
    00:00
  • How to Use FILTER
    10:54
  • More information on FILTER
    04:44
  • FILTER Views
    00:00
  • Use FILTER as a Function
    00:00
  • FILTER with Large and Small functions- Amazing knowledge
    00:00
  • Use FILTER and SORT in one formula- its fascinating
    00:00
  • FILTER Customize Formula option
    11:43
  • How to Create Name Range
    00:00
  • Data Validation – Complete Tutorial
    28:48
  • Create Dynamic Drop Down Using INDEX and Filter
    10:28
  • Challenge for you
    00:00
  • CountBlank,CountA,Count,CountIF – Let us begin
    00:00
  • COUNTIFS- More powerful
    09:02
  • SUMIFs and SUMIF
    11:31
  • AVERAGEIF and AVERAGEIFs
    00:00
  • MAXIFs and MINIFs
    07:57
  • Quiz- Check your Progress
    00:00
  • Column Charts and detailed discussion on its components
    20:08
  • Line Chart to show Trends
    22:46
  • Pie Chart – Creation and Objective
    07:24
  • Combo Chart – Good for showing Performance vs Target
    06:25
  • Aggregate function and Table Chart
    07:14
  • Amazing SCORECARD Chart
    09:20
  • Gauge Charts – Like Speedometer
    05:42
  • The Slicers – Game Changer
    10:44
  • How to Create a PIVOT – Know from basics
    22:09
  • Difference between Grand Total and % Columns Total – Fundamentals
    07:41
  • How to use Filters in Pivot and set Dynamic Range
    12:40
  • CALCULATED FIELD in Pivots
    09:43
  • SLICERS for Pivot Reports
    06:08
  • Challenge for you- Create Different Slicers for Different Pivots
    12:01
  • Challenge -Make Pivot on different Sheets – its Awesome
    14:25
  • How to use Group option in Pivots
    06:25
  • How to write Select Statement- Get data from your table
    03:46
  • WHERE Clause in SQL
    06:44
  • ORDER BY in SQL – Sort the Data in ASC or DESC
    02:51
  • GroupBY in Select Syntax
    02:51
  • OFFSET and Limit Parameters in SQL
    17:08
  • Sharing Files with Collegues
    00:00
  • Send specific cell links
    08:51
  • How to Export data into MS Excel
    08:04
  • Protect your data inside Sheets and Specific Ranges
    11:34
  • Show the data in different language – Magnificent invention
    10:28
  • Fundamentals -Work with Inspect element and Scrape Headers,Paragraphs
    39:54
  • Work the Weblinks
    00:00
  • Work with Class attribute
    18:14
  • Another example – Work with Class attribute
    00:00
  • Extract Tables using IMPORTXML & IMPORTHTML – Wow Wow
    17:15
  • Extract customized data from websites – You will love it – Powerful
    07:56
899.00
899.00 2,800.00

Google Sheets Basic to Advance- English

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

Course begins

  • Get Inside the Google Sheet and Start working
    32:55
  • First and Foremost Rule to learn- Use Dollar sign in locking the formulas
    28:28
  • Basic Functions – Let us begin
    19:35
  • VLOOKUP And Match Functions
    42:03
  • VLOOKUP and Match- Super fun and Versatile formula
    13:05
  • INDEX with Match function – Another super awesome combination
    31:49
  • Begin with IF Function
    00:00
  • Challenges for you- IF Fx
    11:18
  • New way of writing with IFS
    00:00
  • What is IFERROR
    22:47
  • What is IF(ISERROR)
    00:00
  • FIND ,SEARCH.LEFT ,RIGHT & MID Functions
    00:00
  • Questions -Practical use of Functions
    29:51
  • More unique and practical examples
    12:00
  • SPLIT Text function
    11:31
  • Know your Join Text Function
    08:00
  • Explore your SORT Feature
    00:00
  • How to Use FILTER
    10:54
  • More information on FILTER
    04:44
  • FILTER Views
    00:00
  • Use FILTER as a Function
    00:00
  • FILTER with Large and Small functions- Amazing knowledge
    00:00
  • Use FILTER and SORT in one formula- its fascinating
    00:00
  • FILTER Customize Formula option
    11:43
  • How to Create Name Range
    00:00
  • Data Validation – Complete Tutorial
    28:48
  • Create Dynamic Drop Down Using INDEX and Filter
    10:28
  • Challenge for you
    00:00
  • CountBlank,CountA,Count,CountIF – Let us begin
    00:00
  • COUNTIFS- More powerful
    09:02
  • SUMIFs and SUMIF
    11:31
  • AVERAGEIF and AVERAGEIFs
    00:00
  • MAXIFs and MINIFs
    07:57
  • Quiz- Check your Progress
    00:00
  • Column Charts and detailed discussion on its components
    20:08
  • Line Chart to show Trends
    22:46
  • Pie Chart – Creation and Objective
    07:24
  • Combo Chart – Good for showing Performance vs Target
    06:25
  • Aggregate function and Table Chart
    07:14
  • Amazing SCORECARD Chart
    09:20
  • Gauge Charts – Like Speedometer
    05:42
  • The Slicers – Game Changer
    10:44
  • How to Create a PIVOT – Know from basics
    22:09
  • Difference between Grand Total and % Columns Total – Fundamentals
    07:41
  • How to use Filters in Pivot and set Dynamic Range
    12:40
  • CALCULATED FIELD in Pivots
    09:43
  • SLICERS for Pivot Reports
    06:08
  • Challenge for you- Create Different Slicers for Different Pivots
    12:01
  • Challenge -Make Pivot on different Sheets – its Awesome
    14:25
  • How to use Group option in Pivots
    06:25
  • How to write Select Statement- Get data from your table
    03:46
  • WHERE Clause in SQL
    06:44
  • ORDER BY in SQL – Sort the Data in ASC or DESC
    02:51
  • GroupBY in Select Syntax
    02:51
  • OFFSET and Limit Parameters in SQL
    17:08
  • Sharing Files with Collegues
    00:00
  • Send specific cell links
    08:51
  • How to Export data into MS Excel
    08:04
  • Protect your data inside Sheets and Specific Ranges
    11:34
  • Show the data in different language – Magnificent invention
    10:28
  • Fundamentals -Work with Inspect element and Scrape Headers,Paragraphs
    39:54
  • Work the Weblinks
    00:00
  • Work with Class attribute
    18:14
  • Another example – Work with Class attribute
    00:00
  • Extract Tables using IMPORTXML & IMPORTHTML – Wow Wow
    17:15
  • Extract customized data from websites – You will love it – Powerful
    07:56