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":





    • Related Articles

    • Accudemia: How to manipulate data from reports and export files 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 have access to the feature "Power Query" in Excel which allows creating data queries, ...

    • Accudemia: How do I create groups using reports?

      Introduction In Accudemia, there are several ways to create user groups: Using the "Create Groups" feature in certain reports. Via imports using ADX. Manually going through the Administration > User Groups module. However, this article will ...

    • AccuCampus Reports Guide

      AccuCampus Reports Guide Event Reports To get to the reports related to events, from the Main Sidebar navigate to General > Reports.  Event Registration and Attendance This report shows the registration and attendance information for a specific event ...

    • Module 14 - Reports in AccuCampus

      Module 14: Reports in AccuCampus Topic: Reports Canned Reports  Memorizing Reports Scheduling Reports Using Reports to Add/Remove Tags Using Reports to Create User Groups Ad Hoc Queries Ad Hoc Reports Reports AccuCampus offers over 30 canned reports ...

    • Accudemia: How do I use the Accudemia Data Exchange (ADX)?

      Introduction Accudemia comes with a tool called Accudemia Data Exchange (ADX). This tool imports information from CSV files into Accudemia so that widespread changes can be made faster. For example, rather than enrolling each student individually in ...