CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.

Excel’s Data Validation Tools - keep out bad data from the start

  • CPA (CA)
  • CMA
  • CPA (US)
  • Tax Preparer
Excel’s Data Validation Tools - keep out bad data from the start

1 Credit


Subject Area

Computer Software and Applications

Webinar Qualifies For

1 CPE credit of Computer Software & Applications for all CPAs

1 CPE credit for Certified Management Accountants (CMA)

1 CPD credit (Verifiable) for Canadian CPAs

1 CE credit of Computer Technology for Maryland Tax Preparers

1 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

Course Description

Most of Excel’s data management tools focus on the handling of existing data, for example, sort, that lets you re-arrange rows of data into convenient clusters, or filter, which lets you view just the data you need to see at any given moment. But Data Validation gives you control over data that’s about to be entered into a list – keep out bad data at the start of the data creation process.


You need to make sure that salaries fall within a certain range, or that dates (or times of day) have starting and ending limits or that ID numbers have an explicit number of characters, or that certain kinds of fields can only contain entries available from a master list of set entries.


Among the strongest and most efficient validation options are the idea of a pick list - drastically reduce data entry with drop-down clickable lists – no typing (and no typing mistakes) as well as standardizing entries as you accelerate the data entry process. Users of Microsoft 365 (formerly known as Office 365) can take advantage of the UNIQUE function to build dynamic pick lists.

Although Data Validation features concentrate on controlling new data going into a worksheet, it also lets you identify data that violate new rules that you have set up on existing data.


Learning Objectives

  • To control the upper and lower limits of columns containing numeric entries, like salaries, sales, items, etc.
  • To use the Input Message and Error alert options to provide guidance on data entries
  • To keep the entries in a date column within a certain range; or limit either the starting or ending date.
  • To keep the entries in a time column within a certain range; or limit either the starting or ending time.
  • To control the length of entries; or that entries be text; or that entries be numeric

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Bookkeepers & Accountants & Tax Preparers
  • Certified Management Accountant
  • Certified Valuation Analysts
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • Senior Accountant
  • Staff of Accounting Firm
  • Young CPA


    [average] => 4.0000
    [no_of_record] => 2




Great informative session.