Google Sheets How To

Learn the basics and more advanced workflows with Google Sheets

18 articles in this collection
Written by Heather Phillips

Basics

Adjust offline editing settings

Learn how to turn on or off Google Docs offline editing settings

Written by Heather Phillips
Updated over a week ago

How to download your Google Sheet as a CSV or Excel file

Learn how to export your Google Sheet to other formats.

Written by Heather Phillips
Updated over a week ago

How to copy a sheet (tab) to another Google Sheet

Learn how to copy financial reports and sheets between Google Sheets.

Written by Heather Phillips
Updated over a week ago

Adding Extra Sheets to your Tiller Finance Spreadsheet

Add more sheets to your Tiller Financial Spreadsheet

Written by Heather Phillips
Updated over a week ago

Filtering & Sorting Data in Google Sheets

Learn how to filter and sort your financial data on your Transactions sheet.

Written by Heather Phillips
Updated over a week ago

Copying Reports and Charts Between Sheets

Learn how to reuse your finance reports and charts across multiple Google Sheets.

Written by Heather Phillips
Updated over a week ago

Mobile Access to a Sheet

Using the Google Sheets app to view your Tiller Sheet on your phone.

Written by Heather Phillips
Updated over a week ago

How To Select All The Data In Your Google Sheet

Select all the data in any of your sheets in a Google Sheet

Written by Heather Phillips
Updated over a week ago

How To Use The Quick Fill Square

Learn how to quickly fill the cells in a column or row with the same data.

Written by Heather Phillips
Updated over a week ago

Permissions, Access, and Versioning

Accessing Google Sheets on Google Drive

Learn how to access your Tiller-powered G Sheet directly from your Google Drive

Written by Heather Phillips
Updated over a week ago

Sharing and permissions in Google Sheets

Learn how to securely share your Tiller Money spreadsheet with other Google Accounts

Written by Heather Phillips
Updated over a week ago

Google Sheets Change Notifications

Learn how to set up notifications when changes are made to your finance spreadsheet.

Written by Heather Phillips
Updated over a week ago

Reviewing Version History & Restoring a Google Sheet

Learn how to review the Version History and restore a to a previous version for a Google Sheet.

Written by Heather Phillips
Updated over a week ago

How to uninstall an add-on

Learn how to remove an add-on from your add-ons menu in Google Sheets.

Written by Heather Phillips
Updated over a week ago

Advanced

Import Your Financial Data from Tiller Into Another Google Sheet Using IMPORTRANGE

Use a built in Google Sheets formula to get your financial data into another Google Sheet.

Written by Heather Phillips
Updated over a week ago

Automatically Fill a Column with a Formula

Use Google Sheets ArrayFormula to automatically fill a custom column in your Transactions sheet.

Written by Heather Phillips
Updated over a week ago

Using Google Sheets QUERY to Visualize Your Spending

Learn how to use QUERY in Google Sheets to build custom spending reports.

Written by Heather Phillips
Updated over a week ago

Google Sheets Functions & Formulas

Resources on built in Google Sheets functions and formulas for building your own custom financial reporting dashboards.

Written by Heather Phillips
Updated over a week ago