->
Lynda - Excel 2016: Data Validation in Depth - 490802
Lynda - Excel 2016: Data Validation in Depth
With Excel's data validation tools, you can control how users enter data into workbooks, ensuring that data is consistent and accurate. You can control dates, 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 2016 can be used to set dropdown lists and control numeric, text, date, and time entries.


Table of Contents

  • Introduction
  • 1. Controlling the Limits of Numeric Data
  • 2. Setting Up Drop-Down Lists
  • 3. Date Controls
  • 4. Time Controls
  • 5. Text Length Controls
  • 6. Specialized Custom Formula Controls
  • Conclusion
  • Lynda - Excel 2016: Data Validation in Depth


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss