Subscribe for NewsLetters
Email: *
First Name: *
Last Name:
Enter Captcha:*
T&E Audit Net Ad
Futr 468x60 (1)
Encoursa 468x60
C Risk Academy Banner

AuditNet® Training::Auditnet-data-analytic-auditing-training::Calendar-of-courses-data-analytic-training-with-excel

Watch the below short videos to learn more on how can maximize learning and usage of analytics with a trusty partner, Microsoft Excel. Our course calendar and how the training can be applied are explained below

Course Calendar

* - These courses are free to the first 999 registrants and are not part of the webinar pricing.

Auditnet®’s Data Analytic Auditing Series

Minutes to Analytics Using Microsoft ExcelTM

Training Course Descriptions

Paid Webinar Descriptions

1. Best Practices in Visualizing and Dashboarding Data

Visualizing data has become one of the hottest trends in analytics not only because it works to more quickly identifying anomalies but in also explaining the results to management. In this case study focused webinar, you’ll learn how to translate unwieldy files of financial data into a single compact scattergraph, pie chart, or overlay—and then to pick out the key items that merit sampling and follow-up. Once the graphs are built, using Microsoft Excel templates, approaches will be explained to build audit-specific dashboards for a particular audit or for senior management discussion.

Specific learning objectives include:

  • Understand graph types and their different analytical strengths from an audit perspective
  • Learn best practices in dahsboarding results through a review of a variety of example dashboard templates 
  • See how to quickly turn a visualization exercise into a sampling approach by sampling multiple categories to identify highest-risk items
  • Learn to improve data quality reviews through a variety of statistical techniques transformed into graphical analysis
  • Use auto-formatting and dynamic data-grabbing tools so new data can create new graphs each audit period, at the touch of a button
  • Maximize Power Pivot to efficiently visualize data in the millions of records, far beyond the limits of a normal Excel sheet

2. Enhance Audit and Fraud Sampling Productivity

Auditors have an inherent need to select samples of a population. This session will explain selection techniques of sample items which may be based on 100% testing of data tests or a statistical sample. All popular audit sample approaches will be discussed along with a discussion of when each may best be used, including: Record Samples (Random, Fixed Interval), Monetary Unit Samples, and Stratified Samples. Finally an exploration into transaction and subset scoring will be utilized to get to the best selections possible.

Specific learning objectives include:

  • Distinguish between the various types of sampling and see record, stratified and fixed-unit sampling in action
  • Be able to score records based on various audit reports to improve your effectiveness and reduce false positives in your samples
  • Discover statistics to extract the most exceptional sample units within your normal exception reports
  • Learn best practices of selecting a fraud-specific sample based on the highest mathematical likelihood
  • Visualize sample results in a variety of graphs and charts to select samples with pictures

3. Top 10 Analytic Tests to Find PCard / Travel Cost Frauds & Misuse

Travel & Entertainment ("T&E") fraud has always been an easy way for employees to pocket cash and with the proliferation of procurement cards; it has become easier than ever for merchants to get in on the action. Aside from the fraud potential, travel and entertainment spend can be reviewed for efficiencies in vendor usage or simply to curtail employee actions that can add considerable costs of misuse to the company.

Specific learning objectives include:

  • Based on past experience, learn why we selected our top 10 analytic tests to run on Pcard and travel spend 
  • Complete a who, what, when, and where set of visualizations of your travel and Pcard data
  • Put the top 10 analytics into action using Microsoft Excel template data and approaches
  • Distinguish between the top major accounting systems used when extracting travel and entertainment, travel agency and Pcard data
  • Understand the benefits of integrating and managing a continuous review of travel and PCard spend

4. Continuous Analytic Risk Management
Continuous analytic risk management (“CARM”) has been discussed for decades but implemented in select companies. In this informative webinar, the secrets of continuous reviews and risk management will be explored while outlining the analytics needed to measure financial and operational performance. From assessing risk in the audit plan to planning specific audits, continuous testing and analytic techniques will be integrated for faster decision making.

Specific learning objectives include:

  • See how analytics can maximize the annual audit plan and better ensure focus is placed on top organizational risks
  • Learn how the general ledger can provide a digital road map for analytics for fraud (and errors) within the organization
  • Highlight culturally what audit departments must do to embrace continuous reviews 
  • Define the top company areas for data integration which allows for efficient continuous testing
  • Discover the scope of using analytics across the entire audit lifecycle from risk assessment, to planning, fieldwork, and reporting.
  • Walkthrough a specific audit planning with proposed continuous audit tests 
  • Understand the basics of dahsboarding top risks and key performance indicators to maintain focus throughout the year

5. Top 10 Analytic Tests to Find Procure to Pay Frauds & Errors

Procure to payment is still the #1 area for frauds (in volume) affecting all organizations and errors are not far behind. Given the random nature of the area in the types and size of payments, the need for “rush” activity and the nature of human errors, P2P continues to lead the pack in risk of failure. However, with performance measure analytics placed in key process points, the exposure risk can be minimized while developing an aura of fraud and error deterrence.

Specific learning objectives include:

  • Based on past experience, learn why we selected our top 10 analytic tests to run on the procure to payment process
  • Discover the top frauds and corruption schemes along with top cost efficiencies to enact within accounts payable reviews 
  • Complete a who, what, when, and where set of visualizations of your procure to payment data
  • Put the top 10 analytics into action using Microsoft Excel template data and approaches
  • Distinguish between the top major accounting systems used when extracting associated data
  • Understand the benefits of integrating and managing a continuous review of payment spend

6. Maximize Everything With Excel Pivot Tables

