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
Wednesday Oct 2, 2024
8:00 AM - 10:30 AM EDT
Four weeks on Wednesdays: Oct. 2, 9, 23, and 30
Time: 8 a.m. - 10:30 a.m.
Location
Shearer Technical
727 Penn Ave.
West Reading, PA 19611
Fees/Admission
$300/person - GRCA Members;
$375/person - Future Chamber Members
Website
Contact Information
Mark Dolinski
Send Email