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
Monday Nov 8, 2021
8:00 AM - 10:30 AM EST
Four weeks on Mondays: Nov. 8, 15, 22 and 29
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