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.
Intermediate Microsoft Excel (Morning...
Date and Time
Wednesday Sep 5, 2018
8:00 AM - 10:30 AM EDT
4 weeks on Wednesdays: September 5, 12, 19, and 26
TIME: 8:00 - 10:30 a.m.
Location
Shearer Technical Computer Consultants
727 Penn Avenue
West Reading, PA 19611
Fees/Admission
$220/person - Chamber Members;
$320/person - Not-Yet Chamber Members
Website
Contact Information
Kristen Stubblebine, Coordinator - Training & Development // 610-898-8197
Send Email