Attendance Roster Instructions Excel 2007

Attendance Roster Instructions Excel 2007

Obtaining Attendance Rosters from WebAdvisor is a 2 step process:

1  Download and save the Attendance Roster spreadsheet from Forms Depot (attendance-roster.xls). (This only needs to be done once if you plan to use the same computer for your roster downloads).

2  From WebAdvisor select the Class and the Roster Type from your Class Roster section. You will be asked to confirm your email address. Once this has been done the roster data will be emailed to you in a .txt format. You will save this class roster data to your computer.

Follow the instructions below

1.  Right click the email attachment class roster.txt, and then select Save As.

2.  Save the file in an area of your choice and provide a name. Click Save.

3.  Open attendance-roster.xls in Excel.

4.  If Excel gives you a Security Warning like the one below, click Options.
Select Enable this content, and then click OK.

5.  To update the Attendance Roster with the current data file, click the Import button at the upper right corner of the roster spreadsheet.

6.  You will be prompted to select the file to import.

7.  The Attendance Roster may now be saved and printed.