This course title says it all as we will start simply by exploring each option in the Microsoft Excel Pivot Table Tools and then move to more advanced Power Query and Power Pivot topics. We hope to quell any concerns in your development and use of Pivot Tables while also showing you some new tricks to enhance your audits. Please note that Excel 2010 or greater is required for this webinar to make use of the Power Pivot/Query functionality.

Specific learning objectives include:

  • Create basic PivotTables using a variety of provided data templates
  • Be able to make use of Excel’s entire array of Pivot Table Tools
  • See how to complete specific audit tests in a variety of areas using Pivot Tables
  • Learn how to obtain an entire data set for a Pivot Table that dynamically recalculates itself as you add data
  • Understand when and how to make use of Power Query and Power Pivot to extend your analysis beyond the million-row limit of Excel

7. Utilize Big Data Analytics Now

Big Data is the big talk these days as computing power and the “Internet of Everything” has advanced dramatically over the last decade. In this informative webinar, we will discuss how to obtain and import data from a variety of internal and external free sources to improve their audits and help departments take those first steps towards the Big Data Revolution.

Specific learning objectives include:
  • Understand how to maximize your own internal data before looking for external sources
  • Review some of the top Big Data sources being utilized by finance professionals today
  • Discover a world of free information on business partners and research the company in a sample case study format, using no more than an Internet browser.
  • Combine structured accounting data analysis with unstructured textual analysis of words, combination of words, and emotive tones.

Free Webinar Descriptions

Free #1 - Turning Analytics From “Nice to Have” to “Must Have”

Analytics should turn manual tests from a $1.00 to a $.01 in that they can be run regularly, fast and without much effort. Companies owe it to themselves to establish and optimize a set of analytics yet time after time, have difficulty enabling these effective tools. In this webinar, we will explain some of the most common obstacles hindering analytics while providing simple best practices to move departments forward in 2016.

Specific learning objectives include:
  • Review results from a variety of online and in-person surveys focused on analytics over the past decade
  • Extract for presentation analytic best practices being deployed by top performing organizations
  • Explain the need for an effective culture around the analytics program to bolster the technology implementation
  • Discuss the varying types of technology alternatives, outlining their relative strengths and place at the analytics table

Free #2 - Moving Periodic Analytics to Continuous Tests

Spot analytics applied in specific situations throughout the year can be effective but are limited in relation to the continuous application of analytics across all audits. In this informative webinar, we will outline the steps to turning periodic tests to continuous reviews, while explaining the benefits of consistent application of analytics on a business process.

Specific learning objectives include:

  • Take two sample audit areas, define the periodic tests generally performed and then explain the approach to making the higher risk areas more continuous 
  • Learn to identify opportunities for automating testing procedures and more specifically:
  • Automating user access control reviews.
  • Gaining comfort with the entire population using a variety of audit areas as examples.
  • Testing specific system input, processing and output controls in a variety of audit areas. 
  • See how to quickly gather report ideas and techniques for analysis, as well as, obtain a list of some of the top fraud tests by process area
  • Prioritize the top red flags of financial statement fraud and misappropriation, based on research culled from recent surveys and how to continuously assess them throughout the year
  • Explore data quality tests from statistical numeric to unstructured textual analytic approaches

Free #3 - Fast Track to Learning ACL Software

This course will provide the key learning blocks to get started quickly with using ACL Software while highlighting over 20 hours of additional learning modules to advance any user of the product. From a simple review of data to scripting in ACL, this webinar will act as a primer for learning every aspect of this analytics application.

Specific learning objectives include:

  • Define Fixed Field, Variable Length, Excel, Delimited, Report Files, and more in ACL. 
  • Maximize the key commands in the Data and Analyze menu options in ACL
  • See how to use the JOIN function including many to many JOINs using key words
  • Understand the value of automating data work and how ACL scripts can be your link to continuous monitoring
  • Learn to build an ACL script in two minutes (with no prior experience) and the various approaches to writing scripts 
  • Be directed to over 20 hours of complimentary additional learning tools to advance your ACL knowledge at your own pace

Free #4 - Perpetual Cash Generating Analytics

Regardless of any budget, cost saving analytics, cost recovery and revenue enhancement initiatives can be incorporated into any organizational plan. Companies owe it to themselves to establish and optimize a set of value producing analytics for the coming year ... before they disappear.

Specific learning objectives include:
  • Recognize opportunities to working with external audit in order to reduce manual testing and in return, apply 100% analytic testing.
  • Learn about instances when analytic cost-cutting reviews can also become effective fraud fighters. Be able to tailor a plan for cost savings in the coming year, with no cash budget required, using a variety of easy-to-implement cost recovery / saving initiatives.
  • Recognize how cost recovery can support any Sarbanes-Oxley or other control testing plan, supplementing your existing staff at no cost.
  • Discover approaches to automating such testing in a regular fashion using a data mart and a suite of automated tests.

Following applies to the complimentary Webinars only. Access the live Webinars for free. If you are an AuditNet Registered Paid Current Subscriber or if you sign up for an Individual or Group Package you can attend the 4 additional Webinars at no cost and receive 2 CPE for each Webinar attended. You must be an AuditNet Current Registered Paid Subscriber or Package Purchaser to receive CPE for these free events.

  • CPE: 2 Credits for AuditNet Current Registered/Paid Subscribers or Individual or Group Package Purchasers*
  • Program Level / Prerequisites and Advance Preparation: Basic / None
  • Delivery Method: Group Internet Based
  • Category: Specialized Knowledge and Applications
  • Cost: $0
  • Access live Webinars for free only AuditNet Current Registered/Paid Subscribers or 2016 Individual or Group Package attendees will receive CPE credit

*Eligibility for free CPE is subject to change