Data Validation

Create Dynamic Drop Down List

This post will guide you how to create a dynamic drop down list in Excel. How do I quickly create a dynamic drop down list in Excel. Create Dynamic Drop Down List Assuming that you want to create two drop down list in your current worksheet, and when choose a value in one drop down… read more »

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 »

Sidebar