USE QUICK ANALYSIS TOOL TO ANALYZE LIKE A CHAMP IN EXCEL

This video features the uses of Excel’s Quick Analysis Tool and illustrates how you can use it. This tool is like a Swiss Knife of data analytics filled with powerful tools to help you manage your data sets of any size. Here we 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 one click of the Quick Analysis button uncovers the following tools to analyze or 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

All of those functions are in one button found at the bottom right corner of the highlighted data.

Title: Use Quick Analysis Tool to Analyze Like a Champ in Excel

#quickanalysistool #excelformatting #excelshortcuts #excelanalysis