Lesson 260: Quick analysis in Excel

This article will show you how to do a quick analysis in Excel.

Quick analysis

Use the Quick Analysis tool in Excel to quickly analyze your data. Quickly sum, quickly insert tables, etc.

total

Instead of displaying a total row at the bottom of an Excel table, use the Quick Analysis tool to quickly sum up.

1. Select the range and click the Quick Analysis button.

2. For example, click Totals and click Sum to sum the numbers in each column.

Result

3. Select the range A1:D7 and add a column Totals -> running .

Note: row totals are blue and column totals are yellow-orange.

Board

Use tables in Excel to sort, filter, and summarize data. Pivot tables in Excel allow you to extract from a large, detailed data set.

1. Select the range and click the Quick Analysis button.

2.To quickly insert a table, click Tables and click Table.

3. Download files: Link and open the second sheet

4. Click a cell in the data table.

5. Press CTRL + q. This shortcut selects all data and opens the Quick Analysis tool.

6. To quickly insert a pivot table, click Tables and click one of the ones below

Format

1. Select the range and click the Quick Analysis button.

2. Add data bars, click Data Bars.

3. To add color, click on Color Scale

4. To add icons click Icon set

5. To highlight cells greater than one value, click Greater Than..

6. Enter the value 100 and select a format type.

7 Press OK

Chart

You can use the Quick Analysis tool to quickly create charts.

1. Select the range and click the Quick Analysis button.

2. Click Charts and click Clustered Column to create a column

Polylines

1. Download the file: Link and open the 3rd sheet

2. Select the range A1:F4 and click the Quick Analysis button.

3. Click Sparklines and click Line to add zigzag lines.

Result:

In addition, you can also view many other excel articles here.