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.

01 - Introduction

01 - Welcome

02 - Using the exercise files

02 - 1. Controlling the Limits of Numeric Data

01 - Whole number vs decimal limitations

02 - Using the Input Message box

03 - Using the Error Alert tab

03 - 2. Setting Up Drop-Down Lists

01 - Creating drop-down lists

02 - List location and order

03 - Multitiered lists

04 - 3. Date Controls

01 - Date limitations with basic controls

02 - Date limitations using formulas

05 - 4. Time Controls

01 - Time limitations with basic controls

02 - Time limitations using formulas

06 - 5. Text Length Controls

01 - Text length limitations with basic controls

02 - Text length limitations using formulas

07 - 6. Specialized Custom Formula Controls

01 - Requiring entries to be unique

02 - Locating cells with data validation rules

03 - Identifying cells that violate data validation rules

04 - Data validation shortcomings

08 - Conclusion

01 - Goodbye

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)