• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Analyzing Data with Microsoft Excel

Chapter 3. Analyzing Data with Microsoft Excel

Microsoft Excel provides several features and tools that you can use to analyze data in various formats. Understanding how these features work can significantly expand the types of data analysis tasks that you can complete.

Many data analysis tasks in Excel consist of sorting, filtering, formatting, and summarizing data. More sophisticated data analysis tasks can be performed with the built-in and add-in functions that Excel supplies. In this chapter, you’ll learn basic sorting, filtering, and querying skills as well as learn about the tools you use for more sophisticated statistical analysis and “what-if” scenarios. You will not only learn how to work with data stored in Excel worksheets, but also how to bring external data into Excel—data from a server-based database or data from the Web, for example—and use Excel’s data analysis features and tools on the imported data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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