## Step by step guide on how to use Excel Dashboards to analyze data

This tutorial is suitable for individuals who generate reports for complex data processes using Ms. Excel charts, Gantt charts, Pivot tables among other tools. What is excel dashboard? A dashboard…

Comments Off on Step by step guide on how to use Excel Dashboards to analyze data

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

## If Functions with Three Conditions – Nested If Statement

The IF Function with single condition IF Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct…

Comments Off on If Functions with Three Conditions – Nested If Statement