This article will show one approach to correct the exponential number format referencing issue in a cell, especially when dealing with csv files. Sometimes, as…
Insert multiple columns using Excel VBA
This video will outline an approach via VBA, to insert multiple columns at once into an Excel worksheet. This insert multiple columns macro will give us the flexibility, to choose numerous columns to insert simultaneously.
How to do a VLOOKUP – A Look into the basics
Excel’s VLOOKUP function is undoubtedly one of the most popular Excel functions. It can readily interpret and report values in large data arrays and unlike a PivotTable, which needs to be manually updated to reflect source data changes; VLOOKUP will seamlessly update to reflect such changes.