-
·
Video: Using the new XLOOKUP Function in Google Sheets
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:
-
·
How to Import Bank CSV Files into Microsoft Excel
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 CSV. Unfortunately, it’s not easy to read your financial data in a CSV file. For…
-
·
How to Automate Leads from Apartments.com Into Google Sheets
Using the power of Google Sheets, Apps Script, and a bit of code to streamline potential tenant leads via Apartments.com.
-
·
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.
-
·
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.
