Friday , December 15 2017
Home » Ms.Office » Data Analysis

Data Analysis

Data Analysis in Microsoft Excel

This features of excel allow you to analyze data for different purposes.

1 sort: you  can sort data on one or multiple columns in excel  sheet. also you can sort  data in ascending or descending order.

2 Filter: Apply this function if you need specific data or certain criteria in excel sheet.

3.Conditional formatting in excel  enable you to highlights cells with a  certain colors depending on  cell value.

4.Chart function of excel can  be used, when you need a data to be shown in  a chart.

there are different formats of chart you can apply on your data.

5.Pivot Table use to analyze, summarize excel data in a Table  format , which enable you to easily  see all the data at a glance.

6 Table Facilitate your to analyze your excel sheet data  quickly and easily.

About Naimatullah

Check Also

Job card

How to create Job card in MS.Excel

Definition of Job card: Job Card is the complete summary of a business transaction. Job ...