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.
- Log into your new charity backoffice and download your list of Alvarum pages
- Open the .xls file with Microsoft Excel
- Click on the tab "Data"
- 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
- Click on the dropdown symbol in the column "Event"
- Click on "Select all" (Sélectionner tout) to unmark all events
- Check the events for which you want to make a list
- Go back to the table
- Mark the displayed data (CTRL+A) and copy it (CTRL+C)
- Create a new table
- Paste the values in the new table (CTRL+V)
- Save the file
Make a list of fundraisers created in a specific month
- Click on the dropdown symbol in the column "Creation date"
- Click on "Select all" (Sélectionner tout) to unmark all dates
- Check the years, months or days for which you want to make a list
- Go back to the table
- Mark the displayed data (CTRL+A) and copy it (CTRL+C)
- Create a new table
- Paste the values in the new table (CTRL+V)
- Save the file
Aggregate data
You can aggregate the data in your file using a pivot table.
- Log into your new charity backoffice and download your list of Alvarum pages
- Open the .xls file with Microsoft Excel
- Mark all the data (CTRL+A)
- Click on the tab Insert
- Click on the filter symbol "Pivot table"
- 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
- Click, hold and move the field "Event" to the box "Column labels"
- Click, hold and move the filed "Creation date" to the box "Values"
Result: Nb. of pages created on an event
- 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.
- 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