06/23/2018 | 09:30AM - 11:30AM
Computer Training Center
Computer
Technology Training
Microsoft Excel IV
Learn how to create and customize PivotTables which can be used to summarize, analyze, explore, and compare data such as sales figures. Learn how to use the Vlookup function to find information in a data range such as looking up a price by part number. Also learn how to use the payment (PMT) function to calculate loan amounts such as on an amortization schedule. Other topics include protecting cells/worksheets that contain secure data, defining data as a table, and entering data using forms and drop-down lists. Also includes a bonus exercise: creating floorplans.
Prerequisites:
Excel III or equivalent computer experience (see course descriptions).
Fees:
- LMxAC Cardholders -- $10 per class.
- Non-LMxAC cardholders -- $15.00 per class.
Cancellation Policy:
Fees for computer class registrations are NOT refundable or transferable; please be aware that you are making a commitment to attend a class when you register. Should you not attend, the Library would ask that you think of this as a small donation for all the hours that are put in to running the classes.
If circumstances dictate that the library must cancel a class, registration fees for enrolled students are refundable.
If you cannot attend
If you cannot attend a class for which you have registered, the Library would ask that (as a courtesy to other registrants who may be waitlisted for that class) you call 732-390-6767 to cancel your registration or cancel your registration online so that others might have the opportunity to attend.
Registration Requirements:
Payment should be made online at the time of registration. If issues arise with online payment, cash payments can be made at the BRC Desk (across from the training lab). Register early to ensure a spot in a class.
Waitlisted registrants
Waitlisted registrants will be notified by email and/or telephone as soon as there is a vacancy in a class. They will have 24 hours to respond to the notification. If they do not respond within that time frame, the next person on the waiting list will be notified. Once a commitment to attend has been made, that registration is subject to the same cancellation policy noted above. Waitlisted registrants do not pay unless there is a cancellation and they are officially admitted to the class.
Please call the Information Desk at 732-390-6767 for more information.
