How to calculate age in Excel?

To delete blank rows in excel you should:

• Select your data.
• Go to Home, select Go to Special.
• Choose Blanks and click OK.
• Go to Home, click Delete, then click Delete Sheet Rows.

To make pie charts in Excel you should:

• Prepare your data.
• Select the data and Go to the Insert tab.
• Choose a Pie Chart and select a chart type.
• View your chart.
• Customize your chart, add percentages & labels, change colors & styles.

To convert capital letters to small letters in Excel you should:

• Add a new column next to the existing column of capital letters.
• In the first cell of the new column, type the formula: =LOWER(A1).
• Replace A1 with the actual cell reference containing capital letters.
• Apply to other cells, drag the small square at the bottom-right of the cell down to apply the formula to the rest of the column.

To find duplicates in Excel you should:

• Select your data.
• On the Home tab, click the Conditional Formatting.
• Click Highlight Cells Rules, then click Duplicate Values.
• Select a color and click OK.

To strike out in Excel

• On Windows: Select the cell or text and press the keyboard shortcut Ctrl + 5.
• On Mac: Select the cell or text and press the keyboard shortcut Command + Shift + X.