Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Search
Media
Contact
Home

 

Webinar on how to "Develop a Risk Universe for Excel Spreadsheets" & "Using Microsoft Excel as an Audit Tool"

Training Event Brought To You By MrExcel.com and AuditSoftware.Net

Date: April 17, 2007

Time: 1:00 - 3:00 p.m. EST

CPE: 2 CPE Credit is available for attending the seminar. View additional information on CPE credits.

Course Introduction: Excel has permeated all of our business processes as it provides a flexible and simple-to-create development platform. However, the mini-systems built in Excel can be rife with errors given the lack of software methodology, poor security, and ease-of-change that comes with the Excel territory.

So how can you assess the risk of your entire Excel universe? You could manually open spreadsheets and assess them against a checklist of common list of risk symptoms. That process could take months to finish and, once done, all of the spreadsheets under review could have been changed….for the worse.

What’s needed is a methodology and set of automated solutions (provided free with the webinar) that allow you to efficiently analyze your entire Excel risk universe, in minutes. You will be left with a “Top 10 List” of risky Excel spreadsheets for deeper analysis. With this list, you will also need to understand the techniques for validating these sheets and correcting any problems. This new understanding will open your eyes to the powerful data analysis tools within Excel for the benefit of all business professionals.

Learning Objectives:

  • Learn to risk assess an entire population of Excel spreadsheets in minutes using automated tools.
  • Adopt a consistent methodology for scoring spreadsheets based on their impact and likelihood for failure.
  • Spot the top areas of risk within spreadsheets based on past case studies of failure.
  • Understand how to efficiently detect spreadsheet errors and mitigate the risk of errors in the future.
  • See how Microsoft Excel can be used as a data analysis engine for auditing spreadsheets for errors and fraud.
  • A variety of case studies will be presented with invalid Excel spreadsheets to highlight the risks and relative potential for error.
  • Gain additional Excel tips and tricks, as well as, learn about the benefits of the new version, Excel 2007.

    Cost: $75 – webinar only
    $99 – webinar and one (1) copy of Mr. Excel’s book Excel for Auditors.

    Any books ordered will be sent as soon as possible but will probably not arrive in time for the event. Please note that the books are not necessary to take part in the webinar.

    Registration : MrExcel Online Store Registration for webinar only or webinar and Excel for Auditors.

    Note: The person attending the event needs to be the name on the registration as we will process a CPE certificate for the person completing this Ecommerce form.

    • No orders will be accepted the day of the event. The last day to join this event is April 16, 2007.
    • International callers will need to use an international calling rate by calling a U.S. telephone number to access the webinar.
    • Questions regarding billing should be sent to MrExcel's Ecommerce to barb @mrexcel.com.
    • Questions regarding Web and phone systems should be sent to Accuconference at 800-989-9239.
    • Administrative questions should be sent to Cash Recovery Partners to rich @auditsoftware.net.
    • The webinar will not be archived. The slide and other webinar information will be available for download after the call and will be Emailed to participants with their individualized CPE certificate.

    Free Bonus:

    • 30-day license to ActiveData for Excel, an Excel add-in that automates many popular audit and risk assessment tests within Excel.
    • Free Excel macros to completely automate your Excel spreadsheet risk assessment process.

    Speaker Bios

    Bill Jelen is the host of MrExcel.com. He is the author of 15 books about Excel, including Learn Excel from MrExcel, Pivot Table Data Crunching, Excel 2007 Miracles Made Easy, and Special Edition Using Excel 2007.

    Rich Lanza, CPA/CITP, president of Audit Software Professionals, has a decade and a half of experience in the audit and assurance technology field and has become one of its leading authorities. Based on his years in the trenches at several Fortune 500 firms, CPA firms, and medium-sized businesses, Rich brings personalized coaching expertise in automating report systems enabling organizations to generate cash recoveries, stop profit leaks, resolve control issues, and implement process improvements. He is a frequent and popular speaker and a prolific writer.




    MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

    MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

     

  • Excel is a registered trademark of the Microsoft® Corporation.
    MrExcel is a registered trademark of Tickling Keys, Inc.

    All contents Copyright 1998-2008 by MrExcel Consulting.