Excel Library Lists 101: Create, Sort, AutoFilter, Subtotal, and Mail Merge (one-day workshop for library/literacy staff/volunteers)
Excel database lists can be used to track all kinds of information. Some examples include: Summer Reading program registrants, Friends of the Library lists, mailing lists, and donations.
- Best practices and rules for setting up lists
- Sorting lists
- Custom sorts
- AutoFilter queries
- Automatic subtotals
- Introduction to integration of Microsoft Word's Mail Merge feature with your Excel list
Class prerequisite: The attendees should be well-versed and comfortable using computers in general.
Kathy Blick O'Donnell, trainer and computer and app lab coordinator at ODL, will teach the class.
Travel stipend for overnight stay may be available if public library, library system, tribal library or literacy organization is 60 miles or more from ODL. Initial travel stipend paperwork must be returned to ODL before the class date. Contact Doris Dixon to request paperwork via email Doris.Dixon@libraries.ok.gov or phone (405) 522-3217. Stipend will be based on lodging receipt,up to $92. If lodging charges are less than $92, the contract will be written for the actual amount, not $92. Mileage also may be reimbursed at 30 cents/mile if you are paying for your own gas & cannot collect from your library/literacy organization. Stipend contracts will be made out to the library/literacy organization. It will be your responsibility to collect your reimbursement from such organization. No travel stipend contracts will be paid until the class has been attended and photocopied proof of overnight stay (if applicable) has been submitted to the Office of Library Development.
Have questions about Excel Library Lists 101: Create, Sort, AutoFilter, Subtotal, and Mail Merge?
Contact Oklahoma Department of Libraries