+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

PRINTER FRIENDLY

Auditing Worksheets in Microsoft® Excel® - Webinar

  • ID: 3693280
  • Webinar
  • December 2018
  • Region: Global
  • 90 Minutes
  • Lorman Business Center, Inc.
1 of 4
Learn whats happening behind the scenes in your Excel workbook.

Excel based modeling and calculating are important components in many budgeting, reporting, and monitoring projects. Driven by ease of use, widespread adoption, and analytical power, the Excel platform has become a cornerstone of modern business analytics. However, the depth and complexity of Excel based projects often increases the probability of formulaic errors running deep behind the scenes.

In this topic, our guest speakers and Excel experts, Jaime Campbell, CPA and Shana Wild, CPA will teach you one key process and many supporting techniques that will increase the robustness of project based quality control efforts, from reviewing completed spreadsheets to using techniques which prevent those errors in the first place. This material is perfect for business owners and managers, supervisors, associates, administrative professionals, analysts, CFOs, controllers, bookkeepers, accountants and attorneys.

Learning Objectives
  • You will be able to review common Excel based mistakes.
  • You will be able to identify key analytical tools to find and fix common errors.
  • You will be able to recognize and illustrate the value of Excel based audit functions.
  • You will be able to discuss conditional formatting.
Note: Product cover images may vary from those shown
2 of 4
Error Trapping

Fences

Tables

How to Avoid Embarrassing Moments by Using Formulas to Make Sure Your Report Headers Always Match Your Report Data

How to Use the COUNTIF Function to Catch Structural Errors

How to Trace Precedents and Dependents to Quickly Follow the Flow of Formulas

How to Determine Where Exactly a Complicated Formula Kicks out an Error

The Watch Window

How to Increase Your Suavé by Hiding Your Secret Error Trapping Area
Note: Product cover images may vary from those shown
3 of 4
Jaime Campbell, CPA, MBA - Tier One Services, LLC & Shana Wild, CPA, MSPA - Tier One Services, LLC
Note: Product cover images may vary from those shown
4 of 4
This webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, controllers, bookkeepers and accountants.
Note: Product cover images may vary from those shown
Adroll
adroll