Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

In this chapter, you learned how to use Excel to

• Find the absolute highest or lowest data value in a list by sorting.

• Filter records to show only the data you’re interested in.

• Highlight data trends and anomalies through conditional cell formatting.

• Import external data, including Web-based data, to use Excel’s analysis tools on the data.

• Extend data analysis tasks with worksheet functions.

• Create charts to spot data details and trends more quickly.

• Use the Analysis ToolPak to display a list of descriptive statistics, a histogram, a moving average, relative data value rank and percentile, and representative data sampling.

• Use the Solver Add-In to run best-case or worst-case scenarios or “what if” scenarios.

In the next chapter, “Analyzing Data with PivotTable and PivotChart Reports,” you will learn what PivotTable reports and PivotChart reports are used for, as well as how to analyze data with PivotTable reports and PivotChart reports.