Data validation rules control what type of data an end user can enter into selected cells. Such valid data can be of a specific text length, particular dates, or whole numbers. You can also create your own drop down list of choices. This feature helps maintain the integrity of the data populating your database.
You can link multiple worksheets within a workbook and you can link multiple workbooks. You can do this by writing a formula in one workbook that refers to a cell, range, or name in another worksheet tab or workbook file. The benefit of this is if the data changes in one location, all linked cells will automatically update accordingly.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.