Excel: How to Split Data in One Column to Multiple Columns
In some cases, the files we download from other applications does not come in a format that will enable us to analyse and present reports in Excel. For instance, if you copy information from a text file into excel all the data may appear in one column as shown below. In this above situation, we […]
XLOOKUP Replaces VLOOKUP in Excel 2019
It is often common that users refer to different tables or sources during entry in Excel. For instance, Product Sales report would refer to the product price list using unique product code. This referencing ensures fast data entry and minimize error. If you are a novice user, you probably know VLOOKUP as use Excel function […]
