Posts tagged "Excel"

Learn how to compare two columns in Excel

Like a two-dimensional database, Excel is capable of storing many different types of data from small business contacts to personal income tax records. In both of these examples, accuracy is essential to make sure you have the information you need when you need it. In any data entry situation, people often transpose numbers wrongly or […]

Tricks of Text to Columns in MS Excel

One of the Advanced Excel techniques is Text to Columns. Excel’s “Text to Columns” feature is used for the following tasks: Splitting text of one cell in multiple columns (opposite of Concatenate) Changing the data format of a column (General, Text, Date) Converting numbers with trailing minus sign into negative numbers Converting invalid date formats […]