Analysing and Sampling

Column Split How it works This function automates the process of taking a structured table in Excel, where rows represent […]

Find Rounded How it works This analytic function will identify all the transactions that are rounded to a specified degree

Batch Recon How it works This function is designed to reconcile two datasets by aligning summary data (e.g., totals in

Find Journal How it works This function allows users to find all transactions related to a specific journal reference number. 

Sequence Tester How it works This function allows users to identify missing items from sequences by having users customise the

Sampling Method: Monetary Unit How it works This sampling methodology gives us the opportunity to select a random sample, with

Posted By How it works This function generates a pivot table showing the number of transactions processed per individual. How

Match Up How it works The matchup function lets you quickly compare values between data sets, e.g. opening balances, TBversioning,

Find White Text How it works The Find-white-text function can identify any areas of you workbook where white text has