Tagged: Functions

Excel Crash Course

You may not be excel savy. You may not have required to use Excel all that much. But you would like to have a basic...

Subtotal Function

Subtotal function is a versatile function that can answer a lot of your needs all by itself. Besides it has some cool tricks in its...

Offset Function

When you want to select a cell (or range of cells), that is 2 rows down and 3 columns to the right from Cell B12,...

Sumproduct Function

Sum product function lets you calculate sum of values with corresponding arrays. For example, if you have sales quantites and unit prices for a series...

Unit Conversion In Excel

Excel has a built in unit converter. Not suprising isn’t it? Unit conversion is excel is done with CONVERT() Function. Here is how it works…

Index-Match Combination

We all love and use Vlookup Function very much. It is a great way to find and fetch values from big lists easily. But Vlookup...