Highline Excel 2016 Class 10

Excel Data Validation (List, Custom & More), Comprehensive Lesson

DESCRIPTION

In this video learn about:
(00:16) Introduction
(00:46) Data Validation to allow only whole numbers between an upper and lower limit
(02:12) Create an Input Message for your Data Validation
(02:31) Error Message with “Stop”
(02:53) Circle Invalid Data
(04:12) Copy and Paste To Wreck Data Validation
(04:42) Data Validation to allow only decimal numbers below or equal to an upper limit
(05:10) Error Message with “Warning”
(06:26) Error Message with “Information”
(07:30) Data Validation drop down list using a range of cells
(08:14) Data Validation drop down list using a Defined Name
(08:14) Ctrl + Shift + F3 = Create Names From Selection for a single column
(08:52) Data Validation drop down list using a Dynamic Table Name
(09:50) INDIRECT Function trick for Table Name. INDIRECT function takes text that represents a reference and converts it back to a
(12:43) Data Validation List when you type text in source dialog box
(13:21) Create a Dependent Data Validation List based on a second Data Validation Dropdown List
(14:14) Ctrl + Shift + F3 = Create Names From Selection for a multiple columns column
(15:19) INDIRECT Function trick for Dependent Data Validation: to take text that represents a reference and convert it to a reference
(16:40) Data Validation to allow only dates between an upper and lower limit
(17:28) Data Validation to allow only times above or equal to a lower limit
(18:08) Data Validation to allow a certain text length
(18:40) Custom Data Validation Logical Formula to allow only prices that are less than or equal to double the cost
(20:21) Custom Data Validation Logical Formula to prevent duplicates
(23:11) Summary Comments

WORKBOOKS

Download “Highline Excel 2016 Class 10” Highline-Excel-2016-Class-10.zip – Downloaded 40 times – 420 KB







Be the first to comment

Leave a Reply