Side | search
Click here to view Side news from 60+ newspapers.
Bookmark or Share- XLOOKUP function - Microsoft SupportUse the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
- Transpose (rotate) data from rows to columns or vice versaIf you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportIt's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
- Design the layout and format of a PivotTable - Microsoft SupportTo change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
- Show different calculations in PivotTable value fieldsTo show calculations side by side with the values they’re based on (for example, to show the % of Grand Total next to the subtotal), first you need to duplicate the value field by adding it more than once.
More
