In this presentation author and Excel expert David H. Ringstrom, CPA, shows you how to harness the full power of Data Validation to guide data entry and reduce errors in your spreadsheets. David explains how to create standard drop-down lists—including lists for all twelve months and self-expanding lists based on Excel tables—as well as how to craft dependent lists that adapt based on prior selections. You’ll learn how to apply validation for whole numbers, dates, and times, along with techniques for preventing duplicate entries and limiting text length. David also demonstrates how to clarify and extend existing validation rules, apply visual cues with Warning and Information styles, and protect your rules by locking cells or identifying overrides. Throughout, you’ll gain practical strategies for working with and troubleshooting Data Validation like a pro.
Topics covered:
• Creating named tables that match dropdown choices to enable dependent list validation.
• Improving the user experience by adding input messages and custom error prompts to Data Validation drop-down lists
• Rewriting data validation input and error messages to eliminate ambiguity.
• Limiting the number of characters a user can enter in a worksheet cell.
• Adding totals and filters that automatically adjust based on which rows are visible
• Restricting users to enter times within a given time window.
• Most features and functions work in Excel for Mac as well but expect differences.
• Removing data validation from a worksheet when needed.
Learning objectives:
• Identify a valid input for a cell that has a Data Validation rule permitting decimals between 0 and 18%.
• Identify the arguments that correspond to the UNIQUE function.
• Recall the worksheet function that works best when limiting Data Validation entries to Less than Or Equal To today’s date.
Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/