Subtotal Function in Excel is a wonderful formula that can be used to perform some specific arithmetic and logical operation on a defined range of cells.Microsoft Excel defines Subtotal Function as “It returns a subtotal in a list or database”.Subtotal formula takes two arguments:1. Operation Code2. Range of Cells.In the below … [Read more...]
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...]
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...]
