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
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
19:43 -
Challenges for you- IF Fx
11:18 -
New way of writing with IFS
05:47 -
What is IFERROR
22:47 -
What is IF(ISERROR)
19:06 -
FIND ,SEARCH.LEFT ,RIGHT & MID Functions
10:42 -
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
12:00 -
How to Use FILTER
10:54 -
More information on FILTER
04:43 -
FILTER Views
11:35 -
Use FILTER as a Function
11:35 -
FILTER with Large and Small functions- Amazing knowledge
15:41 -
Use FILTER and SORT in one formula- its fascinating
03:06 -
FILTER Customize Formula option
11:43 -
How to Create Name Range
17:18 -
Data Validation – Complete Tutorial
28:48 -
Create Dynamic Drop Down Using INDEX and Filter
10:27 -
Challenge for you
28:07 -
CountBlank,CountA,Count,CountIF – Let us begin
15:17 -
COUNTIFS- More powerful
09:01 -
SUMIFs and SUMIF
11:30 -
AVERAGEIF and AVERAGEIFs
05:02 -
MAXIFs and MINIFs
07:57 -
Quiz- Check your Progress
07:58 -
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:45 -
How to Create a PIVOT – Know from basics
22:10 -
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
Google Sheets Basic to Advance- English
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
19:43 -
Challenges for you- IF Fx
11:18 -
New way of writing with IFS
05:47 -
What is IFERROR
22:47 -
What is IF(ISERROR)
19:06 -
FIND ,SEARCH.LEFT ,RIGHT & MID Functions
10:42 -
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
12:00 -
How to Use FILTER
10:54 -
More information on FILTER
04:43 -
FILTER Views
11:35 -
Use FILTER as a Function
11:35 -
FILTER with Large and Small functions- Amazing knowledge
15:41 -
Use FILTER and SORT in one formula- its fascinating
03:06 -
FILTER Customize Formula option
11:43 -
How to Create Name Range
17:18 -
Data Validation – Complete Tutorial
28:48 -
Create Dynamic Drop Down Using INDEX and Filter
10:27 -
Challenge for you
28:07 -
CountBlank,CountA,Count,CountIF – Let us begin
15:17 -
COUNTIFS- More powerful
09:01 -
SUMIFs and SUMIF
11:30 -
AVERAGEIF and AVERAGEIFs
05:02 -
MAXIFs and MINIFs
07:57 -
Quiz- Check your Progress
07:58 -
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:45 -
How to Create a PIVOT – Know from basics
22:10 -
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