Master Google Sheets and Become a Spreadsheet Expert

It's easy enough to list your expenses in a spreadsheet, use =sum(A1:A20) to see how much you spent, and add a graph to compare your expenses. It's also easy to use a spreadsheet to deeply analyze your numbers, assist in research, and automate your work—but it seems a lot more tricky.

Google Sheets, the free spreadsheet companion app to Google Docs, is a great tool to start out with spreadsheets. It's free, easy to use, comes packed with hundreds of functions and the core tools you need, and lets you share spreadsheets and collaborate on them with others.

But where do you start if you've never used a spreadsheet—or if you're a spreadsheet professional, where do you dig in to create advanced workflows and build macros to automate your work?

Here's the guide for you. We'll take you from beginner to expert, show you how to get started with spreadsheets, create advanced spreadsheet-powered dashboard, use spreadsheets for more than numbers, build powerful macros to automate your work, and more. You'll also find tutorials on Google Sheets' unique features that are only possible in an online spreadsheet, like built-in forms and survey tools and add-ons that can pull in research from the web or send emails right from your spreadsheet.


Table of Contents

  1. Google Sheets 101: The Beginner's Guide to Online Spreadsheets
  2. Google Forms Guide: Everything You Need to Make Great Forms for Free
  3. Spreadsheet CRM: How to Create a Customizable CRM with Google Sheets
  4. Write Faster with Spreadsheets: 10 Shortcuts for Composing Outlines, Research, HTML Tables and More
  5. How to Create a Custom Business Analytics Dashboard with Google Sheets
  6. 50 Google Sheets Add-Ons to Supercharge Your Spreadsheets
  7. Automate Google Sheets: An Introduction to Google Apps Script
  8. Extra Resources to Manage Your Spreadsheets

Download this Book

Get this book in a variety of formats, plus other great content from Zapier!

We're offering this book as a free download if you subscribe to the Zapier blog.

Credits

Written by the Zapier team with content from Matthew Guay, along with freelance contributions from Michael Grubbs, Jeremey DuVall, and Jesse Bouman.

Original cover artwork by Zapier designer Stephanie Briones.

Workflow

Take the Work out of Workflow

Zapier is the easiest way to automate powerful workflows with more than 750 apps.

“If we didn't get these ongoing notifications through Zapier, we’d miss important information on how patient funding is going. It's saved us so much time.”

Grace Garey, co-founder of Watsi

Try Zapier Today