Program Objective:
Participants will 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
Thursday Apr 11, 2024
8:00 AM - 10:30 AM EDT
Four weeks on Thursdays: April 11, 18, 25, and May 2
Time: 8 a.m. - 10:30 a.m.
Shearer Technical
727 Penn Ave.
West Reading, PA 19611
$300/person - Chamber Members;
$375/person - Not-Yet Chamber Members
Mark Dolinski
Send Email