Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my free trial

Excel 2016: Data Validation in Depth

Course by: Dennis Taylor
Excel 2016: Data Validation in Depth Watch preview
  • Course details

    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.


    • Dennis Taylor

      Dennis Taylor

      Principal at Taylor Associates
      View on LinkedIn

      Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.

      Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.

      View all courses by Dennis Taylor
  • Welcome

    - [Instructor] Hi, I'm Dennis Taylor, and welcome to Excel 2016: Data Validation in Depth. If you need your data to be accurate and you want to enter it quickly, then this is the right course for you. I'll show you how to limit the types of numbers you can enter, how to set up error and warning messages, and how to set up dropdown lists as a way to ensure accuracy and eliminate unnecessary typing. I'll also show you methods for controlling the entry of date and time information, as well as limiting the length of text entries. These are quick and easy ways to greatly increase data accuracy. So let's get started with Excel 2016: Data Validation in Depth.

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
    Download the exercise files for this course. Get started with a free trial today.
  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents