The Intermediate Excel© course builds on the skills learned in Intro to Excel©. Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet! Some functions that will be taught are working with logical formulas, tracking changes, Goal Seek, grouping spreadsheets, working with large spreadsheets and much more. More "fun" functions of Excel© will be learned in the Advanced Excel© course.
Course Outline:
-
Various methods of selecting cells
-
Creating range names
-
Absolute reference
-
Working with logical formulas
-
Conditional formatting
-
Inserting comments
-
Track changes – the snitch report!
-
Working & printing large spreadsheets
-
Using data sort & filters
-
Creating an outline
-
Goal seek
-
Creating scenarios
-
Macros
-
Creating subtotals
-
Grouping spreadsheets
-
Advanced linking of Spreadsheets
Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
Date and Time
Thursday Oct 3, 2024
2:30 PM - 5:00 PM EDT
Four weeks on Thursdays: Oct. 3, 10, 24, and 31
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