Skip to main content

5 Data Entry Tips to Speed Up Data Cleansing in Excel


Do you find data cleansing really boring?

Frequent dealing with error in data for long hours can piss you off. You don’t like to face off those flaws anymore. But, what would you do to your commitment with the firm assigning data entry in the UK or elsewhere? Would you like to credit some more hours or days to accomplish those records?

Why don’t you try some data entry tips to speed up data cleansing in the Excel data sheet?
I bet your data won’t suffer from discrepancies. Here is a rundown of a few Excel data entry tips to carry on while you cleanse a huge set of data.
  1. Finding and Replacing:
Do you scroll up and down or move cursor to and fro to spot the errors?

You don’t need to do so because you have the Find and Replace function. It can automate searching and then replacing the intended data. You can change numbers, text, zeros, references in formulas and change formatting also.

How can you find and replace in Excel?
  • Select the cells where you want to find and replace.
  • Go to the Home menu.
  • Select Find and Select option.
  • A dialog box will pop up.
  • Input what you want to find in ‘Find What’ field.
  • What you need to replace with, insert that value in the field next to ‘Replace With’ in that dialog box.
  • If you want to find and replace all, hit the Find All and Replace All buttons.
  1. Treating all blanks:
Blanks are fearsome-this is what I realised while creating reports and dashboards. If you think that you can manually do, it’s absolutely true. You can do. But, how long will you do it while cleansing millions of datasets?

Save your precious time. Select all blanks altogether. And, fill them with certain value.
Try these steps to select blanks:
  • Select the data wherein you want to spot the blanks.
  • Press F5 key.
  • A dialog box will pop up.
  • Hit ‘Special’ tab at the bottom.
  • Choose ‘Blanks’ to select.
  • Hit ‘Ok’ tab.
Fill blanks with a value:
  • After selecting all blanks, type whatsoever you want to fill them with, like 0.
  • Press Ctrl+Enter.
These steps will insert the same value in all blanks within a wink.
  1. Converting copied number as text into numbers:
Did you press an apostrophe or any other character while entering the numeric data?
I, often, make such a silly mistake. But, this mistake can lead to a blunder in the master report. Your calculations may show errors. So, what you all need to do is:
  • Type 1 in a blank cell in the excel sheet.
  • Select it.
  • Press Ctrl+C to copy it.
  • Now, select the range in your database.
  • Press Alt+E+S to open ‘Paste Special’ option.
  • Its dialog box will appear. Hit the radio button of ‘Multiply’ under Operation.
  • Press ‘Ok’ to convert all the copied numbers as a text into numbers again.
  1. De-duplication:
Clones, often, breed confusion. The duplicate data lead to wrong calculations. The duplicates should be rectified with intensive caution. Let’s have a look over how to highlight duplicate data entry and then, delete it in a jiffy:
Steps to highlight duplicate data:
  • Select the range or data.
  • Go to the Home menu.
  • Select ‘Conditional Formatting’ from there.
  • Now, choose the subset -‘Highlight Cells Rules’ and then, ‘Duplicate Values’.
  • Specify the formatting to highlight duplicate entries.
Steps to delete duplicate entries:
  • Of course, you have to select the range.
  • Move the cursor to the Data menu.
  • Select ‘Delete Duplicates’ option.
  • A dialog box will emerge.
  • Select the columns or rows where you want to remove duplicates from.
  • Press ‘Ok’.
  1. Spell check:
If you reality want to maintain the credibility of your work, never let your client point at the typo errors. You can check the spelling through Google. Or, you can:
  • Press F7 key to determine the misspelt words.

Comments

Popular posts from this blog

Retail Market Analysis

Let us first understand the meaning of Retail Marketing. Retail marketing is the range of activities performed by a retailer to develop knowledge, awareness and sales of the company’s products. This is quite different from other types of marketing because of the factors and elements of the retail trade like selling finished goods in small number or amount to the consumer or end user, generally from a fixed location. Retail marketing uses the common principles of the marketing blend i.e. product, price, place and promotion. A study of retail marketing at university level includes effective vending and selling strategies, shopping and consumer behavior, branding i.e. categorizing and advertising. Retail marketing is especially essential to small retailers trying to compete against large chain stores.

Advantages and Disadvantages of Outsourcing Data Entry Services

Outsourcing data entry project can be advantageous as well as disadvantageous. Before nodding for it, look at its cost, risk, repo and track record to avoid the bundles of inaccuracies in data entry .   Outsourcing has become familiar term for acquiring data entry services. Advantages and disadvantages walk hand in hand in terms of cost, risk, repo and track records of the data services. An entrepreneur should be aware of the facts regarding data entries that can make them enriched overnight or can land you behind bars in allegation of hacking or misinterpreting or loosing data. Reduced overhead expenses as well as risk, cost-effective, time to focus on key areas, improved production are the merits or advantages that certify data entry services should be outsourced. On the contrary, data hacking, low quality of data entries, exceeding the deadlines for the project, over expenses and streamlining process of these appear as the demerits or disadvantages of the outsourcing...

Actionable Solutions to Counter Data Mining Issues by Hadoop

Competition has been in the air of the business biosphere. But in the present scenario, it’s hazier than ever. Have you ever seen the messaging app as an end-to-end solutions providing landscape in ages? Today we have FB messenger to which artificial intelligence makes smarter like a human by senses. How did Mark Zuckerberg conceive that idea? It simply is the miracle of iconic decision driven from big-data. Why big data? Big data hides transformative decisions. Let’s understand through this example. Do you know why retailers call to outsourcing market research? To be at the top is undoubtedly the biggest goal to achieve. But without capturing deep insight, topnotch is just a dream. The actionable decision-making underlies this insight. Let’s say, retailers come to know what customers need and what their attitude is through mining their data. By blending them up in the driven decisions, viable plans are drafted. As a result, the customers get motivated to buy. On its basis, the ret...