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.

Cancelation Policy

Fees for computer class registrations are NOT refundable; However, 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.

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 cancelation policy noted above. Waitlisted registrants do not pay unless there is a cancelation and they are officially admitted to the class.

Please call the Information Desk at 732-390-6767 for more information.

Contact the Trainers