Friday, 1 August 2014

Data Analysis in Excel

 Data Analysis in Excel: 

Data Analysis in Excel

 

Excel is product of Microsoft used to store data in tabular format. So there is high requirement of data analysis.
There are various tools available to manipulate data in excel some of them are listed here with step by step screen shot.

Data Analysis in Excel:

1. Sorting:

It is used to sort raw data according to requirement.

2. Filter:

Filter is used to filter data according to their need.

3. Conditional Formatting:

It is used to apply formatting according to condition.

4. Charts:

chart is used fro data representation in effective and simple manner.

5. Pivot Tables:

Best way to represent the data. Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the

significance from a large, detailed data set.

Formulas:

0 comments:

Post a Comment