EXCEL- QUICK DATA ANALYSIS
In Microsoft
Excel, it is possible to do data analysis with quick steps. Further, different
analysis features are readily available. This is through the Quick Analysis
tool.
Quick
Analysis Features provides the following analysis features for instant data
analysis.
Formatting
Formatting
allows you to highlight the parts of your data by adding things like data bars
and colors. This lets you quickly see high and low values, among other things.
Charts
Charts are
used to depict the data pictorially. There are several types of charts to suit
different types of data.
Totals
Totals can
be used to calculate the numbers in columns and rows. You have functions such
as Sum, Average, Count, etc. which can be used.
Tables
Tables help
you to filter, sort and summarize your data. The Table and PivotTable are a
couple of examples.
Sparklines
Sparklines
are like tiny charts that you can show alongside your data in the cells. They
provide a quick way to see the trends.
Quick
Analysis of Data
Follow the
steps given below for quickly analyzing the data.
Step 1: Select the cells that contain the
data you want to analyze.
The colored
Data Bars that match the values of the data appear.
Step 3: Click on Color Scale.
The cells
will be colored to the relative values as per the data they contain.
Step 4: Click on the Icon Set. The icons
assigned to the cell values will be displayed.
Step 5: Click on the option-Greater than.
Values
greater than a value set by Excel will be colored. You can set your own value
in the Dialog Box that appears.
Step 6: Click on Top 10%.
Values that
are in top 10% will be colored.
Step 2: Move over the charts recommended. You can see the Previews of the Charts.
Step 3: Click on More as shown in the image
given below.
More
Recommended Charts are displayed.
Step 2: Click on %Total. This option is to compute the percent of the row that represents the total sum of the data values selected.
Tables
Tables help
you sort, filter and summarize the data.
No comments:
Post a Comment