Installing an Add-In in Excel 2010 / 2007 / 2013 / 2016
Excel Add-Ins are third party components which can be installed into MS Excel anytime. It extends functionality and power of Microsoft Excel. This is...
Assigning Macro to Button in Excel
Do you want a button to run a VBA macro in excel?Remembering shortcuts for each and every macro is not easy so you probably...
Creating A Simple Macro and Add-In
What are Macros and Add-Ins?
Macro is a set of commands which can be executed anytime to perform a task. Recording or writing macro is...
Creating Drop Down List in Excel
Do you want a list of items available in a cell as a drop-down list?
You can add a drop-down list in a cell using...
Excel If Else
MS Excel IF ELSE is logical function in which performs logical test. We check multiple conditions with IF ELSE in a single formula which...
Excel Vlookup
Vlookup is most widely used formula in Excel. Vlookup stands for “Vertical Lookup”. It searches the first column of a table array and then...
Excel CONCATENATE function
Excel CONCATENATE function is one of the best time saving Excel function. You must have seen people copying the value from one cell and...
Excel Right Left and Mid Functions
Excel Right, Left and Mid functions return number of characters from selected text. These formulas can be used to get a pattern of characters...
Excel Trim Function
Excel Trim function is very useful function that removes extra spaces from data. This formula removes all spaces from data except for single space...
Excel Length of Formula
Excel Length of Formula
Excel LEN formula is used to get number of characters in a cell. The formula counts the number of characters in...