Learn Microsoft Excel Online FreeThis post will guide you how to prevent duplicate entries in one or multiple columns in Excel. How do I use Data Validation feature to prevent duplicate values in columns in Excel. Prevent Duplicate Values If you want to prevent duplicate values when entering data into your cells or columns in Excel, you can use… read more »
This post will guide you how to limit cell entries to specific length and number of digits in Excel. How do I limit data entry to allow only text or only numbers entered into in a cell using Data Validation option in Excel. How to limit entries to numeric values in Excel. Limit Data Entry… read more »
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 »
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 »
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 »
