Download or read book Google Sheet Functions written by Barrie Roberts and published by . This book was released on 2020-06-14 with total page 183 pages. Available in PDF, EPUB and Kindle. Book excerpt: The idea of this book is to 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, 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! 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