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 the powerful 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 functionsChapter 1 - AVERAGE, MAX, MINChapter 2 - COUNT and COUNTAChapter 3 - IFChapter 4 - CONCATENATEChapter 5 - VLOOKUP (inc IFERROR and ARRAYFORMULA)Chapter 6 - OR & ANDChapter 7 - COUNTIF, SUMIF, COUNTIFS, SUMIFSChapter 8 - FILTERChapter 9 - IMPORTRANGEChapter 10 - PROPER, UPPER, LOWER, TRIMChapter 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
✔ Author(s): Barrie Roberts
✔ Title: Google Sheet Functions: A step-by-step guide (Google Workspace apps)
✔ Rating : 4.5 out of 5 base on (158 reviews)
✔ ISBN-10: 1519087977
✔ Language: English
✔ Format ebook: PDF, EPUB, Kindle, Audio, HTML and MOBI
✔ Device compatibles: Android, iOS, PC and Amazon Kindle
Readers' opinions about Google Sheet Functions by Barrie Roberts
Audriana Daly
Travel back in time with a historical epic that vividly recreates a bygone era. The author's meticulous research and engaging prose transport you to another world. Complex characters and intricate plots keep you enthralled from beginning to end. Each chapter reveals new insights into the period's culture and society. It's a captivating blend of history and fiction. Ideal for history buffs and lovers of epic sagas.
Shark Davey
Discover the poignant story of a family navigating life's ups and downs in this moving novel. The author's empathetic writing and well-drawn characters create a deeply emotional experience. Each chapter explores themes of love, loss, and resilience with sensitivity. The plot's twists and turns keep you engaged throughout. It's a heartwarming and thought-provoking read. Perfect for readers who enjoy stories about family dynamics.
Lola Frye
Delve into the dark and twisted world of a psychological thriller that keeps you guessing. The author's masterful storytelling and complex characters create a gripping narrative. Each plot twist is meticulously crafted, adding to the suspense. The tension builds with each chapter, making it impossible to put down. It's a chilling and captivating read that explores the depths of the human psyche. Perfect for fans of psychological suspense.
