Google Sheets Named Functions In 5 Minutes
What is a named function in Google Sheets and when is it best to use this new feature in your spreadsheet? Google Sheets new Named Functions feature enables you to …
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 SWITCH Formula Example: Refactor IF Functions By 20%
How do you use the Google Sheets SWITCH() formula? The SWITCH() formula in Google Sheets enables you to compress a series of IF statements, even nested IF statements, into one …
How To Set A Default Value For VLOOKUP
How can you set a default value when using the VLOOKUP function? As VLOOKUP throws an #N/A error when the searched item cannot be found in the first column range, …
3 Different Ways To Underline In Google Sheets: Shortcuts, Borders & Formulas
How many ways can you underline in Google Sheets? There are three broad approaches when seeking to emphasise text in Google Sheets by applying underlines. These three approaches are: underlying …
Create Unique ID With Dates: Google Sheets
How can you create a unique ID with date values in Google Sheets? To create a unique ID of date values in Google Sheets use the TEXT() function to change …
5 Easy Ways To Fix Google Sheets When It Is Slow
How do you fix Google Sheets when it is running slow? The five ways to speed up working in Google Sheets when it is running slow are: filter your data …
3 Ways To Wrap Text In Google Sheets
How can you wrap text in a cell in Google Sheets? There are 3 ways you can wrap text in a cell in Google Sheets. The most popular method is …
3 Ways To Make VLOOKUP Dynamic In Google Sheets (Examples)
How do you make the range and column index number in a VLOOKUP function in Google Sheets dynamic? The VLOOKUP function is a popular formula used in spreadsheets to source …
5 Ways To Alphabetize In Google Sheets (Examples With Screenshots)
How can you alphabetize or sort your data in Google Sheets? There are 5 ways to alphabetize data in Google Sheets: two approaches involve using formulas; namely, the SORT() and …
3 Ways To Use Multiple Criteria In Google Sheets QUERY Function (Examples)
Can you use multiple criteria to filter data in Google Sheets using the QUERY function? Within the query parameter of the QUERY function the WHERE clause enables users to filter …
Google Sheets: 3 Ways To Reference Data In Another Sheet (Examples)
How do you reference data in another sheet using Google Sheets? If you need to reference data in the same Google Sheet, there are two means: the sheet reference syntax …
How To Use The HLOOKUP Function In Google Sheets
How do you use the HLOOKUP function in Google Sheets, and what are some best use cases? The HLOOKUP function searches for data in the first row of a range …
How To Change Aggregate Name In Google Sheet QUERY Function (Examples)
How do you change the default aggregate name created in Google Sheets when using the QUERY() function? To change the header label of an aggregate column from a QUERY() function …
How To Aggregate Data From Multiple Sheets With QUERY In Google Sheets
How can you aggregate data using multiple sheets with the QUERY function in Google Sheets? To aggregate data sourced from multiple sheets, create a data set using the set notation …
Concatenate Multiple Ranges Into One And Filter Using QUERY: Google Sheets (Example)
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 …
Google Sheets QUERY Function WHERE Reference To Cell Value: Examples
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 …
Conditional Formatting With Checkboxes In Google Sheets
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 To Highlight Duplicates In A Range: Google Sheets 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 …
REGEXEXTRACT Date From String In Google Sheets
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 To Highlight Whole Row If Date In First Column Is Today: Conditional Formatting
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 …
