- Using conditional formatting to showcase data trends
- Adding sparklines
- Understanding Excel formulas and functions
- Performing common calculations
- Subtotaling data values
- Entering formulas
- Troubleshooting formulas
- Working with functions
- Creating and modifying data tables
- Sorting data
- Filtering worksheet data
- Creating PivotTables
- Viewing data instantly with Quick Analysis
Viewing data instantly with Quick Analysis
Quick Analysis is a new feature in Excel 2013 with which you can apply different analysis tools to the data you’ve selected on your worksheet. It’s easy to use and can show you at a glance what trends are appearing in the information you’re gathering.
Apply Quick Analysis
In an open Excel workbook, drag to select the cell range that you want to analyze.
The Quick Analysis tool appears just below and to the right of the range you selected.
Click the Quick Analysis tool.
A palette of tools appears, showing you different options for analyzing the selected data. You can choose to apply conditional formatting tools, display the data as a chart, use Total functions, display the data in tables, or add sparklines to show data trends.
Click the desired category.
Click the analysis tool that you want to apply.