IF Statement with Four Outcomes

IF statement Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. An if statement with four outcomes requires you to…

Comments Off on IF Statement with Four Outcomes

How to return Multiple Values Vertically Using VLOOKUP in excel

VLOOKUP function returns a corresponding value of the first instance in a lookup value. The function searches specific value defined and returns the matching value in another column. The VLOOKUP…

Comments Off on How to return Multiple Values Vertically Using VLOOKUP in excel

IF Statement with Three Outcomes

IF statement is used to test whether a certain condition is met. Sometimes you can have more than one condition to test thus creating an If statement within another if…

Comments Off on IF Statement with Three Outcomes

How to Concatenate Values of Pivot Table

Concatenate is an excel function that allows you to join two or more strings together. When creating Pivot table you may want to combine data from two or more columns…

Comments Off on How to Concatenate Values of Pivot Table

Excel Pivot Table with nested rows

A Pivot table is one of the powerful features in excel for any data analyst. The feature allows you to extract data from a large dataset. You can also create…

Comments Off on Excel Pivot Table with nested rows

List of EXCEL Date Functions

1. TODAY function This function returns the current date. This function is useful when you want the current date displays on your worksheet. The returned value will be updated each…

Comments Off on List of EXCEL Date Functions

Find and Replace Using Multiple Values

Find and replace is an excel feature used to search for specific data in an excel worksheet or within a workbook and what you do with the data found. This…

Comments Off on Find and Replace Using Multiple Values

How to do Formula Nesting in Excel

Sometimes when working with Excel, you may need to do a calculation that involves several formulas. One way of handling this is to break each formula out in its own…

Comments Off on How to do Formula Nesting in Excel