Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance Seminar training classes conferences & workshops presented by AtoZ Compliance register for training on FindaSeminar.com

Home

Add your seminars

Training Calendar Creator Seminar Venues Training Provider Directory
 

New Seminar Search:  

 

Helpful links

find similar training...
Search by state...
Customer Support


Do you need help finding the right class, date, or location or other assistance?

Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request and receive a prompt reply.

We guarantee this AtoZ Compliance training seminar

We are an authorized partner of AtoZ Compliance

 

Price protection. The price to attend Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance is set by the training providerThere is no added charge for our services.

We honor most training provider coupons
*.   Call  a representative to see if your discount coupon applies.


Privacy. Your personal information won't be shared with anyone but the training provider AtoZ Compliance.


Security. When you register for this seminar on FindaSeminar.com your personal data and payment information is safely collected and processed using secure SSL encryption technology.

Flexibility. FindaSeminar.com offers you three ways to register for Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance seminar by AtoZ Compliance.
Register online, by phone (800) 349-1935,or fax (800) 712-5569
Who should attend Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance
HR/ Controllers, Payroll Professionals, Accounting and Finance Personnel, CFOs, Auditors, Managers, Admin, Anyone that builds spreadsheets for use by others
Reviews
Write and read AtoZ Compliance reviews and reviews about the training seminar Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance

 
Find Training Near You
Use our clickable map to find training near you
Use Our Clickmap
 
hotel seminars meeting space directory
hotel meeting space training facilities restaurant and lodging

 
 
 

request on site training details for the Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance seminarRequest on site training

Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance  

 Email information about this seminar Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance by AtoZ Compliance to yourself your manager or associatesEmail this event... View and register for other training seminars like Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance by AtoZ Compliance on FindaSeminar.com See similar training.. Find and register for other training seminars by AtoZ Compliance on FindaSeminar.com Other seminars from AtoZ Compliance

By:

training seminars by AtoZ Compliance AtoZ Compliance   

For:

HR/ Controllers, Payroll Professionals, Accounting and Finance Personnel, CFOs, Auditors, Managers, Admin, Anyone that builds spreadsheets for use by others

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

Get valuable assistance and guidance across industry for spreadsheet design techniques that minimize spreadsheet maintenance and improve spreadsheet integrity. (see full course description)

 
 
 

 Seminar / Training class dates & locations

 
Facility Name: 
Address:





Registration Information:

Event cost:  $
USD

class times, cancellation policy, and other information
 
 
 From 
 To 
Click to register by Register by fax for Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance training seminar Register by mail for Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance training seminar or call  (800) 349-1935

Print payment approval request form Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance training seminar

Pre-Registration questions? Find answers in our registration FAQ or Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request

 
 
 

print the agenda print agenda for the Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance seminar

 

Training Course Syllabus:


Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance

Overview

Excel expert David Ringstrom, CPA often likens Excel spreadsheets to the old West, where anything goes. Users are generally free to enter anything they like in any worksheet cell, often at the expense of data integrity. In this webinar David will show you how to use features and techniques in Excel to future-proof spreadsheets and ensure that users work within the required constraints. These techniques minimize spreadsheet maintenance, improve the user’s experience, and bolster spreadsheet integrity.

David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience.

David´s webinars are fast-paced, and even experienced. Excel users are certain to learn several new tips and tricks. David welcomes your questions and is happy to answer Excel questions unrelated to the webinar during the question and answer session.

Why Should You Attend

Spreadsheet templates are often like the Wild West where anything goes. Users are free to type anything they wish into any worksheet cell, and in many cases overwrite formulas or input invalid data. In this webinar you’ll see how to manage this risk by implementing internal control procedures that enforce proper spreadsheet usage. Data integrity checks are minimized because users cannot circumvent formulas and procedures. Ease of use is added to the spreadsheet by way of drop-down lists and internal tips.

Areas Covered In This Webinar

Understand VLOOKUP function in Excel, including argument structure and shortcuts. Look-up formulas save users from having to copy and paste data from one area of as spreadsheet to another. Instead, Excel does the work by finding requested data, such as a product ID in the first column of a supporting list and then returning related data, such as product description or price
Identify situations where VLOOKUP will return #N/A errors. If the user has not yet entered the necessary criteria or types in an entry that doesn’t appear on the list then VLOOKUP will return an error
Use Excel’s IFERROR function to make a cell appear blank instead of returning a #N/A or other error, along with an alternative that provides compatibility with Excel 2003 and earlier
Explore Excel’s Table feature and see how this simple feature makes formulas easier to audit and maintain. The Table feature adds automation to areas of spreadsheets so that named lists expand automating. This functionality ensures that look-up formulas, such as VLOOKUP, automatically pick up new additions added to the bottom of a list
Learn spreadsheet design techniques such as separating supporting lists onto separate worksheets. This prevents users from overwriting standardized data, and also ensures that making changes to worksheets don’t inadvertently cause problems with the supporting lists
Use Excel Data Validation list to restrict data entry to a list of permissible choices. The Data Validation feature can limit users to a set of choices from a list or a range of numbers, such as a quantity between 1 and 100. Such rules can prevent users from entering negative numbers in a spreadsheet or attempting to enter invalid choices
See how the Locked Cells feature can protect formulas and allow users to only affect certain cells in the spreadsheet. This feature can be tedious to implement and audit, so David will demonstrate how to create a keyboard shortcut for toggling the locked status of cells on or off, as well as using Excel’s Conditional Formatting feature to highlight which cells have been unlocked

Learning Objectives

Use look-up formulas to look up data automatically from lists
Use Excel´s Table feature to future-proof elements of your spreadsheet
Use Excel´s Data Validation feature to restrict data entry to a list of permissible choices

Who Will Benefit

This course will provide valuable assistance and guidance to all industry for spreadsheet design techniques that minimize spreadsheet maintenance and improve spreadsheet integrity. The following job titles/ positions will benefit from attending this seminar:

HR/ Controllers
Payroll Professionals
Accounting and Finance Personnel
CFOs
Auditors
Managers
Admin
Anyone that builds spreadsheets for use by others

Speakers Profile

David Ringstrom

David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David´s catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.

Seminar Summary:

Get valuable assistance and guidance across industry for spreadsheet design techniques that minimize spreadsheet maintenance and improve spreadsheet integrity. (see full course description)

print this agenda print agenda for the Enforcing Internal Control within Excel Spreadsheets - By AtoZ Compliance training seminar

 view dates and locations for this seminar

 

 
 
 AtoZ Compliance training and seminar course catalog

Click any title to view upcoming AtoZ Compliance training event dates and locations, class syllabus and other seminar details

 

     
 

 
     

 

  Also try the advanced seminar search tool

   FindaSeminar HomeComputer Training

unix training
training classes

 © 2002-2018 FindaSeminar.com™ All Rights Reserved.  Terms of Use |  Privacy Policy |  Training News Network