Excel CONCATENATE Function Tips

Removing Duplicates In Excel

We frequently encounter data while working with lists. It is a common problem caused by human error as well as duplication of data due to common practices – copy and paste procedure for consolidation of data.

VLOOKUP for dummies

The simplest way to retrieve data in a database using a one criteria is use of VLOOKUP function. It is good to know that VLOOKUP function can be used with two or more criteria columns.