Advanced Excel

  • Share:
Name: Advanced Excel
Date: September 17, 2021
Time: 8:00 AM - 10:30 AM EDT
Registration: Register Now
Event Description:
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.
Location:
Shearer Technical: 727 Penn Ave, West Reading, PA 19611
Date/Time Information:
Four weeks on Fridays: Sept. 17, 24, Oct. 1 and 8
8 a.m. - 10:30 a.m.
Contact Information:
Mark Dolinski, Vice President Training and Professional Development, 610-898-8386
Fees/Admission:
$240/person - Chamber Members;
$340/person - Not-Yet Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha