Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator
Opening the iBooks Store.If iBooks doesn't open, click the iBooks app in your Dock.Progress Indicator
iTunes

## iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To download from the iTunes Store, get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

# Google Sheet Functions

### A step-by-step guide

This book is available for download with iBooks on your Mac or iOS device. Multi-touch books can be read with iBooks on your Mac or iOS device. Books with interactive features may work best on an iOS device. iBooks on your Mac requires OS X 10.9 or later.

#### Description

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

## Customers Also Bought

View in iTunes
• \$3.99
• Available on iPad, iPhone and Mac.
• Category: Software
• Published: Dec 06, 2016
• Publisher: Barrie Roberts
• Seller: Barrie Roberts
• Print Length: 235 Pages
• Language: English
• Version: 1.0
• Requirements: To view this book, you must have an iPad with iBooks 2 or later and iOS 5 or later, or an iPhone with iOS 8.4 or later, or a Mac with OS X 10.9 or later.

#### Customer Ratings

We have not received enough ratings to display an average for this book.