Program Objective: Participants will study and learn the most rewarding features of Excel. Please note the term “Advanced” does not refer to a high level of difficulty, but just a continuation of the Intermediate class. This is truly the “cool” class, as you get to see a lot of neat things you can do in Excel!
Course Outline:
- Everything you can do in Pivot Tables
- Consolidating Workbooks
- Creating a Shared Workspace
- Creating a Saved Workspace
- Data Validation in Range Names
- Remove Duplicate Records
- Outlining the Spreadsheet
- Working with Advanced Macros
- Using the Text to Columns command
- Protecting Cells that contain formulas
- Creating a Pareto Chart
- Creating a Histogram
- Advanced Goal Seek
- Working with V Lookup functions
Prerequisite: Intermediate Excel training and a good working knowledge of the computer.
Date and Time
Thursday Sep 6, 2018
8:00 AM - 10:30 AM EDT
Four weeks on Thursdays: September 6, 13, 20 and 27
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