Advanced Excel

Mail Merge in Excel

Mail merge is used to print letters or to send Email Messages to multiple addresses. For Example, If you have […]

There are two types of controls in Excel – ActiveX and Form controls. These controls can be accessed from Developer

Dynamic charts in excel are useful when we add new data to our existing data tables. For example, lets take 1st quarter sales

Dynamic dropdown list in Excel: Dynamic dropdown list in excel falls under Data Validation. This can be accessible in Data

INDIRECT function in Excel returns the reference specified by a text string. The syntax for this excel function is as

ACCRINT To calculate accrued interest, Excel has a function called ACCRINT. Using this function, we can calculate accrued interest for