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

Chapter 4. Manipulating Data Annoyances

Chapter 4. Manipulating Data Annoyances

Chapters 1 through 3 were all about getting data into Excel, summarizing it, and making it look pretty. In this chapter, you'll make your data tell you what you need to know—to run a business, to manage a sports team, or to figure out how much money you'll need to make those mortgage payments.

I'll start out by showing you how to make your life easy by sorting and filtering your worksheet data. For example, you'll learn how to create a formula that operates on visible cells only, master multilevel filters, and run sorts that whittle down your data to a manageable size.

Although Excel isn't a database, you can use it to find values in data lists thanks to the lookup family of formulas. Finally, I'll dig into PivotTables, the most versatile and useful Excel tool in the book, but one that's tricky for beginners and annoying for pros. You'll learn how to avoid the pitfalls when setting up your data, creating PivotTables, analyzing your data, and more.

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