Excel uses "Levels" to gain insight into data changes and trends

Staff often need to analyze and summarize large amounts of data stored in Excel to discover trends and implications of data. For example, in the Sales Performance table shown in Figure 1, how do you quickly show how each employee's sales compare in 1 ~ March?

Figure 1 Sales Performance table

The "Levels" feature of Microsoft Office Excel 2007 enables you to quickly understand the distribution trend of your sales data by taking advantage of color changes to indicate the level of data values.

(1) Select the sales data range in the Excel worksheet, and then click the Conditional Formatting button in the Styles feature group on the Start tab of the Ribbon.

(2) in the conditional format Drop-down list, select the Levels ︱ red-yellow-green order, as shown in Figure 2, the range of data selected in the Excel worksheet is immediately displayed in the specified color level format.

Figure 2 using "levels" to analyze the Employee Sales Performance table