CPATrainingCenter.com offers CPA exams, accounting degree training, CPE, and professional development for accountants and CPAs
Course/Product Description
Title:

Detecting Errors in Microsoft® Excel® Worksheets

SKU:WC-1014806
Date / Time: Recorded
Format: Webinar
Order:Qty: Select State:
Description:

It is critical that workbooks are internally consistent, with numbers that tie out and data that flows properly throughout. When you prepare workbooks, it is your responsibility. Building a solid error check worksheet requires several Excel® features and functions, including Boolean values, comparison formulas, the logical AND function, and conditional formatting.

When reviewing unfamiliar workbooks, there are several Excel® features and functions that can assist. For example, formula auditing, trace precedents, formula evaluation, view formulas, and the function wizard. Additionally, when comparing two versions of a file, such as the version you have on your network and a version your client has returned with changes, the Excel® 2013 Inquire Add-In is wonderful.

All of these items will be covered in detail during the live webinar, and sample Excel® files are available for download so that you can work along during the session or reference them after the session: www.excel-university.com/lorman.

This webinar will utilize GoToWebinar®, an internet active tool which allows the speaker to walk through examples in real time. This will be the best way to follow along with the program and a link will be provided for you prior to the program date.

Agenda

Auditing an Excel® Workbook

  • Accuracy
  • Internal Consistency
Preparing Workbooks
  • ErrorCk Worksheet
  • Boolean Values
  • Comparison Formulas
  • Overview With Logical AND Function
  • Conditional Formatting
Reviewing Workbooks
  • Compare Files With Excel® 2013's Inquire Add-in
  • Formula Auditing
  • Trace Precedents
  • Formula Evaluation
  • View Formulas
  • Function Wizard
About The Presenter

Jeff Lenning, , CPA, CITP
  • President of Click Consulting, Inc.
  • Wrote, Excel® University: Microsoft® Excel® Training for CPAs and Accounting Professionals
  • Recipient of California CPA’s 2013 Award for Instructor Excellence
  • Excel® articles featured in the Journal of Accountancy and other industry publications
  • Member and instructor for AICPA and CalCPA


Cannot Attend The Live Presentation?

This presentation is also available in a recorded format, in CD version, as shown in the pricing options below.

About Webcasts / Audio Conferences / Podcasts:

Webcasts, audio conferences, and podcasts are presentations that you attend via the Internet, phone, or mobile device at a specified date and time for "live" versions, or at your convenience for "recorded" and "On-Demand" versions.

The live versions are interactive, meaning that participants can ask questions in real time, plus are a very cost-effective form of training because 1) you receive fast, convenient learning without any out-of-office time; 2) you can invite as many colleagues as you'd like to listen in on a single phone line; 3) you incur no travel expenses; and 4) you and your colleagues are back at work immediately after the session ends!

And though with recorded versions you do lose the ability to ask questions, you gain the ability to hear the presentation numerous times and to share it with others in your office.

Handout materials and the phone number for live presentations are made available to you prior to the event via email from the presenter and from the "MyAccount" link on the menu bar. Copies of the presentations are included with recorded versions.

About The Provider: Lorman Education Services has provided educational seminars and online training for professionals since 1987.

Since then, we've kept thousands of professionals in the United States and internationally current on the most pressing topics in a rapidly changing marketplace of ideas. Like you, we understand the need for concise, accurate information.

That understanding underlies each Lorman course, presenting the latest information on the laws and regulations critical to your organization's successful daily operations.

Moreover, each course receives our painstaking attention to be certain both the faculty and participants receive the individual attention necessary to achieve maximum benefit from the materials.
More Info: Contact Us For More Information
Order:Qty: Select State:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Sales &Use Tax Workshop
Sales &Use Tax Workshop

Tax Court Exam Homestudy Program
Tax Court Exam Homestudy Program

Series 6 - Live &OnDemand Online Course
Series 6 - Live &OnDemand Online Course

Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing

Internal Audit School
Internal Audit School

Audit And Security For Cloud-Based Services
Audit And Security For Cloud-Based Services

Fraud Auditing Boot Camp
Fraud Auditing Boot Camp

Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors

1040 Training
1040 Training

Forensic Certified Public Accountant Designation
Forensic Certified Public Accountant Designation

Peachtree Seminars
Peachtree Seminars

How To Use QuickBooks
How To Use QuickBooks

Project Management Workshop
Project Management Workshop

How To Get Payroll Penalties Waived
How To Get Payroll Penalties Waived

Garnishments, Child Support Orders, And Other Levies
Garnishments, Child Support Orders, And Other Levies

Certified Payroll Administrator
Certified Payroll Administrator

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