Blog
Practical Tips on Spreadsheet
Averageif and Averageifs In Depth
Averageif and Averageifs are used to calculate the arithmetic average of cells that meet specified criteria(s). The functions are available in MS Excel 2007 onward, and Mac Excel 2011 onward. Averageif Syntax =AVERAGEIF (range, criteria, [average_range]) Range...
Excel LEN Function
Finding Length of Text Excel LEN() function returns the length of a text string. It is often used with LEFT(), RIGHT() and MID() function to perform text manipulation. Together, these functions allow one to find a substring that is to the left or right of a certain...

Absolute and Mixed Reference in Excel
Absolute reference and relative references refer to whether cell address in formulas is fixated. Absolute references use a dollar symbol ($) to fix both row and column position, whereas relative references do not have the dollar symbol in front of row or column...

Excel Multiply Formula
You can use the asterisk symbol (*) to multiply either formulas, cells or values in Excel. Multiplication can be applied many times until you get the result. An alternative is to use the PRODUCT() function. An example is =PRODUCT(A1:A4) This will multiply all the...

ROUNDUP Function
Office 365 Excel Roundup function allows you to round a number to the nearest whole number or nearest 10s or 100s. Below are detailed examples of Roundup() function plus instructions on rounding up to nearest multiples. Syntax ROUNDUP (number, num_digits) number: the...

Sorting in Google Sheets
Sorting in Google Sheets allows you to arrange data the way you want, either in ascending order, descending order or custom order. Google Sheets provides Sort function in menu, Filter view that allows you to access sort functionalities and Sort() function for...

CountIf Excel
COUNTIF() in Excel counts the number of cells matching a criteria. You can use it to find cells that equal to certain text, date or values. Like SUMIF(), COUNTIF() function allows wildcard characters (? and *). Countif Function in Excel COUNTIF() function has the...

Project Collaboration with Gantt Chart Google Sheets
You are a project manager with a universe upon your shoulder. You want to collaborate tasks easily on GSuite just because you subscribed. What do you do? Answer: Create a Gantt Chart Google Sheets template. Below is a simple action plan: Create a Timeline Template or...

SUMIF Function
SUMIF() function sums up a numerical range given criteria from another range of equal dimension. The criteria can test whether the range equals to a certain text string, greater or smaller than a number, between certain dates etc. You can also use wildcards for fuzzy...

Excel Filter Function Comprehensive Guide and Examples
Description Excel Filter function is used to return multiple results matching a search criteria. It is available in Microsoft 365 current channel subscribers only. If you use Office 2019 or older versions to open a workbook built with FILTER() or other dynamic array...