Kindle Unlimited
Unlimited reading. Over 4 million titles. Learn more
Read for Free
OR
Kindle Price: $9.99

Promotions apply when you purchase

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Read with our free app
You've subscribed to ! We will preorder your items within 24 hours of when they become available. When new books are released, we'll charge your default payment method for the lowest price available during the pre-order period.
Update your device or payment method, cancel individual pre-orders or your subscription at
Your Memberships & Subscriptions

Buy for others

Give as a gift or purchase for a team or group.
Learn more

Buying and sending eBooks to others

  1. Select quantity
  2. Buy and send eBooks
  3. Recipients can read on any device

These ebooks can only be redeemed by recipients in the US. Redemption links and eBooks cannot be resold.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Barrie Roberts
+ Follow
More books from this author
Something went wrong. Please try your request again later.

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

by Barrie Roberts (Author) Format: Kindle Edition
4.3 4.3 out of 5 stars 169 ratings
See all formats and editions

Unlock the full potential of GOOGLE SHEETS FUNCTIONS: Your ultimate guide to mastering essential functions!

Take your Google Sheets skills to a whole new level with my comprehensive guide on the most useful functions! Whether you're a beginner or a seasoned user, this book is designed to empower you with the knowledge and confidence to make the most out of Sheets' powerful functions.

Starting with the fundamentals like SUM, I'll guide you step-by-step through the different aspects of each function. As you progress, you'll delve into more advanced areas like VLOOKUP, FILTER, IMPORTRANGE, and the incredibly versatile QUERY function. But don't worry – I believe the best way to learn is through practical examples, and that's exactly what I offer in every chapter!

With a clear focus on hands-on learning, each chapter presents multiple examples that dive into the various facets of the function and its various applications. From basic syntax to complex formulas, I break it down, ensuring you understand each step along the way. You'll be surprised at how much easier these functions become with my guidance

In this updated 2024 edition, I've incorporated the latest changes to Sheets, ensuring you're equipped with the most current information. Additionally, I've included an index of all 65 functions in the book for quick reference. I’ve redone all the screenshots to showcase the new format and layout in Sheets, making understanding even more straightforward.

But that's not all! I've added a brand-new chapter that teaches you how to break down long, complicated formulas to grasp their inner workings. With this invaluable skill, you'll tackle any challenge with ease.

CONTENT HIGHLIGHTS:

- Introduction to functions

- Mastering basic functions like AVERAGE, MAX, MIN, COUNT, and COUNTA

- Harnessing the power of IF, CONCATENATE, VLOOKUP and more

- Utilising date and time functions like NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, and beyond

- Unleashing the potential of FILTER, IMPORTRANGE, GOOGLETRANSLATE, HYPERLINK

- Exploring advanced functions like OFFSET, COUNTUNIQUE, COUNTIF, and SUMIFS

- Mastering the dynamic INDEX and MATCH duo, and diving deep into the transformative QUERY function

With "Google Sheets Functions: A step-by-step Guide" you'll become confident in using functions in Sheets, ready to tackle any data challenge that comes your way. Don't miss out on this invaluable resource – get your copy now and unlock the full potential of Google Sheets!

Read more Read less
Previous page
  1. Part of series
    Google Workspace apps
  2. Print length
    200 pages
  3. Language
    English
  4. Sticky notes
    On Kindle Scribe
  5. Publication date
    December 5, 2016
  6. File size
    27222 KB
  7. Page Flip
    Enabled
  8. Word Wise
    Not Enabled
  9. Enhanced typesetting
    Enabled
  10. See all details
Next page
Due to its large file size, this book may take longer to download
Next 5 for you in this series See full series
Total Price: $36.95
By clicking on the above button, you agree to Amazon's Kindle Store Terms of Use
More like Google Sheet Functions: A step-by-step guide (Google Workspace apps)
Page 1 of 1Start overPage 1 of 1
Previous page
  9. Google Workspace apps    8 book series
Next page
Loading...

Product details

  • ASIN ‏ : ‎ B01NBHMZI9
  • Publication date ‏ : ‎ December 5, 2016
  • Language ‏ : ‎ English
  • File size ‏ : ‎ 27222 KB
  • Simultaneous device usage ‏ : ‎ Unlimited
  • Text-to-Speech ‏ : ‎ Enabled
  • Screen Reader ‏ : ‎ Supported
  • Enhanced typesetting ‏ : ‎ Enabled
  • X-Ray ‏ : ‎ Not Enabled
  • Word Wise ‏ : ‎ Not Enabled
  • Sticky notes ‏ : ‎ On Kindle Scribe
  • Print length ‏ : ‎ 200 pages
  • Customer Reviews:
    4.3 4.3 out of 5 stars 169 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Barrie Roberts

Barrie Roberts

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

I've written these books to share my knowledge on the Google Workspace apps and Google Apps Script (the code that can automate them). I realised there were very few books or websites out there that take someone from knowing nothing about the products and then take them step-by-step through the various areas, showing them every step of the way until they can use the products with confidence.

