# Category Archives: Microsoft Excel

## Why Vlookup when there is Index?

Vlookup: The syntax for Vlookup is: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Index: The Syntax for Index is: INDEX( array, row_number, [column_number] ) Match: The Syntax for Match is: MATCH( value, array, [match_type] ) Problem:… Read more »

## Add a calculator to the Excel toolbar

There’s a calculator in Excel 2010 but by default this feature is hidden, to get the calculator on your Excel screen navigate to Quick Access toolbar options, it’s the down… Read more »

## How to Count unique values with CountIf function?

A common function many people use is the COUNTIF function and that will count any value you choose. But there isn’t one function to count unique values. But we can… Read more »

## Power of Paste Special – Multiply

For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog. Suppose you have been… Read more »

## How to remove leading spaces from Excel cells?

Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… Read more »

## Calculate the number of working days between two dates

As an Excel or data analyst, dates in datasets are common and usually involve some work to take from raw data stage into meaningful reports. Employee datasets, sales datasets and… Read more »

## How to convert a date into a month name?

Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »

## Trick to Complex Excel Formulas

There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarize or extract data from poorly structured workbooks. I’m not talking… Read more »

## A trick with MONTH() Function in Excel

I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so… Read more »

## When to use Multi-Cell Array Formulas

Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’ in the name. Let’s look at an example, say we… Read more »