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 |