I've also been teaching since 2006 and enjoy imparting my knowledge to my students, helping them open new doors.

I hope you enjoy the books!

Barrie Roberts

Customer reviews

4.3 out of 5 stars
4.3 out of 5
169 global ratings

Top reviews from the United States

Carole Pool
5.0 out of 5 stars The BEST reference for Google sheets
Reviewed in the United States on October 5, 2023
Verified Purchase
The only book you need for Google sheets
Helpful
 Report
Jamie Stober
5.0 out of 5 stars Very handy quick-start guide.
Reviewed in the United States on September 27, 2022
Verified Purchase
Very thorough and I like the book format instead of switching back & forth between online help tabs or taking a full class on Sheets. Find what you need quickly and you can keep your screen focused on the data at hand.

I am using this for Data Analytics Certification course; have just always used Excel but this is a course by Google, SO.
3 people found this helpful
Helpful
 Report
Albert
5.0 out of 5 stars Plenty of illustrations and examples to make the function clear
Reviewed in the United States on February 25, 2021
Verified Purchase
No fluff, just the information you want to get up and running with Google Sheets. There are plenty of examples and illustrations to explain the various ways to use the functions. This book seems to have all the functions you may want or need to use Sheets effectively. You can't go wrong with Barrie Roberts' book.
2 people found this helpful
Helpful
 Report
Kindle Customer
5.0 out of 5 stars Caveat I follow "barrie" on g+ I bought this book ...
Reviewed in the United States on January 18, 2017
Verified Purchase
Caveat I follow "barrie" on g+ I bought this book solely on his writing style on that platform. Few if any can write a "how to book" that explains function and also relates examples that explain the usefulness of the functions he is describing. This is rare. Note most use nonsensical examples. Admittedly I am interested in switch my focus from microsoft to google prodcuct. Further his depiction of premise, then showing the formula in the box where it is on the program.
4 people found this helpful
Helpful
 Report
C. F. Crowe
3.0 out of 5 stars This book describes functions available only on laptops
Reviewed in the United States on August 3, 2021
Verified Purchase
The description of the software describes functions not available on its iPad version of Sheets. I can use the spread sheets, but some of the top row functions are not available on the iPad
One person found this helpful
Helpful
 Report
Elijah Blomstrom
5.0 out of 5 stars Very helpful
Reviewed in the United States on January 15, 2022
Verified Purchase
The examples were great. This gave me the info I needed to really get going on creating efficient spreadsheets. Highly recommend.
One person found this helpful
Helpful
 Report
Donna Rice
5.0 out of 5 stars Great resource for formula examples!
Reviewed in the United States on November 19, 2017
Verified Purchase
Anyone looking to learn about the functions available in Google Sheets will find this book addition to have saved on their Kindles. For the price, I was very happy with this book.
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
J Murray
5.0 out of 5 stars Sheets
Reviewed in the United Kingdom on January 30, 2024
Verified Purchase
Having been told about Google sheets and how helpful it would be for me. I decided to explore the whole Google experience beginning with “sheets”, so first call was to get a book and see how helpful sheets really is.
I’ve not been disappointed in the book in fact it’s proved extremely helpful , easy to follow and understand.
As someone who’s never really taken much notice of spreadsheets I can say that I am a complete novice and the book has been a great help in guiding me along the way. It really is a well written book with all the info you require to get up and running with sheets . I use it everyday and would definitely recommend it to anyone either beginners or experienced with Google sheets or Excel , you’ll learn loads or brush up on your sheets knowledge.
Iam working my way round formula and other sheet stuff.
I am also finding many task etc I can use my sheets knowledge on, so I think this is a definite win win book. Buy it you won’t regret it.
Report
Irving wall
5.0 out of 5 stars Awesome!!
Reviewed in France on February 28, 2024
Verified Purchase
Thanks to Baz. This book and the others are clear and practical. It's well explained and illustrated with many examples. I highly recommand.
Report
Bruce Edgar
5.0 out of 5 stars Clear concise guide to creating formulas in Google sheets.
Reviewed in Canada on June 20, 2019
Verified Purchase
Man I love this book clear concise to the point.
Report
rodolfo lacerda eduardo
5.0 out of 5 stars Livro muito didático
Reviewed in Brazil on November 9, 2017
Verified Purchase
Excelente livro. Muito bem explicado, com exemplos muito claros que você pode testar os resultados automaticamente. Não tem enrolação. 100% prático . E de um ingles muito fácil de compreender para aqueles que nao sao avançados no idioma.
One person found this helpful
 Report
Christine Dixon
5.0 out of 5 stars It’s a requested Christmas gift
Reviewed in the United Kingdom on December 23, 2020
Verified Purchase
It’s all beyond me but this was requested as a Christmas gift so I’m sure the recipient will enjoy it
One person found this helpful
 Report
Report an issue

Does this item contain inappropriate content?
Report
Do you believe that this item violates a copyright?
Report
Does this item contain quality or formatting issues?
Report