Blog

Practical Tips on Spreadsheet
Averageif and Averageifs In Depth

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...

read more

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...

read more
Absolute and Mixed Reference in Excel

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...

read more
Excel Multiply Formula

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...

read more
ROUNDUP Function

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...

read more
Sorting in Google Sheets

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...

read more
CountIf Excel

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...

read more
Project Collaboration with Gantt Chart Google Sheets

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...

read more
SUMIF Function

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...

read more

Archives

Pin It on Pinterest

Share This