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

Part II: Managing Data Inside Excel > Excel's Data Management Features

Chapter 2. Excel's Data Management Features

IN THIS CHAPTER

Using the Worksheet Functions: An Overview

Locating Data with OFFSET

Finding Data with INDEX

Finding Data with MATCH

Using MATCH with Other Functions

Using VLOOKUP

Rearranging Data with TRANSPOSE

Getting Data from a Pivot Table: GETPIVOTDATA

Looking Ahead


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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