Proper data entry in Excel is very important |
|
| Proper data entry in Excel prepares your worksheet for better analysis at a later stage. Also presentations of such data are more impressive. Incorrect data entry like trailing or leading spaces in text data in Microsoft Excel or leaving empty rows or columns between excel data can make your data calculations and analysis go haywire! The example shown in the Excel training video demonsrtates how a 'countif' function will deliver wrong results if the data entry is not proper. After correction of the Excel data using an appropriate Excel function like 'trim' the problem is solved! Other common mistakes while entering data in Excel are improper formatting of dates and writing of some text before or after numbers. Such data is treated as text by Excel and calculations cannot be done with such data. Tip: If you wish to have numbers as text place an apostrophe before the number. More on data entry in Excel: How to use Excel for data entry Data entry in Excel |
|