• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint