spacer
Microsoft Excel Intermediate Class (online)

Event Type: Computer/Tech
Date: 9/19/2020
Start Time: 10:00 AM
End Time: 12:00 PM
Description:
 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.

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
Registration Ends: 9/18/2020 at 4:30 PM
Other Information:
 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
Status: Closed
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.