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:
• 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
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.
Advanced Excel
Date and Time
Friday Sep 17, 2021
8:00 AM - 10:30 AM EDT
Four weeks on Fridays: Sept. 17, 24, Oct. 1 and 8
8 a.m. - 10:30 a.m.
Location
Shearer Technical: 727 Penn Ave, 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, 610-898-8386
Send Email