Change the plotting order of categories, values, or data series
Learn how to change the plotting order in charts, including 3-D charts.
XLOOKUP function - Microsoft Support
Use 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 …
Transpose (rotate) data from rows to columns or vice versa
With it, you can quickly switch data from columns to rows, or vice versa. For example, if your data looks like this, with Sales Regions in the column headings and Quarters along the left side:
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of …
Change the scale of the vertical (value) axis in a chart
By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to …
Change how rows and columns of data are plotted in a chart
To reverse the order in which the categories or values are plotted along the axes, see Change the plotting order of categories, values, or data series.
Undo, redo, or repeat an action - Microsoft Support
To redo something you've undone, press Ctrl+Y or F4. (If F4 doesn't seem to work, you may need to press the F-Lock key or Fn Key, then F4) on your keyboard, or select Redo on the Quick …
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
Work with a List, Record, or Table structured column (Power Query ...
To summarize, when you expand a structured column, the values are displayed alongside the other columns in Data Preview. For more information about combining primary and related …
TRANSPOSE function - Microsoft Support
Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type …
LOOKUP function - Microsoft Support
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, …