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)
  • CPA (US)
  • CVA
  • Tax Preparer
Excel’s Data Validation Tools - keep out bad data from the start

1 Credit

$10

Subject Area

Computer Software and Applications

Webinar Qualifies For

1 CPE credit of Computer Software & Applications for all CPAs

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

Financial Intelligence for Entrepreneurs, Executives, and Directors

(1)

Oct 25, 2021 | 09:00 AM EDT View Details

Are You Ready for a Capital Campaign?

Oct 25, 2021 | 09:00 AM EDT View Details

Differences between IFRS and GAAP

(16)

Oct 25, 2021 | 09:30 AM EDT View Details

Corporate External Financial Reporting Decisions

(17)

Oct 25, 2021 | 10:00 AM EDT View Details

Everything You Need to Know About Partnerships

(13)

Oct 25, 2021 | 10:00 AM EDT View Details

Basis Calculations & Distributions For Pass-thru Entity Owners Schedule K-1 Analysis (Latest)

(122)

Oct 25, 2021 | 10:00 AM EDT View Details

Basic Concepts of Fixed Asset Accounting

(4)

Oct 25, 2021 | 10:00 AM EDT View Details

Excel Accountant: Internal Control

(6)

Oct 25, 2021 | 10:00 AM EDT View Details

Real Estate Tax Strategies: Cost Recovery, Partial Dispositions, Removal Cost, Int. Deductions, Repairs & Capital Improvements

(20)

Oct 25, 2021 | 10:00 AM EDT View Details

The Structure and Organization of the IRS

(745)

Oct 25, 2021 | 10:00 AM EDT View Details

Federal Tax Update – Individual & Business Current Developments

(12)

Oct 25, 2021 | 10:00 AM EDT View Details

IRS Form 1099 Reporting Req. including updates on FORM 1099-NEC (LATEST 2021)

(272)

Oct 25, 2021 | 10:00 AM EDT View Details

Money Laundering Risks and Countermeasures for Accountants and Other Professionals

(9)

Oct 25, 2021 | 10:30 AM EDT View Details

Quickbooks Online for Accountants Work Centre - Managing your Practice

(18)

Oct 25, 2021 | 10:30 AM EDT View Details

Business Killers – 12 Ways to Protect Your Business

Oct 25, 2021 | 10:30 AM EDT View Details

Course Description

Most of Excel’s data management tools focus on the handling of existing data, for example, sort, that let’s 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 is 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 in to a worksheet, it also lets you identify data that violates new rules that you have set up on existing data.

 

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
  • Provide an external list, on the same or different worksheet, of entries allowed within a column and provide a drop-down (pick) list of those entries – no typing, accurate entries ensured, and time saved
  • Use the UNIQUE, and possibly the SORT function, to provide a dynamic list as a source for a pick list
  • Create inter-dependent (multi-tiered) drop-down lists – selecting a state, for example, then, from a different list, only cities from that state
  • Locate all worksheet cells that have data validation rules in place; identify all cells that have the same validation rules as a specific cell
  • Encircle all worksheet cells that violate rules set up on existing data

Who Should Attend?

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

Testimonial

4

(2)
50%
0%
50%
0%
0%

TF

Great informative session.