Global Sum
Here is a quick tip for summing values from different sheets. With this very powerful sum function, you can get totals of different sheets in...
Category: Formulas
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 surprising isn’t it? Unit conversion is excel is done with CONVERT() Function. Here is how it works…
Fancy Characters
Do you know that you can use symbols from different fonts as fancy indicators? You just need to know which characters to use with which...
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...
