NitroFlare Lynda - Excel.2013: Data Validation in Depth

Discussion in 'E-Books & Tutorials' started by mitsumi, Nov 20, 2015.

  1. mitsumi

    mitsumi Active Member

    Joined:
    Jun 8, 2012
    Messages:
    3,538
    Likes Received:
    5
    Trophy Points:
    38
    [​IMG]
    Lynda - Excel 2013: Data Validation in Depth
    MP4 | Video: 1280x720 | 128 kbps | 44 KHz | Duration: 1h 5m | 147 MB
    Genre: eLearning | Language: English


    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.
    Topics include:

    Testing for whole numbers and decimals
    Using the input message box
    Sequencing and placing lists
    Creating multitiered lists
    Setting date and time limitations
    Limiting text length
    Locating data validation rules
    Requiring entries to be unique


    [​IMG]


    [​IMG]

    Code:
    
    
    
    
    http://www.nitroflare.com/view/E428E324969120F/ynn7k.Lynda..Excel.2013.Data.Validation.in.Depth.part1.rar
    http://www.nitroflare.com/view/7F85EC4630029C8/ynn7k.Lynda..Excel.2013.Data.Validation.in.Depth.part2.rar
    
    
    
    
     

Share This Page