TeamMate Analytics has been designed from the ground up to be a tool for every auditor on an audit team, regardless of their IT skill level. With no coding required to run TeamMate Analytics, auditors can spend more time doing what they were hired to do - audit. A built-in test library and guided UI for creating custom test allow auditors to quickly run the test that they want to. Unlike many analytic tools available TeamMate Analytics was design specifically for auditors and uses familiar audit-friendly terminology.

Most importantly, TeamMate Analytics is based in Microsoft Excel. As the world's most common analytics tool, Excel is used by almost every student and professional which makes learning TeamMate Analytics second-nature. TeamMate Analytics is a fully fledged, incredibly powerful Data Analytics package with all the audit analytics capabilities found in expensive difficult to use software packages.

Computer operating system and TeamMate Analytics

TeamMate Analytics only runs with MS Excel on PC-based operating systems. TeamMate Analytics will run only on supported versions of Microsoft Excel – currently Excel 2010 and newer. TeamMate Analytics supports both 32- and 64-bit versions of MS Windows and MS Office.

Accessing TeamMate Analytics software

You can also download a Trial version of TeamMate Analytics software from this location: click here.

TeamMate Analytics and the textbook

We have prepared Student materials for the following list of exercises, chapters and cases in the textbook.

  • Exercise 1 – Chapter 11, “Data Analytics and Audit Sampling,” Case 1.
  • Exercise 2 – Chapter 11, “Data Analytics and Audit Sampling,” Case 2.

The exercises request that students review a video. However, the URL for the video provided in the textbook is incorrect. The correct URL is https://youtu.be/RU1p7FhjNDo. This URL has also been provided in the Student materials below. Further, the exercises provided on this site have been updated and we encourage you to use them.

TeamMate Analytics student materials

The Student materials are provided below, and include the following:

  • F9-TeamMate Analytics Case 11-1-Student-Final
    • Supports Exercise 1: Chapter 11, “Data Analytics and Audit Sampling,” Case 1.
    • Includes a link to the video for the exercise
    • Important – the materials included in the textbook for this exercise are incorrect. Please have the students use the materials available on the accompanying Student webpage. The Instructor version of these materials are provided below.
     
  • F9.1-TeamMate Analytics Case 11-2-Student-Final2
    • Supporting Exercise 2: Chapter 11, “Data Analytics and Audit Sampling,” Case 2.
    • Includes a link to the video for the exercise
    • Important – the materials included in the textbook for this exercise are incorrect. Please have the students use the materials available on the accompanying Student webpage. The Instructor version of these materials are provided below.
     
  • The dataset for Exercise 2 is available here.

Support for TeamMate Analytics

Support for TeamMate Analytics can be obtained by sending an email to Chris Ryley ([email protected]) or Caroline Singletary ([email protected]) with the following information: a description of what feature/function (e.g., Column Statistics, Quick Visualizer) of TeamMate Analytics the issue occurred in, details on the actions performed including the desired outcome, and details on the resulting outcome or error experienced. If the issue is critical, please phone Chris Ryley (1-800-461-5308 x6820) or Caroline Singletary (561-598-9665).