Advanced Excel - March 2023

  • Share:
Name: Advanced Excel - March 2023
Date: March 27, 2023
Time: 8:00 AM - 10:30 AM EDT
Website: http://GreaterReading.org
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 Mondays: March 27, April 3, 10, 17
Time: 8 a.m. - 10:30 a.m.
Contact Information:
Mark Dolinski
Send an Email
Fees/Admission:
$300/person - Chamber Members;
$375/person - Future Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha