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

• Summarizing Data with Pivot Tables
  • Creating First Pivot Table
  • Adding New Fields
  • Using Drill Down to see Detail Behind a Number
  • Grouping Daily Dates to Months for Year-over-Year analysis
  • Using Show Pages to Produce a Report for Every Dept in seconds
  • Changing the Default Calculation from SUM to show variance %
• Creating Random Selections
  • =RAND(), =RANDBETWEEN()
• Automatic Subtotals
  • Selecting only Subtotal Rows with Alt+'
• Fill Handle Tricks
• Joining text with &
• Charting
  • Create Chart with One Click
  • Adding New Data to a Chart
  • Creating Scatter Charts to find Outliers
  • Adding Labels to an XY Chart (Bovey Add-In)
  • Creating Bins for a Frequency Distribution Chart
• Excel 2007 Preview
  • Data Visualizations
  • Remove Duplicates
  • Mark Duplicates
  • New Filtering Options
  • Sort/Filter by Color

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 asses 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.
• Get over your fear of Pivot Tables in 10 minutes using a simple approach that will prove useful in all of your Excel usage.
• 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.

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

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

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 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.