Excel

What’s new in Excel 2024 for Windows and Mac - Microsoft Support

*Office 2016 & O365

1. On the File tab, click Options on the left.
2. Click Add-ins on the left.
3. Click the Manage down arrow and select Excel Add-ins.
   
   
   
4. Click Go.
5. In the Add-Ins available list, select Analysis ToolPak.
   
   
   
6. Click OK. The Data Analysis command appears on the Data tab.

Or follow this link Load the Analysis ToolPak in Excel - Microsoft Support

1. Click the Select All button.

2. Double-click the column boundary between two columns.

For more information, follow the link below. 

Change the column width or row height in Excel - Microsoft Support

1. Insert a new column to the right of the column that you want to split. (To insert the column, right-click the letter of the column to the right of the column that you want to split and select Insert.)
2. Select/highlight the column that you want to split.
   
   
   
3. On the Data tab, click Text to Columns.
   
   
4. Under Original data type, make sure Delimited is selected.
   
   
   
5. Click Next.
6. Select the correct delimiter for the data.
   
   
   
7. Click Next.
8. Click Finish.

Or follow the link below. 

Split text into different columns with the Convert Text to Columns Wizard - Microsoft Support

Combine text from two or more cells into one cell - Microsoft Support

1. Insert a new column to the left of the first column.
2. In the new column, click the blank cell for the first record.

3 Click Insert Function. f x

4. Under Search for a function, enter RAND.
5. Click Go.
6. Click OK 2 times.
7. Copy the formula down the column.
8. Click on a cell in the first column that contains data.
9. On the Home tab, toward the right side, click Sort & Filter and select Sort Smallest to Largest.

1. Create a column that contains the drop-down list values. (This can be on the same worksheet as the cells you want to populate or on a different worksheet within the same workbook.)
2. Select the cells that you want to populate with a drop-down list.
3. On the Data tab, toward the right, click Data Validation.
4. Click the Allow down arrow and select List.
5. Click in the Source field.
6. Select the cells that contain the drop-down list values.
7. Click OK. When you click one of cells you selected in step 2, a drop-down list should appear.

1. Select the data to which you want to apply conditional formatting.
2. On the Home tab, click Conditional Formatting, select Highlight Cells Rules, and select the desired option.
3. Specify the desired criteria and formatting.
4. Click OK.

For more details, follow the link below.

Use conditional formatting to highlight information in Excel - Microsoft Support

1. Select the data to which you want to apply conditional formatting.
2. On the Home tab, click Conditional Formatting, select Highlight Cells Rules, and select the desired option.
3. Specify the desired criteria and formatting.
4. Click OK.

For more details, follow the link below.

Use conditional formatting to highlight information in Excel - Microsoft Support