|Microsoft Excel Intermediate Class|
Event Type: Computer/Tech|
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:Library: Phoenixville Public Library
• 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.
Location: Community Education Room
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