Microsoft Excel Intermediate Class

Event Type: Computer/Tech
Date: 2/29/2020
Start Time: 10:00 AM
End Time: 12:00 PM
 In this class, you will learn to modify the paper invoice from the Basic class into a workbook that functions as a self calculating invoice and to create another worksheet that functions as a sortable list while learning the following skills:
Filter and sort table data.
Use functions and formulas.
Reference cells.
Freeze panes.
Lock cells.
Conditional formatting.
Drop down menus.

Prerequisite: Basic computing and computer file management skills. Participants should bring a notebook and a USB thumb drive, and may bring their own laptop with Excel 2013 or higher installed.

Paul Celentano has created from scratch Excel spreadsheets for documentation, data sorting, and contract document specifications, as well as calculators for time sheets, electrical loads, batting averages, and trigonometric functions. He finds them particularly useful for personal purposes when making side-by-side comparisons for shopping or the cost analysis of repair projects.
Library: Phoenixville Public Library
Location: Community Education Room
Other Information:
 This event is free and open to the public. Space is limited. Reservations are required. When registering, please indicate if you are bringing a laptop.
Contact: Mark Pinto
Contact Number: 610-933-3013 x132
Presenter: Paul Celentano
Status: Waiting List
Please Note
  • Attendee MUST give 24 hour cancellation notice to allow others on the waiting list to attend.

Sorry, this event has already occurred. Please register for another event.