How to strike off in Excel?

To calculate age in Excel you should:

• In a column enter birth dates.
• Select cells, right-click and choose “Format Cells”, then click “Date”.
• In the cell you want the age to appear, type formula =DATEDIF (A2, TODAY(), “Y”).

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.