Question: -
How to add Symbols in Excel?
Answer: -
1. Go to the Insert tab > Symbols group and click Symbol.
2. In the Symbol dialog box, on the Symbols tab, click the drop-down arrow next to the Font box, and select Wingdings.
3. A couple of checkmark and cross symbols can be found at the bottom of the list.
4. Select the symbol of your choosing and click Insert.

To open Symbol option

Number of Symbols

Question: -
Shortcut key to add Symbols in Excel.
Answer: -
Alt + N + ZS + U

Dear Friends,

*Wish you a very Happy New Year 2021*

May the New Year Bring *Joy* , *Peace* , and *Happiness* to You and Your Entire family

Question: - How to Remove Duplicates from Data in Excel?
Answer: - Please follow the below steps to understand the process:-
1. Click any single cell inside the data set.
2. On the Data tab, in the Data Tools group, click Remove Duplicates (Yellow Highlighted).

Data > Data Tools > Remove Duplicates (Yellow Highlighted)

3. Leave all check boxes checked and click OK.

This Pop up ask you from which column you want to remove duplicates.

Result. Excel removes all identical rows (blue) except for the first identical row found (yellow).

Dear Friends,
I am requesting you to please suggest if you need any further help from my side and suggest something to improve the participation in channel. Please try to share this channel with your friends and family members so that they can also get the benefit of this free service.
Thanks, and regards.

Dear Sneha,
I will try to conduct virtual class for doubts and upcoming topics.
My request to all please increase your participation in this channel so that I feel that you all are interested.
Thanks

Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you

**** Let's take a look at one more cool Excel feature that removes duplicates. You can use the Advanced Filter to extract unique rows (or unique values in a column).

1. On the Data tab, in the Sort & Filter group, click Advanced.

The Advanced Filter dialog box appears.
2. Click Copy to another location.
3. Click in the List range box and select the range A1:A17.
4. Click in the Copy to another box and select cell F1.
5. Check Unique records only.
6. Click OK.
Result. Excel removes all duplicate last names and sends the result to column F.