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...]

How to Hide Formulas in Excel

Using formulas in excel can make your day to day tasks easier. Excel provides formulas for just about anything. But if you are sharing your spreadsheets with other people then it looks quite rude to write formulas as it is.  All the formulas and the calculation stuff should be hidden from the viewers. The best way to do this is to hide … [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...]