How to use excel for reporting ?

How to use excel for reporting ?

In the section "Fundraising" of your new Charity Backoffice you can download a list of all your Alvarum pages. From this .xls file you can easily create your own data files or reportings with Microsoft Excel, LibreOffice Calc, Google Spreadsheats or any other common spreadsheet tools.​

In this article we will explain you how to use the .xls file with Microsoft Excel. The usage is similiar with other tools.


Data filters

With the help of data filters you can select and sort the data you need.

  1. Log into your new charity backoffice and download your list of Alvarum pages
  2. Open the .xls file with Microsoft Excel
  3. Click on the tab "Data"
  4. Click on the filter symbol "Filter"


You are now ready to create a custom list of your Alvarum pages.

Make a list of fundraisers created for a specific event

  1. Click on the dropdown symbol in the column "Event"
  2. Click on "Select all" (Sélectionner tout) to unmark all events
  3. Check the events for which you want to make a list
  4. Go back to the table
  5. Mark the displayed data (CTRL+A) and copy it (CTRL+C)
  6. Create a new table 
  7. Paste the values in the new table (CTRL+V)
  8. Save the file

Make a list of fundraisers created in a specific month

  1. Click on the dropdown symbol in the column "Creation date"
  2. Click on "Select all" (Sélectionner tout) to unmark all dates
  3. Check the years, months or days for which you want to make a list
  4. Go back to the table
  5. Mark the displayed data (CTRL+A) and copy it (CTRL+C)
  6. Create a new table 
  7. Paste the values in the new table (CTRL+V)
  8. Save the file


Aggregate data

You can aggregate the data in your file using a pivot table.

  1. Log into your new charity backoffice and download your list of Alvarum pages
  2. Open the .xls file with Microsoft Excel
  3. Mark all the data (CTRL+A)
  4. Click on the tab Insert
  5. Click on the filter symbol "Pivot table"
  6. Confirm the next screen


You are now ready to aggregate the data of your Alvarum pages.

Make a report on the fundraising perfomance per fundraising event

  1. Click, hold and move the field "Event" to the box "Column labels"
  2. Click, hold and move the filed "Creation date" to the box "Values"
    Result: Nb. of pages created on an event
  3. Click, hold and move the field "Amount" to the box "Values"
    Result: Overall amount raised on an event

Now you have a basic fundraising event reporting. You can refine your table even more with the following options.
 
  1. Exclude pages that did not start to raise:
Click, hold and move the field "Amount" to the box "Report filter" ("Filtre du rapport"). Now click on the new dropdown in the table to remove pages with 0€ raised from the data set.

    2.  Calculate the average amount raised:
Divide overall amount by the nb. of fundraisers

    • Related Articles

    • How to use the event recruitment links provided in my back-office ?

      In the "Events" section of your back-office, you can get all the recruitment links you need when starting a new fundraising campaign on an event. You can use these links to recruit participants to any of your events. Using the right link when ...

    • Recruit fundraisers for an event - the Challenge page

      What is a Challenge page? The Challenge page allows you to recruit fundraisers for a specific event. Like all our pages dedicated to recruitment, the Challenge page is designed to fit any device (PCs, smartphones, tablets) and allow a smooth ...

    • How to manage your admin users ?

      ​The admin users of your charity are able to manage and use several options on your account. You have access to the the list of admin users and can update information, add or delete an admin user.  You can do it from your back-office: ​ 1. Login to ...

    • Edit the list of events on my charity portal

      You can highlight any event up to 1 month after it happened. An highlighted event is visible on your charity general page and visitors can then have access to your challenge page. To change the list of events highlighted on your charity portal :   - ...