Advanced Excel PM Session - April 2024

  • Share:
Name: Advanced Excel PM Session - April 2024
Date: April 11, 2024
Time: 2:30 AM - 5:00 PM EDT
Registration: Register Now
Event Description:

It is important to note that Advanced Excel© is not a higher level of difficulty, it is just a continuation of the skills learned in the Intermediate Excel© course. This is truly the "cool" class, as you get to see a lot of neat things you can do in Excel©! Some skills that will be learned in Advanced Excel© include creating a shared workspace, consolidating workbooks, using the text to columns command, creating a histogram and much more! This course serves as a culmination of all that was learned in Intro and Intermediate 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 Thursdays: April 11, 18, 25, and May 2
Time: 2:30 p.m. - 5:00 p.m.
Please remember to bring your laptop!
 
Contact Information:
Mark Dolinski
Fees/Admission:
$300/person - GRCA Members;
$375/person - Future Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha