Get 17 Courses In 5,999/- Rupees & Get 10 Courses In 4,000/-

Log In
Registration

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:27
  • Basic Functions – Let us begin
    19:35
  • VLOOKUP And Match Functions
    42:03
  • VLOOKUP and Match- Super fun and Versatile formula
    00:00
  • INDEX with Match function – Another super awesome combination
    00:00
  • Begin with IF Function
    00:00
  • Challenges for you- IF Fx
    00:00
  • New way of writing with IFS
    00:00
  • What is IFERROR
    00:00
  • What is IF(ISERROR)
    00:00
  • FIND ,SEARCH.LEFT ,RIGHT & MID Functions
    00:00
  • Questions -Practical use of Functions
    00:00
  • More unique and practical examples
    00:00
  • SPLIT Text function
    00:00
  • 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
    00:00
  • How to Create Name Range
    00:00
  • Data Validation – Complete Tutorial
    00:00
  • Create Dynamic Drop Down Using INDEX and Filter
    00:00
  • Challenge for you
    00:00
  • CountBlank,CountA,Count,CountIF – Let us begin
    00:00
  • COUNTIFS- More powerful
    00:00
  • SUMIFs and SUMIF
    00:00
  • AVERAGEIF and AVERAGEIFs
    00:00
  • MAXIFs and MINIFs
    00:00
  • Quiz- Check your Progress
    00:00
  • Column Charts and detailed discussion on its components
    00:00
  • Line Chart to show Trends
    00:00
  • Pie Chart – Creation and Objective
    00:00
  • Combo Chart – Good for showing Performance vs Target
    00:00
  • Aggregate function and Table Chart
    00:00
  • Amazing SCORECARD Chart
    09:20
  • Gauge Charts – Like Speedometer
    05:43
  • The Slicers – Game Changer
    10:45
  • How to Create a PIVOT – Know from basics
    00:00
  • Difference between Grand Total and % Columns Total – Fundamentals
    00:00
  • How to use Filters in Pivot and set Dynamic Range
    00:00
  • CALCULATED FIELD in Pivots
    00:00
  • SLICERS for Pivot Reports
    00:00
  • Challenge for you- Create Different Slicers for Different Pivots
    00:00
  • Challenge -Make Pivot on different Sheets – its Awesome
    00:00
  • How to use Group option in Pivots
    00:00
  • How to write Select Statement- Get data from your table
    00:00
  • WHERE Clause in SQL
    00:00
  • ORDER BY in SQL – Sort the Data in ASC or DESC
    00:00
  • GroupBY in Select Syntax
    00:00
  • OFFSET and Limit Parameters in SQL
    00:00
  • Sharing Files with Collegues
    00:00
  • Send specific cell links
    00:00
  • How to Export data into MS Excel
    00:00
  • Protect your data inside Sheets and Specific Ranges
    00:00
  • Show the data in different language – Magnificent invention
    00:00
  • Fundamentals -Work with Inspect element and Scrape Headers,Paragraphs
    39:53
  • 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
    00:00
  • Extract customized data from websites – You will love it – Powerful
    00:00
₹1,000.00
₹1,000.00 ₹2,800.00
  • Level
    All Levels
  • Total Enrolled
    23
  • Duration
    15 hours
  • Last Updated
    February 5, 2023

Google Sheets Basic to Advance- English

₹1,000.00
₹1,000.00 ₹2,800.00
  • Level
    All Levels
  • Total Enrolled
    23
  • Duration
    15 hours
  • Last Updated
    February 5, 2023

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:27
  • Basic Functions – Let us begin
    19:35
  • VLOOKUP And Match Functions
    42:03
  • VLOOKUP and Match- Super fun and Versatile formula
    00:00
  • INDEX with Match function – Another super awesome combination
    00:00
  • Begin with IF Function
    00:00
  • Challenges for you- IF Fx
    00:00
  • New way of writing with IFS
    00:00
  • What is IFERROR
    00:00
  • What is IF(ISERROR)
    00:00
  • FIND ,SEARCH.LEFT ,RIGHT & MID Functions
    00:00
  • Questions -Practical use of Functions
    00:00
  • More unique and practical examples
    00:00
  • SPLIT Text function
    00:00
  • 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
    00:00
  • How to Create Name Range
    00:00
  • Data Validation – Complete Tutorial
    00:00
  • Create Dynamic Drop Down Using INDEX and Filter
    00:00
  • Challenge for you
    00:00
  • CountBlank,CountA,Count,CountIF – Let us begin
    00:00
  • COUNTIFS- More powerful
    00:00
  • SUMIFs and SUMIF
    00:00
  • AVERAGEIF and AVERAGEIFs
    00:00
  • MAXIFs and MINIFs
    00:00
  • Quiz- Check your Progress
    00:00
  • Column Charts and detailed discussion on its components
    00:00
  • Line Chart to show Trends
    00:00
  • Pie Chart – Creation and Objective
    00:00
  • Combo Chart – Good for showing Performance vs Target
    00:00
  • Aggregate function and Table Chart
    00:00
  • Amazing SCORECARD Chart
    09:20
  • Gauge Charts – Like Speedometer
    05:43
  • The Slicers – Game Changer
    10:45
  • How to Create a PIVOT – Know from basics
    00:00
  • Difference between Grand Total and % Columns Total – Fundamentals
    00:00
  • How to use Filters in Pivot and set Dynamic Range
    00:00
  • CALCULATED FIELD in Pivots
    00:00
  • SLICERS for Pivot Reports
    00:00
  • Challenge for you- Create Different Slicers for Different Pivots
    00:00
  • Challenge -Make Pivot on different Sheets – its Awesome
    00:00
  • How to use Group option in Pivots
    00:00
  • How to write Select Statement- Get data from your table
    00:00
  • WHERE Clause in SQL
    00:00
  • ORDER BY in SQL – Sort the Data in ASC or DESC
    00:00
  • GroupBY in Select Syntax
    00:00
  • OFFSET and Limit Parameters in SQL
    00:00
  • Sharing Files with Collegues
    00:00
  • Send specific cell links
    00:00
  • How to Export data into MS Excel
    00:00
  • Protect your data inside Sheets and Specific Ranges
    00:00
  • Show the data in different language – Magnificent invention
    00:00
  • Fundamentals -Work with Inspect element and Scrape Headers,Paragraphs
    39:53
  • 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
    00:00
  • Extract customized data from websites – You will love it – Powerful
    00:00

The beautiful thing about learning is that nobody can take it away from you.

Twitter Facebook-f Instagram Telegram-plane Youtube

Quick Links

Imp. Links

Weekly Newsletter

  • Copyright 2022-23 AjayParmarTutor. All Rights Reserved