Align or arrange objects - Microsoft Support
Aligns objects vertically through their centers. Aligns objects horizontally through their middles. Important: If the Align options are unavailable, you may only have a single item selected. Select one, or more, additional items, and then you should be able to continue.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. 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.
Video: Merge and split table cells in Word - Microsoft Support
You can merge or split table cells however you’d like, to better organize your table. For example, to make Monthly Sales the header for all of the months rather than for a single column. Select the cells you want to combine. Select Layout, and then …
Merge and unmerge cells - Microsoft Support
On the Home tab, select Merge & Center, then Merge Cells. Tips: If Merge & Center is disabled, make sure that you’re not editing a cell—and the cells you want to merge aren’t formatted as an Excel table.
Combine text from two or more cells into one cell
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. We're sorry, but something went wrong. Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of columns, or an outline of both rows and columns. 1. To display rows for a level, select the appropriate outline symbols.
Video: Merge and split table cells in Word - Microsoft Support
You can merge or split table cells however you’d like, to better organize your table. For example, to make Monthly Sales the header for all of the months rather than for a single column. Select the cells you want to combine. Select Layout, and then …
Move data from Excel to Access - Microsoft Support
Convert a table into a set of smaller tables and automatically create a primary and foreign key relationship between the tables. Add a primary key to an existing field that contains unique values, or create a new ID field that uses the AutoNumber data type.
Where are the Table Tools? - Microsoft Support
If you don't see Table Tools or PivotTable Tools on your worksheet, do this: Click any cell in the table or PivotTable. If you've selected an Excel table, you'll see the Table Tools with a Design tab. If you've selected a PivotTable, you'll see the PivotTable Tools with an Analyze and a Design tab. Need more help?
Format an Excel table - Microsoft Support
When you have a data range that is not formatted as a table, Excel will automatically convert it to a table when you select a table style. You can also change the format for an existing table by selecting a different format.