FREE Find Outliers and Anomalies in Pivot Tables Code

Now you can find outliers and anomalies in your data at the same time you build a pivot table from a data connection to an Azure SQL database, OneDrive file or Excel worksheet. This code applies the FREE Outlier and Anomaly Detection Code directly onto any pivot table that you create. There are two source code files which you can download: the first let's you build a pivot table and visualize outliers automatically from data on a worksheet; and the second file let's you build a pivot table and visualize outliers automatically from data based on an OData Feed Connection. And, you can edit the code so that you can add other Worksheet Functions that you currently can only apply on data in a Microsoft Excel worksheet. Use this outlier and anomaly detection code to find, flag, visualize, slice, and dice, outliers and anomalies in pivot tables.

The outlier and anomaly detection code applies box & whisker plot anomaly detection theory using key descriptive statistics: 75th percentile (HIGHQ), 25th percentile (LOWQ), Interquartile Range (IQR). The top (UPPER) and bottom (LOWER) box plot whiskers are calculated. Any data values greater than UPPER or less than LOWER are outliers.

You can use this code as long as you have either a Windows PC or MAC laptop, and can activate the Developer tab in Excel based on the following instructions:

Windows PC or Laptop:

1. Open a blank Excel workbook, select 'File - Options - Customize Ribbon' then check 'Developer' to add the 'Developer' tab at the top of every Excel workbook that you open from now on.

2. In the same Excel workbook, select 'File - Options - Trust Center - Trust Center Settings'  then check 'Enable VBA Macros' to tell your Excel that it can trust the code that runs.

MAC PC or Laptop:

1. Open a blank Excel workbook, select 'Excel - Preferences - Toolbar & Ribbons' then check 'Developer' to add the 'Developer' tab at the top of every Excel workbook that you open from now on.

2. In the same Excel workbook, select 'Excel - Preferences - Privacy - Trust Center Settings'  then check 'Enable VBA Macros' to tell your Excel that it can trust the code that runs.