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.

Using Excel’s Multiple Criteria In VLOOKUP Function

Microsoft Excel’s VLOOKUP function is a popular feature amongst office personnel and data processor positions.

VLOOKUP for Dummies

VLOOKUP stands for Vertical Lookup. Learning vlookup is very easy but let’s first understand how VLOOKUP works?