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
Tuesday Oct 1, 2024
8:00 AM - 10:30 AM EDT
Four weeks on Tuesdays: Oct. 1, 8, 15, and 22
Time: 8 a.m. - 10:30 a.m.
Location
Shearer Technical Computer Consultants
727 Penn Ave.
West Reading, PA 19611
Fees/Admission
$300/person - GRCA Members
$375/person - Future Chamber Members
Website
Contact Information
Mark Dolinski, Vice President Training and Professional Development
Send Email