Program Objective: Participants will learn how to create more advanced charts, database functions, logical formulas, creating range names, and working with large spreadsheets more efficiently.
Course Outline:
- Various methods of selecting cells
- Creating range names
- Absolute reference
- Working with logical formulas
- Conditional formatting
- Inserting comments
- Track changes – the snitch report!
- Working & printing large spreadsheets
- Using data sort & filters
- Creating an outline
- Goal seek
- Creating scenarios
- Macros
- Creating subtotals
- Grouping spreadsheets
- Advanced linking of spreadsheets
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
Date and Time
Monday Jan 17, 2022
8:00 AM - 10:30 AM EST
Four weeks on Mondays: Jan. 17, 24, 31 and Feb. 7
TIME: 8 a.m. - 10:30 a.m.
Location
Shearer Technical Computer Consultants
727 Penn Avenue
West Reading, PA 19611
Fees/Admission
$240/person - Chamber Members;
$340/person - Not-Yet Chamber Members
Website
Contact Information
Mark Dolinski, Vice President Training and Professional Development
Send Email