It used to take a bit of work
to analyze data, but now it only takes a few steps. You can instantly create
different types of charts, including line and column charts, or add miniature
graphs (called Sparklines). You can also apply a table style, create
PivotTables, quickly insert totals, and apply conditional formatting.
Here’s what you do:
·
Select the
cells that contain the data you want to analyze.
·
Click the
Quick Analysis button image button that appears to the bottom right of your
selected data (or press CRTL + Q).
·
In the Quick
Analysis gallery, select a tab you want. For example, choose Charts to see your
data in a chart.
·
Pick an
option, or just point to each one to see a preview.
Note: You might notice that the
options you can choose aren’t always the same. That’s because the options
change based on the type of data you have selected in your workbook.
Which analysis feature should
I use?
If you’re not sure which
analysis option to pick, here’s a quick overview:
Formatting - lets you highlight parts of
your data by adding things like data bars and colours. This lets you quickly
see high and low values, among other things.
Charts - Excel recommends different
charts, based on the type of data you have selected. If you don’t see the chart
you want, click More Charts.
Totals - let you calculate the
numbers in columns and rows. For example, Running Total inserts a total that
grows as you add items to your data. Click the little black arrows on the right
and left to see additional options.
Tables - make it easy to filter and
sort your data. If you don’t see the table style you want, click More.
Sparklines - are like tiny graphs that
you can show alongside your data. They provide a quick way to see trends.
No comments:
Post a Comment