Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. For example, the original structure of someone's name would be Smith, John and … [Read more...] about Reverse Last Name & First Name With Comma Using One Formula: Google Sheets
Spreadsheets
If there's one application I have come to appreciate more and more throughout my career it's the humble spreadsheet. Without this application, I would be lost.
I use this type of software every day and have been using it since 1995 and Microsoft Excel .
However, since working with Google Apps more frequently I've found I tend to do a lot more work with Google Sheets at work than Microsoft Excel. I have found the sharing and collaboration feature with Google Sheets a handy and powerful feature.
Google Sheets: IF Statement Multiple Conditions
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only three parameters which are all required. The first parameter is the … [Read more...] about Google Sheets: IF Statement Multiple Conditions
How To Check If Cell Is Empty (Or Not): Google Sheets
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is empty. What Does Empty Really Mean? In Google Sheets there are two ways of having an empty cell, … [Read more...] about How To Check If Cell Is Empty (Or Not): Google Sheets
What Is The Formula To Calculate Age?
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply subtract one date from the other and divide by 365, but this ended up not being as accurate … [Read more...] about What Is The Formula To Calculate Age?
Google Sheets Count If Not Blank: Best Approach
How do you count a range of cells and exclude counting empty or blank ones in Google Sheets? The easiest approach to count cells that are not blank is to use the COUNTA() function. The COUNTA() function has the following parameters: The … [Read more...] about Google Sheets Count If Not Blank: Best Approach
How To Lock A Column In Google Sheets
Very similar to our previous article on how to make a header row in Google Sheets, in this article we'll show how you can lock a column in Google Sheets. To lock a column in Google Sheets easily just navigate and click on the View menu, then on … [Read more...] about How To Lock A Column In Google Sheets