Resources and inspiration for managing money and life with the flexibility and power of Google Sheets and Microsoft Excel.
Here’s a video overview of the new Google Sheets function XLOOKUP. In the video, Randy describes it as “A supercharged version of VLOOKUP, which has always been one of my favorite functions.” Watch the video below:
A comma-separated values (CSV) file is a special kind of file that stores data separated by commas. It’s useful for moving data between programs. When you download your bank account history, it is often delivered in the form of a…
Using the power of Google Sheets, Apps Script, and a bit of code to streamline potential tenant leads via Apartments.com.
By using conditional formating in Google Sheets, you can easily make your Tiller data easier to understand based on your own personalized criteria.
Here are 3 ways to use timestamps in Google Sheets to record when data is created or deleted and keep your spreadsheets organized.
Here's how to hide and unhide columns in Google Sheets. This is helpful if you want to only see the most important columns on your spreadsheet.
Here's a complete guide to conditional formatting in Google Sheets to help you automatically highlight and easily visualize your spreadsheet data.
Here's how to lock cells in Google Sheets in just a few quick steps. This is a great way to make sure no one accidentally changes anything in your spreadsheets.
Here are simple steps for converting currency and importing current exchange rates directly into Google Sheets
Easily create your own custom spreadsheet charts in Google Sheets. In this example, we use your spending data imported by Tiller.
Ever wished there was a way to pull data from your Tiller spreadsheet into a different Google Sheet? You’re in luck! Here's how to use IMPORTRANGE for the job.
Follow these simple steps to export your Bank of America statements into Microsoft Excel and Google Sheets, where you can analyze them as you wish.
