Drop down list is a tool that can help you to force users into selecting a specific value from a predefined set of values. It is always good to have drop down lists for accepting user inputs.This approach is better because it validates each input from user against a predefined set of values and hence users can only input valid and excepted … [Read more...]
Search Function in Excel – How to Use
Last Updated on February 2, 2021 by
As the name suggests Search Function in Excel can help you to locate one string (or character) inside another string. The output of the Search function is a number that is equal to the start position of the substring inside the input string. Search function when combined with Mid Function can be used as a powerful substring method.How … [Read more...]
How to Enable Macros in Excel
Last Updated on July 21, 2015 by
Macros can be defined as a set of instructions that can be used to perform some specific tasks in Microsoft Office applications. The availability of macros is very helpful for the users as they can create user defined programs and functions specifically designed to perform their tasks.Although macros are so useful, but if misused they can play … [Read more...]
SubTotal Function In Excel – How to Use
Last Updated on July 21, 2015 by
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
Last Updated on July 21, 2015 by
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
Last Updated on July 21, 2015 by
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
Last Updated on July 21, 2015 by
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
Last Updated on July 21, 2015 by
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...]
