Accudemia: How do I add subtotals to Accudemia reports in Excel?

Accudemia: How do I add subtotals to Accudemia reports in Excel?

Introduction

Accudemia offers access to several different kinds of reports and some of them can be enhanced with Microsoft Excel. This article will explain how to add subtotal to these reports to make their results more easily readable.

Step-By-Step

1. Select "Reports" on the home page, then choose the needed report from the list.

This article is using the "Attendance by Tutor" report as an example.

2. Create the report and select either "XML" or "CSV File (Unformatted Excel File)" as the output.

3. Open the report in MS Excel

4. Select the entire table (including the headings), then navigate to Data > Outline > Subtotal.

5. Select "Services" under "At each change in," then enable "Services," "Replace current subtotals" and "Summary below data" before clicking OK.

Now the report should include subtotals.

The subtotal pictured above are located in cells I 13 to J 14.