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

Pay with

About Google Sheet Functions: A Step-by-step Guide

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 maybe you think!Updated June 2019 with the latest changes to Sheets, including automatic formulas, and with extra examples. Screenshots totally redone to include the new format and layout in Sheets and to be even more clearer.CONTENT:Introduction to functionsChapter 1 - AVERAGE, MAX, MINChapter 2 - COUNT and COUNTAChapter 3 - IFChapter 4 - CONCATENATE (inc TEXT, CONCAT, and &)Chapter 5 - VLOOKUP (inc IFERROR and ARRAYFORMULA)Chapter 6 - OR & ANDChapter 7 - COUNTIF, SUMIF, COUNTIFS, SUMIFSChapter 8 - FILTERChapter 9 - IMPORTRANGEChapter 10 - PROPER, UPPER, LOWER, TRIM (inc LEFT, RIGHT, LEN)Chapter 11 - TRANSPOSEChapter 12 - ISEMAIL, ISNUMBER, ISURL, NOTChapter 13 - UNIQUE, COUNTUNIQUE, SORTChapter 14 - NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECONDChapter 15 - WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH, CHOOSEChapter 16 - GOOGLETRANSLATE, DETECTLANGUAGEChapter 17 - OFFSETChapter 18 - IMAGEChapter 19 - ROUND, ROUNDUP, ROUNDDOWNChapter 20 - HYPERLINKChapter 21 - INDEX and MATCHChapter 22 - QUERY