Excel 2013 Data Validation In Depth Год выпуска: 2014 Производитель: Lynda Сайт производителя: lynda.com Автор: Dennis Taylor Продолжительность: 1:05 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: With Excel's data validation tools, you can control how users input data into workbooks and ensure data is entered consistently and accurately. You can control the dates, the times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes. Here, Dennis Taylor explores how the data validation tools in Excel 2013 can be used to set dropdown lists, and control numeric data, dates and times, and text data. Валидация данных в Экселе 2013.
Содержание
Introduction Welcome Using the exercise files 1. Controlling the Limits of Numeric Data Whole-number vs. decimal limitations Using the input message box Using the Error Alert tab 2. Setting Up Dropdown Lists (Pick Lists) Short-list and long-list variations List location and order Multitiered lists: Lists depending on lists 3. Date Controls Date limitations with basic controls Date limitations using formulas 4. Time Controls Time limitations with basic controls Time limitations using formulas 5. Text-Length Controls Text-length limitations with basic controls Text-length limitations using formulas 6. Specialized Custom Formula Controls Requiring entries to be unique Locating cells with data validation rules Identifying cells that violate data validation rules Conclusion Next steps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
