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
Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
Date and Time
Monday Feb 25, 2019
8:00 AM - 10:30 AM EST
Four weeks on Mondays: February 25, March 4, 11 and 18
8:00 - 10:30 a.m.
Location
Shearer Technical: 727 Penn Ave, West Reading, PA 19611
Fees/Admission
$220/person - Chamber Members;
$320/person - Not-Yet Chamber Members
Website
Contact Information
Kristen Stubblebine, Coordinator - Training and Development / 610-898-8197
Send Email