Learn Google Sheets Part 1 - Introduction
  • Learn Google Sheets Part 1 - Introduction
  • Learn Google Sheets Part 1 - Introduction
  • Learn Google Sheets Part 1 - Introduction
  • Learn Google Sheets Part 1 - Introduction
  • Learn Google Sheets Part 1 - Introduction
Originally published: 18/04/2018 12:35
Last version published: 22/04/2018 08:31
Publication number: ELQ-36690-2
View all versions & Certificate
certified

Learn Google Sheets Part 1 - Introduction

Step by Step tutorial to learn Google Sheets

#data analysis#filter#querygoogle sheetsimportrangelearnstatistics

Description
Step by Step tutorial to learn all the useful functions in Google Sheet and be able to perform effective data analysis.

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

This business tool includes
2 Google Sheets

Acquire business license for $15.00

Add to cart

Add to bookmarks

Discuss

Further information

Learn Google Sheets the easy way
Apply it to your day to day job
Perform Data Analysis

Data Analysis. You need to have a gmail account.

Works only in Google Sheets

Reviews

  • No review yet!

Any questions on Learn Google Sheets Part 1 - Introduction?

The user community and author are here to help. Go ahead!

please wait...