Microsoft Excel 2013

How to Filter the Data in Excel using VBA

In this article, we will learn how to filter the data and then how we can give the different criteria for filtration by using the VBA in Microsoft Exc...

How to Create User Defined Function in Microsoft Excel

In this article, we are going to learn how to create user defined functions in Microsoft Excel by using the VBA. User Defined Function:- Microsoft Ex...

How to use comment option through VBA

In this article, we are going to learn how to use comment option in Microsoft Excel through VBA. Comment is the source by which we can convey the m...

How to Combine Multiple Columns into Single Column Using VBA in Microsoft Excel

In case you have a requirement on combining multiple columns to on column & you did not have a clue then this whole article is for you. In this ar...

Data Validity to Prevent Space before Text in Microsoft Excel

In excel if you every come across a scenario in which you do not want the other user from entering space before text then this article is for you. ...

How to extract unique numbers from a range in Microsoft Excel 2010

In this article, we will discuss how we can identify unique numbers in Microsoft Excel using formulas. There can be various scenarios. However, we ...

SUMPRODUCT with Criteria in 2 Columns in Microsoft Excel 2010

In this article, we will focus on how to use SUMPRODUCT function with criteria in 2 columns & extract the output, meeting all the conditions. Q...

Data Validation Width is too Small in Microsoft Excel 2010

In this article, you will learn how to increase the size of the selected cell that contains data validation. If you are working on a report that co...

Delete all Comments in Microsoft Excel

In Excel, while preparing reports for boss/management, we tend to insert comments in order to let the other person inform the status of the task. Comm...

Nested IF statement in Microsoft Excel

In case you want to learn Excel IF function then this article is for you. In this article, we will focus on describing the use of IF function in multi...

Page 2 of 812345...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube