Advanced Excel - January 2023

  • Share:
Name: Advanced Excel - January 2023
Date: January 6, 2023
Time: 8:00 AM - 10:30 AM EST
Website: http://GreaterReading.org
Registration: Register Now
Event Description:
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



 
Location:
Shearer Technical
727 Penn Ave.
West Reading, PA 19611
Date/Time Information:
Four weeks on Fridays: January 6, 13, 20, 27
Time: 8 a.m. - 10:30 a.m.
Contact Information:
Mark Dolinski
Send an Email
Fees/Admission:
$300/person - Chamber Members;
$375/person - Not-Yet Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha