Google Sheets Tutorial

Step by Step tutorial to learn the following useful functions in Google Sheet and be able to perform effective data analysis. Once you have access choose “File” and then “Make a copy” to save the file in your GDrive. The solutions link is provided in the exercise file.

1 LEFT / RIGHT
2 SPLIT, UPPER, LOWER
3 Dates
4 TEXT, FORMATS
5 IF, IFERROR, SUMIFS
6 COUNT / COUNTA
7 UNIQUE
8 SUMPRODUCT
9 INDEX
10 INDIRECT
11 INDEX/MATCH vs. VLOOKUP/HLOOKUP
12 FILTER
13 Merging Data with {}
14 IMPORTRANGE
15 QUERY
16 Complex QUERY (OR, AND, AVG, SUM,COUNT, GROUP BY, ORDER BY)
17 ARRAYFORMULA
18 IMPORTHTML

 

Industry ,
Summary Learn Google Sheets the easy way Apply it to your day to day job Perform Data Analysis You need to have a gmail account. It works only in Google Sheets
Screenshots / Pictures



Use Cases ,

You must log in to submit a review.

Leave a Reply