Analyze data with excel for windows

Create a chart

Use the Quick Analysis tool to pick the right chart for your data.

1. Select the data you want to show in a chart.

2. Select the Quick Analysis button to the bottom-right of the selected cells.

3. Select Charts, hover over the options, and pick the chart you want.

Try it!    Select File > New, select Take a tour, and then select the Chart Tab. For more information, see Create charts.

Use conditional formatting

Use Quick Analysis to highlight important data or show data trends.

1. Select the data to conditionally format.

2. Select the Quick Analysis button to the bottom-right of the selected cells.

3. Select Formatting, hover over the options, and pick the one you want.

Try it!    Select File > New, select Take a tour, and then select the Analyze Tab.

Next: Tips for Excel for Windows