MS Excel: Data Validation
It is important that the data in your cells is within the range that it needs to be. Set up basic requirements that need to be met for data to be accepted with data validation. You will require the use of a laptop with the Excel 2013 version to participate in this training (please note: Mac versions may not be fully-featured compared to PCs).
Overview
Facilitator: Andréa Grebnec, Compustep Inc.
In this workshop you can expect to learn:
- how to control the limits of numeric data;
- how to create drop-down lists;
- how to control dates and time;
- about text controls
- about specialized controls and data validation shortcomings
Light refreshments will be available.
Please register for this workshop by Tuesday, October 15th.
Any personal information you provide to McMaster University (“McMaster”) is collected, used, maintained and disclosed in accordance with the University’s Statement on Collection of Personal Information and Protection of Privacy http://www.mcmaster.ca/univsec/fippa/FIPPA_Statement.pdf. Any questions you have about the use of your personal information should be directed to Andrea Colbert-DeGeit at colbert@mcmaster.ca.