Overview:
Have you ever received a spreadsheet where users entered a date in a phone number column? Or maybe they entered an employee's birthdate with the current year? Or did then misspell a state abbreviation? Did you know you can prevent these errors using Excel's Data Validation feature. That is what this course is all about.
Whether you are a new Excel user, a data analyst, spreadsheet guru, business professional, or simply someone looking to create more user-friendly Excel files, this course will provide you with the knowledge and tools you need to validate the data and make the spreadsheet more user friendly.
Areas Covered in the Session:
- What is Data Validation?
- What are the benefits of using Data Validation?
- How can I insist that a user enter a whole numbers, decimals, dates, times?
- How can I set up rules such as no negative numbers, or no future dates?
- How can I display and restrict inputs to values in a dropdown menu?
- How can I create a dependent drop down (e.g. Category ? Subcategory)
- How can I reject malformed phone numbers, SSN, and zip codes?
- How can I set up a rule based on a formula?
- How can I display an input prompt so users know what to enter?
- How can I display a friendly message when a user enters invalid data?
- How can I mark data that is invalid?
Who Will Benefit:
- Office Workers
- Administrators
- Data Analysts
- Managers of All Levels
- Business Owners
- CEO's
- CFO's
- CTO's
- Salespeople
- Trainers
- Bankers
- Anybody who needs to enhance their spreadsheets to collect more accurate data