ONLINE - Excel Data Validation 10/12/2022

Length/CPE Hours

CPE 3 hours

Class Time

9:00 AM – Noon Central Time
Break: 10:00 – 10:15 AM

Method of Delivery

This class will be held online using GoToMeeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoToMeeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoToMeeting subscription to participate.  

The web browser client will download automatically when you start or join your first GoToMeeting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

Course Description

The most common use for Data Validation is to create dropdown lists in a spreadsheet. In this online class you will learn how to use data validation for lists and much more, such as:

• Restrict numbers outside a specified range
• Restrict dates outside a certain time frame
• Limit the number of text characters

Data Validation

• Create a list using Data Validation
• Add items to the list
• Using Range Name with your list
• Using Tables to make the list dynamic
• Working with Delimited Lists
• Restricting numbers to specific ranges
• Restricting dates
• Restricting character limits
• Working with Error Alerts
• Copying Data Validation to other Cells

Who Should Attend

Excel users who would like to expand their knowledge and skills.

Prerequisites

Attendees need a good understanding of Excel Basics and have taken a class such as Excel for the Business Professional.

Cancellation Deadline

The cancellation deadline is 5 business days prior to the class. If you are unable to attend, you may send a substitute. If you are a "no show" or you do not send a substitute you will be charged full price for the class.

Cloud Training Services will consider emergency situations such as a death in the family, illness, and weather, and will make every attempt to work with the person in the event of an emergency.