This video features the uses of Excel’s Quick Analysis Tool and illustrates how you can use it. Quick Analysis Tool is like a Swiss knife of data analytics filled with powerful tools to help you manage your data sets of any size. Here you can do quick formatting to add visual representation, and help identify distinct figures like the highest and the lowest. It includes charts, color coding and formulas.
Just 1 click of the Quick Analysis button uncovers the following tools to analyze and format your data:
• Formatting Tools
o Data Bars
o Color Scale
o Icon Set
o Greater Than
o Top 10%
• Charts
o Clustered Column
o Clustered Bar
o Line
o Pie
o Scatter
o Other Recommended Charts
• Totals (Rows and Columns)
o Sum
o Average
o Count
o % Total
o Running Total
• Tables
• Sparklines
The functions listed are in one button found at the bottom right corner of the highlighted data.

Analyze Like a Champ! Use Quick Analysis Tool

#excelquickanalysistool
#howtouseexcelquickanalysistool
#quickformatting
#howtoquicklyadddatabarscolorscaleiconset
#howtoquicklyaddcharts
#howtoquicklyaddtotalsandothercalculations

Please take the opportunity to connect and share this video with your friends and family if you find it useful.