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
Date and Time
Thursday Jul 11, 2024
2:30 PM - 5:00 PM EDT
Four weeks on Thursdays: July 11, 18, 25, and Aug. 1
Time: 2:30 p.m. - 5 p.m.
Please remember to bring your laptop!
Location
Center for Business Excellence
49 Commerce Drive, Wyomissing PA 19610
Fees/Admission
$300/person - GRCA Members
$375/person - Future Chamber Members
Website
Contact Information
Mark Dolinski, Vice President Training and Professional Development
Send Email