List of Exams and Updates

Creating VBA Form in Excel for Data Entry

Today we will learn an advance and very useful topic in VBA Excel. We will learn to create a VBA form for data entry...

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