Spreadsheet Tips

Resources and inspiration for managing money and life with the flexibility and power of Google Sheets and Microsoft Excel.

All Featured Spreadsheet Templates Money Management Money Mindset Spreadsheet Tips Tiller Tips and Updates Uncategorized

Bring Your Tiller Transactions Sheet to Life with Conditional Formatting

By using conditional formating in Google Sheets, you can easily make your Tiller data easier to understand based on your own personalized criteria.

3 Easy Ways to Timestamp Google Sheets

Here are 3 ways to use timestamps in Google Sheets to record when data is created or deleted and keep your spreadsheets organized.

Tags:Google Sheets Tips

How to Hide and Unhide Columns In Google Sheets

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.

Tags:filter google sheets Google Sheets Tips

How to Use Conditional Formatting in Google Sheets

Here's a complete guide to conditional formatting in Google Sheets to help you automatically highlight and easily visualize your spreadsheet data.

Tags:Google Sheets Tips

How to Lock Cells in Google Sheets (With Screenshots)

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.

Tags:Google Sheets Google Sheets Tips

How to Convert Currency in Google Sheets

Here are simple steps for converting currency and importing current exchange rates directly into Google Sheets

Tags:cryptocurrency GOOGLEFINANCE

How to Make Charts in Google Sheets

Easily create your own custom spreadsheet charts in Google Sheets. In this example, we use your spending data imported by Tiller.

Tags:Data Visualization

How to Import Financial Data from Tiller Into Another Google Sheet

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.

Tags:import IMPORTRANGE Spreadsheets

How to Export Bank of America Statements into Excel and Google Sheets

bank of american statements in spreadsheet

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.

Tags:Bank of America CSV

How to Export Wells Fargo Statements into Excel Spreadsheets

Follow these simple steps to import your Wells Fargo statements into Microsoft Excel and Google Sheets, where you can analyze them as you wish.

Tags:CSV Google Sheets Tips

How to Export Citibank Statements into Microsoft Excel and Google Sheets

Follow these simple steps to export your Citi Bank statements into Microsoft Excel and Google Sheets, where you can analyze them as you wish.

Tags:CSV

Smart Canvas to Bring New Functionality to Google Sheets

google sheets timeline view with smart canvas

Google's new smart canvas experience will make Google Sheets more dynamic and interactive, with better project management tools, easier formulas, and new APIs.

Tags:Google Sheets Tips

Start Your Free Trial