Select Page

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

## 7 Important Excel Functions to Know

Key Excel Functions to Know What are the 10% of Excel functions to know to achieve 90% efficiency? There was a Tweet on the 4 functions you cannot live without in 2020. While consensus do not always coincide, SUM(), IF() and VLOOKUP() are most frequently mentioned. IF...

## Timeline Template Google Docs

This Google Docs timeline template is made in Google Sheets. You can use it as a Gantt Chart or project timeline template by changing project dates. The intention of the template is to provide project managers with an easy-to-use Google Sheets doc for project...

## First and Last Working Day of Month

The idea behind the formulas for first working day of the month is very similar to finding the last working day. Essentially you find the last day of the month, then you add one to it or subtract from it. Below we will see how the combination of WORKDAY() function and...

## Excel Sum Colored Cells

In solving Excel sum colored cells problem without macro, it is best to think of a process that will let Excel recognise the cells you want to sum. Suppose you want to highlight cells in column B and have cell E2 sum up those coloured cells. Essentially we want to...

## Excel Crashing, File Issues and Solutions

As you use Excel on a daily basis, and as you start to work with files from other people, other companies or large data files, you will encounter issues. There are no standard solutions to each problems. However, you can look at the suggestions provided and see which...

## Top 7 Questions on Excel Trend and Platforms

Will Excel Be Replaced Excel is a swiss army knife that fills the gaps of proprietary softwares. It allows fast adaptation of situations, and come up with a solution that will take IT department a long time to come up with the resources to solve. Companies such as...

## Excel Slicer Not Working

Slicers can be used on either tables or pivot tables. If your Excel Slicer is disabled, grayed-out or not working, following the steps below: Excel Slicer Not Working Before Inserting Slicer Excel Slicer Grayed Out If your Excel file is in Compatibility Mode, it will...

## Calculate Percentage

The concept of percentage is very similar to fractions. To calculate a percentage we would think of the whole (the denominator in fractions) as a number that can be divided into 100 parts. We then ask ourselves what is the share of the smaller number (the part, not...

## Set Excel as Default

If your Excel 2016, 2019 is not in default program list, you will need to set Excel as default. Take the following steps: Go to Control Panel\All Control Panel Items\Default ProgramsChoose Set Defaults by App to set Excel as default.Click on Excel then click ManageFor...

## Convert Date to Month in Excel

To convert date to month in Excel, you can use TEXT() function to change the format to show month only or use Month() function to extract month as a numeric value. Excel Convert to Date Datevalue() function is the function that will turn a date in text format to a...