|Microsoft Excel Intermediate Class (online)|
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.
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.
Registration Ends: 9/18/2020 at 4:30 PM
This event is free and open to the public and will be held online via Zoom. Reservations are required to receive an invitation to the class.Contact: Mark Pinto
Contact Number: 610-933-3013 x132
Presenter: Paul Celentano