President's Volunteer Service Award - Manual Procedure

See also SeniorCorpsCertificationBatchForm.xls | and President's Award

Three ways to tackle the report

  1. Paste into the Certificate
  2. Build a Custom Spreadsheet
  3. Export a report to Excel

The Reporter does not have an exactly matching spreadsheet to conform to the President's Volunteer Service Award. But you can [1.] paste Reporter spreadsheet data into the Certificate. Or [2.] modify the Volunteers Spreadsheet and add in the custom data. Some people like to work from a report [3.] exported to an Excel spreadsheet.

1. Method for Presidential Award Spreadsheet - Paste from Volunteers Spreadsheet into the Certificate

If you are handy using Excel, copy, and paste, here is one method of completing the Corporation's award certificate. We have developed these instructions as a courtesy, but we do not provide Microsoft Excel program support.

Method: Prepare the Volunteers Spreadsheet and paste the appropriate columns into the Corporation's certificate. Here's how:

2. Build a Custom Spreadsheet for President's Volunteer Service Award

The Reporter does not have an exactly matching spreadsheet to conform to the President's Volunteer Service Award. But you can modify the Volunteers Spreadsheet and add in the custom data. Below are instructions for the completion of the Certificate.

3. Exporting Reports to Excel

Some people like to fill in the Corporation's certificate by referencing a spreadsheet. You can export any Reporter report to an Excel spreadsheet. The Print/Export button enables you to export the report as another file type.

To export or email, first select the export format from the drop down list.

direct to Microsoft Excel Format

Microsoft Excel — This produces a spreadsheet document that can be opened and edited in Excel. By default, only the data will be exported. The column headings will not be exported, so be sure to follow the directions below in order to label the columns once you've opened the file in Excel.

For each export type there is a properties button Export Options properties button located to the right of the drop-down list which enables you to set some (usually obscure) properties of the file type.

Excel Export Options button

Select the Output tab.

Excel Export Options - Output tab
Uncheck the "Ignore header lines" and "Ignore group lines" options for an Excel report which includes headers.

After choosing the export type, click on the Start button which opens the "Save As" screen. You must save it before you can view it as a different format. From here you can select where to save the exported file and change the default file name. In the lower left of this screen are two check boxes:

Excel Export Options - Output tab

View in Export Program

The first checkbox, "Open the file in the registered application" is normally checked and tells the Reporter to not only create the exported file, but immediately open it so that you can view it in the export program. If neither box is checked, the report opens as a Reporter report.

Revised 02/Aug/2011

Back to the Home Page.
Back to the Home Page.