How To Add In Excel: Use + Or A Formula? (Examples)
A spreadsheet helps users to be able to perform calculations without doing this process manually by hand. As you come to use spreadsheets more often you’ll be impressed at the …
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.
How To Separate Characters Into Cells In Excel
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
How Do You Type A “+” (Plus) In Excel?
When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have …
How To Get Rid Of E+(Number) In Excel
When using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35. How do you get …
Why Does VLOOKUP Return #N/A When Value Exists? (Examples)
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
How To Use Multiple Ranges In QUERY Function: Google Sheets
The QUERY formula is a great way of being able to perform basic SQL-like commands on a data range. The signature of the QUERY formula is as follows: The first …
How To Unmerge Multiple Cells With One Click: Google Sheets
Merged cells are a great way to span content over multiple cells, and you can easily remove a single merged cell with one click by clicking on the merge cell …
How Do You Put Multiple Conditions In One Cell In Google Sheets?
There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There …
Reverse Last Name & First Name With Comma Using One Formula: Google Sheets
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. …
IF Formula With Multiple Conditions: Google Sheets
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 …
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 …
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 …
How Do I COUNTIF Non-Blank Cells In Google Sheets?
The COUNTIF function in Google Sheets is a simple function which allows for the user to count a range of cells according to one specific filter. If more filters are …
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. …
How To Make A Header Row In Google Sheets
I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I …
How To Format Numbers In Thousands (K) In Google Sheets
Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real quick!
DATEDIF How to Calculate Difference Between 2 Dates (Many Examples)
How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets there is a handy little function called DATEDIF (date dif) which can do more than just find the difference in days between two dates.
Flip ARRAY_CONSTRAIN Formula in Google Sheets (Example)
The only limitation with the ARRAY_CONSTRAIN function is it fetches from the upper-leftmost corner of the range. Here we combine the QUERY and TRANSPOSE functions to flip a range, so the ARRAY_CONSTRAIN formula can fetch from the lower-rightmost corner of a range.
Ignore Blank Cells in QUERY Function Google Sheets
When using the QUERY function in Google Sheets how can we ignore certain rows based on the criteria of some cells being blank?
Merge Two Columns Using QUERY: Google Sheets (Step By Step Example)
How do you merge multiple columns into one column in Google Sheets using the QUERY function? In this 4 simple step-by-step process we share the formula, and teach you along the way on how component within the function works by providing commentary and photos at each change.
