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 do you concatenate two ranges into one contiguous range for use in the QUERY function for the data parameter in Google Sheets? To concatenate two ranges into one for …
How do you reference a cell in the WHERE clause of a Google Sheets QUERY function? To reference a cell in the Google Sheets’ QUERY function WHERE clause, simply break …
How can you apply conditional formatting on checkbox cells in Google Sheets? Conditional formatting in Google Sheets can be applied to a range of checkboxes by applying the conditional formatting …
How do you highlight duplicates in a defined range using conditional formatting in Google Sheets? To highlight cells that are the same value in a range, select the range and …
How can you extract a date from a string in a cell in Google Sheets using the powerful REGEXEXTRACT() function? The REGEXEXTRACT(text, regular_expression) function has two parameters with the first …
How can you highlight an entire row based on a single condition in another column? To highlight an entire row based on a value in a column using conditional formatting …
What does $A$1 mean in a spreadsheet formula in Excel or Google Sheets? The syntax $A$1 is simply an absolute reference to cell A1. The reason why there are dollar …
How do you use absolute cell references in a spreadsheet like Excel or Google Sheets? An absolute cell reference is a reference containing the common column letter and row number …
How do delete an attached Google App Script file and project from a Google Sheet? I recently wanted to copy a Google Sheet and as I did I noticed it …
How can you apply conditional formatting using a custom formula that contains a relative reference to an adjacent row or column in Google Sheets? If you want to highlight a …
Can a Google Sheets drop-down list in a cell allow you to do multiple select? Google Sheets doesn’t natively support the ability to select more than one item on a …
How do you find the sum of data according to each unique instance of values in a column and then insert the sum calculation for each unique cell at the …
How do you make an email address in an Excel spreadsheet clickable? To make an email address clickable in a spreadsheet check the format of the cell is not set …
How can you create a conditional format in Google Sheets based on the value from another cell or column regardless of whether that cell is on the same sheet or …
What do you do when you’re running a Google App Script and you encounter the following error in the Execution Log area? Check the libraries you have attached to your …
If you’re working with data in Google Sheets you’ll soon come across a time when you will need to clean and format phone number data entries. To clean phone numbers …
How do you get the value from a column that is to the left of a VLOOKUP range? The VLOOKUP function is a powerful function that enables you to capture …
How do you format a cell that contains text like 1st Jan 2022 into a cell that Google Sheets can recognize as a date cell? There are certain types of …
How do you sort a range containing dates in Google Sheets? Sorting a data set in columns or rows containing date data in Google Sheets can easily be done by …
The SWITCH() function in Google Sheets is handy when dealing with multiple criteria based on a single result. The SWITCH() function takes at least 3 parameters, with the first parameter …
