Advanced EXCEL

Assigning a macro to a shape.
Assigning a macro to a button
Run a macro from the ribbon
Run a macro using a keyboard short cut key.

Using the TRIM () function, we can delete duplicate spaces and gives unique/single space between words.

Data Validation – is used to validate the Data in a cell/Range. In Data Validation, we have criteria such as List, Whole Number etc. And have custom criteria option where we can give function/formula.

There might be different ways to find duplicate values from a range. One of that is, using COUNTIF function we can find duplicate values.

Instead of VLOOKUP, we can use INDEX and MATCH functions. Limits of VLOOKUP is we cannot fetch the data from the left side of the Lookup range. Using INDEX-MATCH, we can fetch the data anyways.