Accudemia: How to analyze data in reports using Excel?

Accudemia: How to analyze data in reports using 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 use the feature "Analyze data" in Excel.

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, select all data(including the headings), then navigate to Home > Analyze Data

As you can see in this example automatically you have access to responses and visuals to simple questions such as (for this example). the most common tutor(the tutor with more sessions), How many distinct users there are in the report and many more, you can also formulate your own questions, for more information click F1 and search for "Analyze data":