Google Sheet Functions: A step-by-step guide (Google Workspace apps)

Author: Roberts Barrie

Number Of Pages: 168

Details: This book will show you how to use some of the most useful functions in Google Sheets. It starts with the basic ones like SUM and takes you through to more advanced areas like VLOOKUP, INDEX and MATCH, IMPORTRANGE, and QUERY.

I feel the best way to learn these is by following examples and in every chapter I will take you through several examples showing you different aspects of the function and various uses of it.

The examples start with the basic syntax of the function and build up to more complex formulas, but I explain each step along the way. So, don’t worry, these are much easier than you think!

Updated with the latest changes to Sheets and now includes an index of all 66 functions in the book.
Screenshots totally redone to include the new format and layout in Sheets and to be even more clearer.

2023 Edition

CONTENT:
Introduction to functions
Chapter 1 – AVERAGE, MAX, MIN
Chapter 2 – COUNT and COUNTA
Chapter 3 – IF
Chapter 4 – CONCATENATE
Chapter 5 – VLOOKUP (inc IFERROR and ARRAYFORMULA)
Chapter 6 – OR & AND
Chapter 7 – COUNTIF, SUMIF, COUNTIFS, SUMIFS
Chapter 8 – FILTER
Chapter 9 – IMPORTRANGE
Chapter 10 – PROPER, UPPER, LOWER, TRIM
Chapter 11 – TRANSPOSE
Chapter 12 – ISEMAIL, ISNUMBER, ISURL, NOT
Chapter 13 – UNIQUE, COUNTUNIQUE, SORT
Chapter 14 – NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND
Chapter 15 – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH, CHOOSE
Chapter 16 – GOOGLETRANSLATE, DETECTLANGUAGE
Chapter 17 – OFFSET
Chapter 18 – IMAGE
Chapter 19 – ROUND, ROUNDUP, ROUNDDOWN
Chapter 20 – HYPERLINK
Chapter 21 – INDEX and MATCH
Chapter 22 – QUERY

Release Date: 14-06-2020

Package Dimensions: 10x279x544