We all know the benefits of using a spreadsheet program over simply placing data on a text document. Turning that said data into a spreadsheet helps us organize and easily do work with that data. You might have recently downloaded a PDF file online or from a friend and it’s got a lot of datasets … Read more
With my business, I had an issue on Google Sheets where I wanted to add two numbers automatically. However, the addition operation would only happen if 2 different criteria (2 different conditions) were met in 2 different cells. Now I already know how to add two numbers based on a single condition from another cell, … Read more
Do you like to color-code your cells? Most of us do it. It makes it easy to understand what’s going on with just a glance. When you have a lot of data listed all the way down to the bottom of a spreadsheet, it can be pretty daunting. Thankfully for us, Google Sheets (or any … Read more
Referring to data from the same file is a simple task. In fact, if you’re interested, I’ve written an article about that here (How to link a single data cell between different Google Sheets). Can you actually refer to data that’s located in one Google Sheets file and make it show up in another separate … Read more
When you create a document or a spreadsheet with Google, you can do a lot of what Google likes to call collaboration. This is the method of sharing and working on the same file at the same time. In fact, if you are working on the same file as a friend who’s collaborating with you, … Read more
I have a few rental homes that I own and rent to tenants. When I first started renting them out, I was holding onto a book and I recorded every transaction, every expense, and every payment from these 2 homes. It wasn’t elegant and my handwriting wasn’t quite legible but I made do with what … Read more
So you’re asking yourself if you should make the switch over to Google services. Trust me, I’ve been there once and I haven’t really looked back since. Moving from Microsoft Excel to Google Sheets requires converting everything over to Google Docs, Sheets, Slides, Drive, etc. While that may sound like a daunting task, it really … Read more
One of the worst kinds of emails is those that have tons of information and data typed into the text that sort of confuses the receiver. It’s oftentimes pretty overwhelming to read lines upon lines of text with tons of facts and data in it. Have you ever been in this situation? Maybe it was … Read more
I want to go through with you a short tutorial on how I created the style on one of my Google Sheets spreadsheets. I think Google Sheets is a wonderful tool to punch in data and display it in a meaningful and easy way. It provides us with a broad spectrum of capabilities and can … Read more
Most people know that there’s a way to easily add numbers to a spreadsheet. But in case you have never used Google Sheets before or any spreadsheet program for that matter, Google Sheet has the ability to perform functions to a list that you provide it. This list can oftentimes be a set of numbers. … Read more