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

You need to register for the webinar to watch the video.

Click Here to Register

Before starting this self study program, please go through the instructional document.

Overview

  • Control the upper and lower limits of columns containing numeric entries, like salaries, sales, items, etc.
    2 mins
  • Use the Input Message and Error alert options to provide guidance on data entries
    12 mins
  • Keep the entries in a date column within a certain range; or limit either the starting or ending date.
    23 mins
  • Learning Data Validation
    28 mins
  • Control the length of entries; or that entries be text; or that entries be numeric
    39 mins

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.


Click to access more webinars on Excel CPE Courses | Free Ethics Webinars

Learning Objectives

  • Control the upper and lower limits of columns containing numeric entries, like salaries, sales, items, etc.
  • Use the Input Message and Error alert options to provide guidance on data entries
  • Keep the entries in a date column within a certain range; or limit either the starting or ending date.
  • Keep the entries in a time column within a certain range; or limit either the starting or ending time.
  • 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