The SUMIF and SUMIFS math functions add values in cells based on criteria. COUNTIFS lets you use multiple conditions. The COUNTIF and COUNTIFS functions count the number of cells containing data that meets certain criteria. IF and IFS are also useful when you combine them with other functions. You can perform a test and return a true or false result based on criteria. The IF and IFS functions are invaluable in Excel. You can also select “Charts” to see the graphs Excel recommends for the data, “Totals” for calculations using functions and formulas, “Tables” to create a table or pivot table, and “Sparklines” to insert tiny charts for your data. Click this Quick Analysis button, and you’ll see several options to review.Ĭhoose “Formatting” to look through ways to use conditional formatting. You’ll see a small button appear in the bottom corner of the selected cells.

RELATED: How to Use Excel's 'Quick Analysis' to Visualize Data With it, you simply select your data and view various analysis tools provided by Excel. When you aren’t quite sure of the best way to display your data or if you’re a new Excel user, the Quick Analysis feature is essential. Conditional Formatting for Spotting Data Fast

How to get data analysis on excel