|
|
|
|
|
How to use Quick analysis option in Excel 2013
Excel 2013 provides a useful innovation called Quick analysis, which gives you instant overview of your data in spreadsheet.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Create or open any analysis.
|
|
| |
2.
|
|
|
Select data in spreadsheet...
|
|
| |
3.
|
|
|
...and click Quick Analysis icon.
|
|
| |
4.
|
|
|
Quick analysis will offer you several options.
Select any of options.
I have chosen Color Scale.
|
|
| |
5.
|
|
|
Data in spreadsheet will get colors.
|
|
| |
6.
|
|
|
Click again Quick analysis icon and choose some other option.
|
|
| |
7.
|
|
|
On the end you can clear form of analysis by clicking Clear Format.
Experiment a little with all other options, to get the form you like.
Also recommended:
|
|
|
 |
|
|
|
Create a Chart by Pressing a Single Key in Excel
