Transpose Function in Excel – How to Use

The term transpose literally means swapping rows and columns. And similarly transpose function in excel flips rows into columns and vice-versa. Transpose is an array function i.e. it can only be applied on a range of cells. And today in this post I will be guiding you on how to use transpose functionality in excel.What are Array Functions and why … [Read more...]

Excel Indirect Function – How to Use

Excel Indirect Function is one of the most useful functions in Microsoft Excel. Indirect function takes a cell reference in the form of a string, then it evaluates the reference and shows its content. This gives you a better way to deal with variable cell references.Excel Indirect Function Syntax:The syntax of indirect function is quite … [Read more...]

Find Merged Cells in Excel

There are times when you try to sort a column in your spreadsheet and it throws an error saying that, “To do this, all merged cells should be of same size”. As you can clearly see that this issue is due to the presence of merged cells in the column to be sorted.  To resolve this issue you simply need to find the Merged Cells present in the … [Read more...]

Excel SUMPRODUCT Function – How To Use

On hearing the name of Excel SUMPRODUCT Function for the first time, it looks like some useless formula that can do some predefined sum and product operations. But actually it’s far from that definition. In fact it is a very useful function if you need to analyse the data of two or multiple arrays in excel.How Excel Defines SUMPRODUCT … [Read more...]

Online Excel Viewers – Few Tools to View Excel Files Online

In our day to day life we are too heavily dependent on Excel files. We create our reports, graphical charts, monthly budgets using it. But one thing that continuously annoys me is, that these excel spreadsheets can only be opened or viewed using few third party tools (like MS Office or Open Office). Windows doesn't have any stock application that … [Read more...]