#Excel

Quickly compare different worksheet data and make formatting with conditional formatting using VLOOKUP compare values in another Excel worksheet.

3 Ways to quickly find duplicate values in Excel. From guide you easily find duplicate values in a large database using Microsoft…

Data Validation command is used to prevent invalid data being entered into cell. use decimal option in Data Validation in Excel.

Quickly interchange or swap data from row to column and Switch or Transpose Row And Column Data option in paste special and…

help of Data Validation Prepare Sheet Using Restrictions on Each Columns in Excel. You can make Restrictions on Columns by Data Validation.

Use tips to quickly find your current age using DATEDIF function from the birth date till current date in Excel.

If you want to count white spaces in a text string then you must read this article-How to count total White Spaces…

Use Data Validation and VLookup Function in MS Excel to create drop-down list menus by Data Validation and search any specific value.

In this article you will be able to Highlight Current Month Birthdays in Excel you can send greeting messages to congratulate staff…

Nested IF, AND, OR statements are very popular logical functions in MS Excel.. You can use Nested IF function with OR function…