Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Before analysis start Important

Amol Mane
10/12/2019 0 0

Hi All, 

Often we do analysis in day to day life, before we start we should follow few principles of data cleaning activities in any application such as removing unwanted space, converting data into correct data type and arrangements of required data, we have below option in excel


1- Use Delimited option to remove or separate the data as per requirements

2- Remove unwanted space

3- Convert data formating from text to number, Date, time etc

4- If required remove duplicate data

5- Sort data basis Criteria

6- Remove blank cells/rows/columns

7- Update proper heading of columns and don't keep any duplicate heading

8- Most important is to keep original data file separate  as work on a copy of data until you get the desired outcome 

0 Dislike
Follow 2

Please Enter a comment


Other Lessons for You

Cell Properties

Gagan G. | 03 Feb

0 0

Multiple rows selections

Gagan G. | 03 Feb

0 0

Range Selections

Gagan G. | 03 Feb

0 0

Introduction to VBA editor

Gagan G. | 03 Feb

0 0

Macro Recording

Gagan G. | 03 Feb

0 0

Looking for Microsoft Excel Training Classes?

Find best tutors for Microsoft Excel Training Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for Microsoft Excel Training Classes?

Find best Microsoft Excel Training Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more