HRTrainingCenter.com provides Human Resource training on FMLA, COBRA, HIPAA, HRAs (Health Reimbursement Accounts), HSAs (Health Savings Accounts), FLSA, Payroll, Cafeteria Plans, and more through seminars, online training, webcasts, webinars, and audio conferences. Best sellers include FMLA seminars, COBRA seminars, online payroll training, retirement plan training, and HIPAA training.
Course/Product Description
Title:

Excel Training: How To Use Internal Control Features

SKU:WT-1002875
Format: Webinar
Description:

Excel Training: How To Use Internal Control Features

Excel’s “Internal Controls” function provides various ways to control your actions within an Excel spreadsheet, including how to protect worksheets and workbooks from unauthorized changes. It also can help financial model owners to monitor the use of the spreadsheet, identify unauthorized use of the model, and help minimize maintenance when changes are required.

In this educational webcast, Excel expert David Ringstrom, CPA, shows you how to implement internal control features within your Excel spreadsheets. David uses a simple invoice form as a teaching aid to demonstrate various ways to control users’ actions within an Excel spreadsheet as well as to protect worksheets and workbooks from unauthorized changes.

David’s courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. His detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session.

Learning Objectives

By attending this training session, you will learn how to:

  • Use look-up formulas to look up data automatically from lists
  • Apply lookup formulas to gather data automatically from lists
  • Identify how to use Excel’s Table feature to future-proof elements in your spreadsheets
  • Use Excel’s Data Validation feature to restrict data entry to a list of permissible choices
  • Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
  • Create an in-cell list by way of Excel’s Data Validation feature
  • Future-proof VLOOKUP by using Excel’s Table feature versus referencing static ranges
  • Go behind the scenes in a workbook to check for worksheets that can’t be viewed or hidden from Excel’s primary user interface
  • Improve the integrity of your spreadsheets with Excel’s VLOOKUP function
  • Learn how to arrange two worksheets from within the same workbook on-screen and at the same time
  • Make it harder for a user to circumvent data validation and easy for you to identify when someone has attempted to do so
  • Minimize ongoing spreadsheet maintenance with Excel’s Table feature
  • Preserve key formulas using the Hide and Protect features
  • Restrict users to entering dates within a given range, or before/after a given date
  • Specify a range of whole numbers that a user can enter in a worksheet cell
  • Toggle the Locked status of a worksheet cell on or off by way of a custom shortcut
  • Use Conditional Formatting to identify unlocked cells into which data can be entered
  • Use the SUMIF function to summarize data based on a single criterion
About Your Speaker:

David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.


Other Excel Topics

This course is just one of several Excel training courses we offer as part of our Excel training line. Go to www.CPATrainingCenter.com/Excel-Training-For-Accountants.asp to see the full list of Excel training courses.

About The Provider: The Industry Calendar creates and sells webinars, audio conferences, and seminars for busy business professionals.

We've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily view and register for upcoming events. Simply click on a course title or search by specific industry to get started!
Price: $239.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Webcast
Course TitleDatePrice
Excel Training: How To Use Internal Control FeaturesCD/On-Demand$239.00

Reasonable Accommodation - Impairment
Reasonable Accommodation - Impairment

Garnishments, Child Support Orders and Other Levies
Garnishments, Child Support Orders and Other Levies

Internal Investigations Certificate Program
Internal Investigations Certificate Program

How To Write Clear, Concise, And Compliant Job Descriptions
How To Write Clear, Concise, And Compliant Job Descriptions

How To Drive HR Strategy
How To Drive HR Strategy

How To Get Your Managers To Cooperate With HR
How To Get Your Managers To Cooperate With HR

Background Checks And Safe Hiring: Trends, Legal Developments, And Best Practices
Background Checks And Safe Hiring: Trends, Legal Developments, And Best Practices

Personnel Records: What To Keep, What To Toss
Personnel Records: What To Keep, What To Toss

Creative - And Free - Ways To Use LinkedIn As A Recruiting Tool
Creative - And Free - Ways To Use LinkedIn As A Recruiting Tool

Certificate Program For HR Generalists
Certificate Program For HR Generalists

HR′s Guide To Medical Marijuana In The Workplace
HR′s Guide To Medical Marijuana In The Workplace

How To Properly Complete A Form I-9
How To Properly Complete A Form I-9

Basics Of OSHA Recordkeeping
Basics Of OSHA Recordkeeping

Certificate Program In FMLA &ADA Compliance
Certificate Program In FMLA &ADA Compliance

IRS Rules For Travel Pay
IRS Rules For Travel Pay

IRS Rules For Work Visas
IRS Rules For Work Visas

Google+HRTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-1219 | support@HRTrainingCenter.com
Copyright HRTrainingCenter.com 2016 | Web Site Development by OTAU
Facebook