IFERROR

This function helps to trap errors and return a meaningful values in place of usual cryptic error entry if formula evaluates to an error in Excel. Syntax: IFERROR(value, value_if_error) value: the expression to be check for an error value_if_error: value to return if error is found Let’s illustrate this an example below #DIV/0! and #VALUE![…]

Shares 0

AVERAGEIF Function

AVERAGEIF gets the average numbers that satisfied one condition and return number representing the average. It is similar to the way we count and sum under COUNTIF and SUMIF respectively. Syntax: AVERAGEIF(criteria_range, criteria, [average_range]) Criteria_range: cells range that hold the cells to match our criteria Criteria: a condition to follow Average_range: the cell to average[…]

Shares 0

Flash Fill in Excel

Flash Fill This is an Excel feature that was first introduced in Excel 2013 as an alternative to simplify data cleaning process considered very difficult, time consuming, or not possible with existing methods. The way it works is similar to that of Text-to-Column but can handle the task of cleaning huge data in more faster[…]

Shares 0

PivotTable Recipe: another book authored by me is now available on Kindle Amazon

The purpose of business data analysis is not just to reveal objective answers about business issues but knowing the best and most flexible approach to explore, analyze, and extract the significant information of your target audience that will set you in the right direction toward increasing productivity and profitability from volume of unstructured data collected.[…]

Shares 0

PivotTable Recipe: another book authored by me is now available on Kindle Amazon

The purpose of business data analysis is not just to reveal objective answers about business issues but knowing the best and most flexible approach to explore, analyze, and extract the significant information of your target audience that will set you in the right direction toward increasing productivity and profitability from volume of unstructured data collected.[…]

Shares 0

SUMIFS Function

SUMIFS function was introduced in Excel 2007 to find conditional sum of values based on multiple conditions. In short, it sum cells that matched multiple criteria. Syntax: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],…) sum_range: cells to sum if the condition is satisfied criteria_range1: the first range to be evaluate with associated criteria criteria1: the first condition[…]

Shares 0

SUMIF Function

SUMIF is an Excel function that adds values based on a single criteria. Syntax: SUMIF(range, criteria, [sum_range]) range: selected cells to be matched criteria: condition that must be met sum_range: cells to sum if the condition is satisfied. This is similar to what we did under COUNTIF but instead of count based on a single criteria[…]

Shares 0