Posts

Showing posts with the label Common Error in Data Entry

Do the Data Entry in your Excel WorkSheet in a right way!

Image
Introduction Let's admit that entering data in your worksheet manually is not fun. Mostly, you get your data from other database in CSV and TXT format which you then import in your sheet or you do the copy from one location and then paste in your worksheet. But sometimes, it becomes necessary to feed data manually to your worksheet before you can unleash the power of Excel. It may be noted that data entry is a slow process and, if done in haste, it becomes prone to errors especially if you have delegated the data entry work to your subordinates (in many organizations there are data entry operators for this type of work).  The Data Entry work requires constantly looking at the source material and then typing it in the designated Cell of your worksheet. In most cases, you type the contents of one cell and then press Enter or Tab to move Down or Right of your cell. In most cases, you want to move down in your Excel Worksheet in row by row manner (especially if your source material is

Cleaning and Conversion of Raw or Improper Data into Proper Data

Image
   INTRODUCTION   The purpose of using excel is to analyze data and make informed decision. The analysis is based on the underlying data and its proper formatting and it becomes even more important as the input data gets larger. If you are doing the analysis, it is likely that some one else is doing the data entry for you or you are importing data from other sources such as *.csv or *.txt format over which you have no control. In both the cases, there are chances that the raw data that you will get is not perfectly suitable of analysis right away. In most cases, there are some inadvertent error which are made during data entry which require some sanitation or cleaning before the analysis.  You may face common errors as under: Inclusion of non-printable characters such as line break. This causes the text data to appear in zig zag manner and it is frustrating to remove such characters manually.  Multiple spaces or extra spaces in a sentence which can make your life difficult as the word