Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to use Quick analysis option in Excel 2013
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

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.

 
  Author: Brodjan | Version: Microsoft Excel 2013 | 15th January 2014 |  
 
 
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:


 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO