Advanced Filter in Microsoft Excel

Advance Filter feature in Excel facilitates the easier way to extract records from dataset using complex criteria while saving lot of time. For instance, the criteria for filtering in our earlier Filter demonstration “How to Filter Records in Excel”  include “BAJAJ BOXER” as product and “MUSA” as Sale Rep. which took us up to eight steps[…]

Shares 0

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

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

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

My Book “Productivity Boosting Aspects of Microsoft Excel” is now available on Amazon Kindle

Knowing the effective and efficient approach of turning this huge raw data into relevant information to enhance business success in today’s challenging and competitive-environment inform the written of this book “Productivity Boosting Aspects of Microsoft Excel” to Instil Data Intelligence using Microsoft Excel.   The book focused more on how to helps improve your Microsoft Excel skills and[…]

Shares 0

COUNTIF and COUNTIFS

COUNTIF function in Excel is use to counting cells within selected range that met a certain condition. Syntax: COUNTIF(range, criteria) Range: this is the selected cells to count from Criteria: it spelt out the condition to be met doing the counting The following example elaborate more on how COUNTIF works. The formula asked excel to[…]

Shares 0

Useful Excel Keyboard Shortcuts

The table below shows useful Keyboard Shortcuts in Excel. You can download it here S/N Excel Keyboard Shortcut Usefulness 1 F1 Display Excel Help task pane 2 F2 Edit active cell 3 F3 Show paste name dialog box 4 F4 Repeat last action or make absolute cell to absolute 5 F5 Show go to dialog[…]

Shares 0

Mail Merge with Excel File

XYZ COMPANY recently concluded a recruitment exercise to selected positions. You were given the list as an HR officer to send an appointment letter to all the successful applicants’ email address. The letter must be addressed to an individual with following details from Microsoft Excel file. What comes into your mind in this situation, are[…]

Shares 0