Remove Duplicates in Excel

This function is use to eliminate unnecessary repetition of item on the list. Let’s take a look at the two lists of various brand of motorcycle shown in the snapshots below. Let’s highlight the Duplicate brands for better clarification. Follow the following steps highlight the duplicates: Select the cells contains the items Click Home Menu[…]

Shares 0

Formatting Data as Table in Excel

Formatting data as a table make it easier to work with and visual appealing. Below is a data set we want to format as a table. Highlight the entire cells Select the INSERT MENU Click on Table or Using the shortcut CTRL+T convert the range to table The selected range will show on the dialog[…]

Shares 0