• \$4.99

## Publisher Description

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!

CONTENT:

Introduction to functions

Chapter 1 - AVERAGE, MAX, MIN

Chapter 2 - COUNT and COUNTA

Chapter 3 - IF

Chapter 4 - CONCATENATE (inc TEXT, CONCAT, and &)

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 (inc LEFT, RIGHT, LEN)

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 17 - OFFSET

Chapter 18 - IMAGE

Chapter 19 - ROUND, ROUNDUP, ROUNDDOWN