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 - SOLD OUT!
Date and Time
Wednesday Jan 12, 2022
8:00 AM - 10:30 AM EST
Four weeks on Wednesdays: Jan. 12, 19, 26 and Feb. 2
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