Admin – Group Audit Reports

There are two separate reports available to Admin users :-

Audit Groups

Groups without Training Admin as a Group Leader

Audit Users

Users who are in one or more F2F Course Group, but are not in any Organisation Group

Instructions – Creating your Reports

        • You will be taken to a Back-End routine in a new browser tab
        • Click on the button to initiate your report
        • Report creation may take a while, so it runs in the background, allowing you navigate away and do something else until it is ready.
  •  
        • When your report is ready, you will be informed by email, which will contain a clickable link
        • This will open up a CSV file in a separate browser tab
        • On your browser’s top-line menu, select File / Save As to save the CSV into your Downloads folder.
  •  
        • Next, use Excel, and select New Blank Workbook
        • Click on the Data tab, then take Get Data (Power Query)
        • Click the Text/CSV button
        • Under the Connection Settings / Select Local File, click on Browse
        • Highlight the CSV file you saved to your Downloads, and press Get Data, then Next and then Load.
  •  
        • The data will be imported into your Excel spreadsheet.
  •  
        • You may save the spreadsheet on your PC if you wish to.