Start Your Free Trial
Keep a clear, confident view of all your money in one place, with flexible templates, powerful privacy, and top-rated support
Spreadsheet Tips
Resources and inspiration for managing money and life with the flexibility and power of Google Sheets and Microsoft Excel.
AllFeatured Spreadsheet TemplatesMoney ManagementMoney MindsetSpreadsheet TipsTiller Tips and UpdatesUncategorized
When “Equals” Doesn’t Really “Equal” in a Spreadsheet
Here's how I solved a problem in a complex spreadsheet that was both very difficult yet simple to find.
A Quick Look at Coda, a New Type of Spreadsheet App
A quick look at Coda, the new spreadsheet format that aspires to blend the “the power of spreadsheets and the utility of applications into a single new canvas."
How to Use IMPORTRANGE to Sync Spreadsheet Transactions
How to use the IMPORTRANGE formula in Google Sheets to categorize transactions in one spreadsheet and share them with a different spreadsheet.
The Tool to Split a Transaction Across Multiple Categories in Your Finance Spreadsheet
Sometimes a single transaction doesn’t fit neatly into a single category. The purchase at the grocery store included food for home and also work expenses. The trip to the big box store was for household items but also gifts. Have no fear. We have a tool that makes it easy to split a single transaction into multiple categories.
How Many Cells Are In My Google Sheet?
What should you do when you get that Google error, "There was a problem. This action would increase the number of cells in the workbook above the limit of 2000000 cells.” We've got a handy new add-on that will help.
How Can I Automatically Fill a Google Sheets Column With A Formula?
Have you ever wanted to add a new column with a formula to your Transactions sheet that keeps up with the new rows added each day by the Tiller Feed Bot? This week on the blog we share how to use a Google Sheets ArrayFormula to trick out your Transactions sheet.
Boost Your Finance Management with these Five Google Sheets Tips
We’ve put together five of our favorite Google Sheet features. These powerful tricks will help you fine tune your financial tracking.
Using Spreadsheets for Self Employed Tax Preparation
There are many perks to working from home for yourself, but how does that complicate your taxes? In this post we share a strategy for pulling together your tax information to help you share your financial data with an accountant.
How to Use Google Sheets QUERY Function
How to set up a basic Google Sheets QUERY to analyze your spending.
Using Google Sheets To Track Your Investment Portfolio Like a Pro
Ditch expensive software and learn how to use the powerful GOOGLEFINANCE function in Google Sheets to automatically track your investment portfolio, including stocks, indexes, and mutual funds.