data validation

Data Validation for Specified Text only

If you want to check if the values that contain a specified text string in one cell, you can use a combination of the FIND function and ISNUMBER function as a formula in the Data Validation. Data Validation for Specified Text only ​Suppose that you want to check that if the values in column B… read more »

Excel Basics

 MS Excel Basics This section will introduce the basics of Excel, such as: Excel Window, Ribbon, Workbook, Worksheet, Cells, Templates, Data Validation, print ..etc. 1. Excel window when you start the excel application, excel window will appear and this section will let you learn the various important parts of excel window. 2. Excel Ribbon The… read more »